Hi All,

Please note the error message. When I clicked the tables folder in the
control center the following error msg was thrown. From the user
response I understand that I've to create a system temporary table
space. But If I try to do that also by putting a "alter" syntax, its
throwing the same error. Please advise me on what to do

Error Message:-
*************
[IBM][CLI Driver][DB2/NT] SQL1585N A system temporary table space with
sufficient page size does not exist.
SQLSTATE=54048
Explanation:
One of the following conditions could have occurred:
1. The row length of the system temporary table exceeded the limit
that can be accommodated in the largest system temporary table space in
the database.
2. The number of columns required in a system temporary table
exceeded the limit that can be accommodated in the largest system
temporary table space in the database.

The system temporary table space limits depend on its page size. These
values are:

Max Max Page size of
Record Cols temporary
Length table space
----------- ---- ------------
1957 bytes 244 2K
4005 bytes 500 4K
8101 bytes 1012 8K
16293 bytes 1012 16K
32677 bytes 1012 32K

User Response:

Create a system temporary table space of a larger page size supported,
if one does not already exist. If such a table space already exists,
eliminate one or more columns from the system temporary table. Create
separate tables or views, as required, to hold additional information
beyond the limit.
sqlcode : -1585
sqlstate : 54048



DB2 & UDB email list listserv db2-l LazyDBA home page