-670 THE RECORD LENGTH OF THE TABLE EXCEEDS THE PAGE SIZE LIMIT
Explanation
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:
- Cast specification
- The target length exceeds the maximum limit. The limit is 32764 for a varying length character string result.
- 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.
- 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:
- 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
- The following conditions are possible for an ALTER TABLESPACE statement:
- 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.
- FL 508 In the case of an ALTER TABLESPACE statement with a MOVE TABLE clause, the target table space must be defined with a buffer pool that has a page size that can accommodate the record length of the table that is being moved.
- Join result
- The row length in the result of a join exceeds the maximum limit. The limit is 65,529 bytes 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 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. The length of the columns that are being sorted is the sort key length.
System action
The statement cannot be processed.
Programmer response
Correct the error based on the information provided, and reissue the statement.
SQLSTATE
54010