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: October 2015
os_minimize_db_row_size.htm

© Copyright IBM Corporation 2015.