Review upgrade requirements for DB2® for Linux, UNIX and Windows databases.
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. Versions of Process Engine before version 5.0 supported smaller page sizes. Older versions of Process Engine also supported additional code pages. Use the procedures in the techdoc How to determine if your Process Engine DB2 database has the correct tablespace pagesize and/or code page for upgrading to Process Engine 5.0 (Techdoc 7020392) to determine whether page size or code page changes are required before you upgrade to version 5.2.1.
To install DB2 for Linux, UNIX and Windows and create DB2 instances:
UPDATE DATABASE CONFIGURATION FOR dbName USING EXTENDED_ROW_SZ ENABLE
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.