HomeDB2DB2 Error Code – -670 the record length of the table exceeds the page size limit

DB2 Error Code – -670 the record length of the table exceeds the page size limit

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.

Share:

Leave a Reply

You May Also Like

In this post, you’ll learn about the error message -952 processing was interrupted by a cancel request from a client...
  • DB2
  • November 21, 2022
In this post, you’ll learn about the error message -927 the langrage interface was called when the connecting environment was...
  • DB2
  • November 21, 2022
In this post, you’ll learn about the error message -926 rollback not valid in ims/vs or cics environment in the...
  • DB2
  • November 21, 2022