-670   THE RECORD LENGTH OF THE TABLE EXCEEDS THE PAGE SIZE LIMIT

The row length for a table cannot exceed the page size of the table space in which that table resides (or is to reside). The page size of the table space is determined by the buffer pool used by that table space. This error can result from one of the following conditions:

Table creation

The following conditions are possible for a CREATE TABLE statement:

• As defined in a CREATE TABLE statement, the row length for the table would exceed the page size of the specified (or default) table space. To correct this situation, either:
  • Reduce the row length of the table by reducing the length of one or more of the columns.
  • Assign the table to a table space that uses a larger buffer pool.
• The LOB column with INLINE LENGTH clause has contributed to exceeding the page size limit.

Table alteration

The following conditions are possible for an ALTER TABLE statement:

• Addition of the specified column would cause the row length of the table to exceed the page size of the table space. This table cannot be altered to add columns.
• The statement was issued to alter the length of an existing variable-length column and the new length of the altered column would cause the row length of the table to exceed the page size of the table space.
• The LOB column with an INLINE LENGTH clause has contributed to exceeding the page size limit.

To correct this situation, reduce the length of the column.

Table space alteration

In the case of an ALTER TABLESPACE statement that is used to alter the buffer pool to a smaller page size, the row length for one of the tables in the table space exceeds the new smaller page size.

Join result

The row length in the result of a join exceeds the maximum limit. The limit is 65,529 bytes in new-function mode or approximately the maximum page size in conversion mode. The sort record includes columns that are being sorted and columns that the user selects. The length of the columns that the user selects is the sort data length.

Sort result

The following conditions are possible for a sort result:

• The row length of a large sort record exceeds the maximum limit. The limit is 65,529 bytes in new-function mode or approximately the maximum page size in conversion mode. The sort record includes columns that are being sorted and columns that the user selects. The length of the columns that the user selects is the sort data length.
• The sort key length for a sort exceeds the maximum limit. The limit is 32,000 bytes in new-function mode or 16,000 bytes in conversion mode. The length of the columns that are being sorted is the sort key length.