Planning for Db2 for Linux, UNIX and Windows database upgrades
Review upgrade requirements for Db2 for Linux, Unix, and Windows databases.
Before you begin
For minimum version and fix pack requirements, see IBM® FileNet® P8 system requirements.
In some cases, it is possible to exceed the maximum rowsize of 32 KB for the Content Platform Engine database during the upgrade. See the technote Adding properties to a class with the IBM FileNet Content Engine on DB2 receives error stating that the length exceeds the capacity of the database (Technote 21384306) for information about diagnosing and resolving the problem for a Content Engine database. Use the diagnosis steps from the technote before you upgrade to determine how close the database is to exceeding the row size, and the resolution steps to reduce the amount of row size space being used before you upgrade.
Databases that are used for Content Platform Engine must be configured with a minimum of 32 KB page sizes and a UTF-8 code page.
Procedure
To install Db2 for Linux, UNIX and Windows and create DB2® instances:
What to do next
UPDATE DATABASE CONFIGURATION FOR dbName USING EXTENDED_ROW_SZ ENABLE
SELECT
privilege
(granted by default) on a view:SELECT ON SYSIBMADM.DBCFG
If extended row size is enabled for a Db2 for Linux, UNIX and Windows database, even if table overflow is enabled on an object store, Content Platform Engine does not overflow tables when you add a property to a class. That is, all columns are added to the original table.
If extended row size is not enabled for a Db2 for Linux, UNIX and Windows database, or if you revoked the view permission, rows are limited to 32 KB (at column allocation time), and Content Platform Engine overflows tables if overflow is enabled on an object store.
If your system has existing overflow tables and you upgraded to Db2 for Linux, UNIX and Windows 10.5 (or later), and you enabled extended-row-size support, Db2 for Linux, UNIX and Windows adds new columns to the original table, not the overflow table. Content Platform Engine associates new properties with the overflow table only if it determines that a property can reuse an existing column that is no longer used.