In this post, you’ll learn about the error message -670 the record length of the table exceeds the page size limit in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-670 the record length of the table exceeds the page size limit
Reason for the Error
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 three conditions may occur:� *�� 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. *�� 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. *�� The row length in the result of a join exceeds the page size of a workfile table space.
Solution
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 the 32K byte 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 workfile table space, eliminate columns from the result of the join.
