Perl CGI Scripts - DB2 SQL0670N
Error Troubleshooting
SQL0670N - The row length of the table exceeded a limit
of "4005" bytes (Tablespace "USERSPACE1".) SQLSTATE
= 54010
The following list shows the maximum row sizes for each page size:
Max Row Size Page Size
4005 4K
8101 8K
16293 16K
32677 32K
Solution1: Reduce the number of VARCHAR fields to be created within
the DB2 table.
Solution2: Each VARCHAR column can be created with a width
of up to 32672 characters in size. By default, CGIScripter creates DB2
tables using VARCHAR(255) columns for variable sized character data.
A limited number of columns of this size may be created in each table.
Adjust the table creation SQL commands to insure that the total number
of characters for all columns do not exceed 4005 bytes or create the
table in a tablespace with a higher page size.
Solution3: Large text columns can be stored as CLOB columns
within DB2. CLOB columns are not counted toward the maximum row size
limit. Consider converting some VARCHAR columns to CLOB columns to work
around maximum row size limitations.
