Symptoms
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).