Content Platform Engine, Version 5.2.1   Database:  DB2          

The maximum DB2 row size limit might result in a failed Content Platform Engine upgrade

There is a risk that upgrades to Content Platform Engine will fail because of the DB2® row size limitation.

Symptoms

The upgrade of Content Platform Engine fails with an error message that indicates that the addition of a property to a DB2 table failed.

Causes

The addition of document version object properties and custom object properties in earlier versions of Content Platform Engine caused the row size of the underlying DB2 database to reach or get close to the maximum (32 KB) size. Thus, the addition of another property during the attempted upgrade of Content Platform Engine causes the DB2 row size to exceed the maximum.

Resolving the problem

For DB2 for z/OS®: Back up the database and reduce the amount of metadata in the DB2 schema FileNet® P8 objects before you try the Content Platform Engine upgrade again. If you need assistance in reducing the amount of metadata, contact IBM® Support.

For DB2 for Linux, UNIX and Windows 10.1 and earlier: Upgrade to version 10.5 or later, as this version enables extended rowsize support. See Planning for DB2 for Linux, UNIX and Windows database upgrades for details. If you cannot upgrade your database, then back up the database and reduce the amount of metadata in the DB2 schema FileNet P8 objects before you try the Content Platform Engine upgrade again. If you need assistance in reducing the amount of metadata, contact IBM Support.

For DB2 for Linux, UNIX and Windows 10.5 and later: The upgrade of Content Platform Engine might fail if you did not enable extended rowsize support. See Extended Rowsize Support when using DB2 10.5 LUW with Content Platform Engine for details.



Last updated: October 2015
p8pti007.htm

© Copyright IBM Corporation 2013, 2015.