INSERT into a wide table fails with SQL1585N error


When performing an INSERT operation into a wide table that has many long VARCHAR or STRING columns, you may receive the following SQL error:
SQL1585N  A temporary table could not be created because there is no available system temporary 
table space that has a compatible page size.

Resolving the problem

To resolve the problem, change the table definition to use more precise lengths, for VARCHAR and STRING columns in particular, so that the cumulative length of all columns does not exceed the maximum Db2 row size of 1,048,319 bytes. In particular, the STRING data type should be avoided because it maps internally to VARCHAR(32672).