IBM Support

Extended Rowsize Support when using DB2 10.5 LUW with IBM FileNet Content Platform Engine

Release Notes


Abstract

DB2 10.5 LUW extended rowsize support can now be used to support Content Platform Engine tables with the total sum of column allocation sizes exceeding 32KB. This support requires the IBM FileNet CPE 5.2 FP2 release or later.

Content

Prior to DB2 10.5 LUW, there was a limitation on how many properties could be added to a class because the sum of the column allocation sizes in a table could not exceed the 32KB page size limit. To workaround this limitation, "table overflow" support was added in CE 5.0, whereby if enabled on an object store, an overflow table was created to support additional properties.

DB2 10.5 LUW now supports an extended rowsize. This can allow properties to be created without exceeding the record length limit for the page size, because column allocation sizes are no longer counted against the limit during column creation. If an updated or inserted value results in the sum of the bytes consumed across all columns exceeding the physical record length limit of the page size, a descriptor (24 bytes) to an off-row location is stored in the column instead by DB2.

Extended rowsize is on by default for new DB2 10.5 LUW installations. For databases upgraded to DB2 10.5 LUW and later, from a release prior to DB2 10.5, issue this command to enable extended rowsize support:

UPDATE DATABASE CONFIGURATION FOR dbName USING EXTENDED_ROW_SZ ENABLE

Extended rowsize support is not currently available on DB2 for z/OS.

Support Requirements

Support for DB2 10.5 LUW requires the IBM FileNet CPE 5.2 FP2 release or later.

Behavior of CPE 5.2 FP2 or later with DB2 10.5 LUW

When a new property is added to a class, the CPE will determine if extended row size is enabled for the database. This requires SELECT privileges on a view, which is granted by default:

SELECT ON SYSIBMADM.DBCFG

If extended row size is enabled in DB2, even with table overflow enabled on an object store, no tables will be overflowed by the CPE when a property is added to a class. All columns will be added to the original table.

If extended row size is not enabled, or the view permission has been revoked, systems will behave as before - rows will be limited to 32KB (at column allocation time), and tables will overflow if enabled on an object store.

For systems which have existing overflow tables and have upgraded to DB2 10.5 and have enabled extended row size support, new columns will be added to the original table, not the overflow table. Only if the CPE determines that a property can re-use an existing column which is no longer used, will new properties be associated with the overflow table.

References

For information on indexing for case-insensitive search using DB2 10.5, see this techdoc:
"Indexing for Force Case-Insensitive Search on DB2 10.5 LUW with IBM FileNet Content Platform Engine"
https://www.ibm.com/support/docview.wss?uid=swg27039704

Original Publication Date

26 September 2013

[{"Product":{"code":"SSNVNV","label":"FileNet Content Manager"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Content Engine","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"5.2.1;5.2.0","Edition":"All Editions","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SSGLW6","label":"IBM Content Foundation"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Content Engine","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
17 June 2018

UID

swg27039726