Confluence 2.6 : Known Issues for DB2
This page last changed on Aug 29, 2007 by don.willis@atlassian.com.
DB2 Does Not Support Unicode Character By DefaultTo support the Unicode character set, create your database like this: db2 create database <name> using codeset utf-8 territory us pagesize 8 k Before 8.2.2 db2 create database <name> using codeset utf-8 territory us db2 drop tablespace userspace1 db2 create bufferpool bufpool8k <number of pages> pagesize 8 k db2 create tablespace userspace1 pagesize 8 k managed by database using \(file \'<location>\' <number of pages>\) bufferpool bufpool8k The territory may not be important when using UTF-8, but it must be included. DB2 Does Not Support Transaction Logging Of BLOBs Larger Than 1GB
<property name="body" type="com.atlassian.confluence.core.persistence.hibernate.CustomClobType" update="true" insert="true" column="BODY" length="1073741824" /> Configuring Database Character EncodingRefer to Configuring Database Character Encoding. DB2 Dialect class change (if upgrading from Confluence version 2.2 or older)If you are using DB2, and are upgrading Confluence from version 2.2 or older, the 'hibernate.dialect' property in the confluence.cfg.xml file needs to be changed to 'com.atlassian.hibernate.dialect.DB2Dialect' like so:
<property name="hibernate.dialect">com.atlassian.hibernate.dialect.DB2Dialect</property> Encoding Test ProblemsAt the time of writing this, there is an open bug with the encoding test when using DB2. Details are here: CONF-8588. Transaction Isolation Level of Read UncommittedDue to CONF-9323, DB2 requires a transaction isolation level of "read uncommitted" to avoid occasional deadlocks. The more concurrent usage a Confluence instance experiences, the higher the frequency of deadlocks with a transaction isolation level higher than "read uncommitted". Related Links |
![]() |
Document generated by Confluence on Oct 10, 2007 18:49 |