Problem:
Creating a table with record length greater than 4K, an error is displayed :-
X139: Record size exceeds the maximum
How can this be avoided?
Resolution:
The default bufferpool for both DB2 and XDB is 4K.
If the record length of the table is greater than 4K, by default, DB2 will return a -670 SQL return code and XDB will return a X139 SQL return code.
To create a table with a record size greater than 4K, either create a tablespace in a 32K bufferpool and then create the table in that tablespace, or create a database that defaults to the 32K bufferpool and then create the table in that database.
Old KB# 2548
#MFDS
#EnterpriseDeveloper
