DB2 SQL-Error: -670
SQLState: 54010
Short Description: 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. One of following conditions may occur: v 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. v In the case of 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. v In the case of an ALTER TABLE statement used to alter the length of an existing variable length column, the new length of the altered column would cause the row length of the table to exceed the page size of the table space. v The row length in the result of a join exceeds the page size of a work file table space. v The row length of a large sort record exceeds the page size of a work file table space. The sort record includes columns that are being sorted and columns that the user selects. The length of the columns that are being sorted is the sort key length. The length of the columns that the user selects is the sort data length.System action: The statement cannot be executed. The object table was not created or altered. Programmer response: In the case of CREATE TABLE, either (1) the row length of the table must be reduced (by eliminating or reducing the lengths of one or more of the columns), or (2) the table must be assigned to a table space that uses a larger buffer pool (assuming that the row length of the table does not exceed that page size limit). In the case of ALTER TABLE, either (1) the length of the column to be added to the table must be reduced or, (2) if the row length of the table is already at the maximum, the table cannot be altered to add any additional columns. In the case of a row length that exceeds the page size of a work file table space, eliminate columns from the result of the join. In the case of a large sort record in which the row length exceeds the page size of a work file table space, eliminate columns from the SELECT list or reduce the number of columns that are being sorted.