IBM FileNet P8, Version 5.2.1            

Minimize database row sizes

Some databases have a maximum byte limit for the row length. Because each property that you create becomes a table column, you can exceed the row size limitation and receive an error when adding more property definitions to a class.

Start of changeFor row size limits for supported database engines, see Database Engine Differences.End of change

For databases that have a maximum row size limit, users and application designers must take care to limit the number and size of the properties that are assigned to a class. The following suggestions can help you to avoid exceeding the row size limit.

To calculate row size for existing DB2® tables, see Determine database row size.

If the maximum row size limit is exceeded, you can take the following steps:


Last updated: March 2016
os_minimize_db_row_size.htm

© Copyright IBM Corporation 2016.