db2罕见的错误

[Jenjoy]

DB2 SQL error: SQLCODE: -1585, SQLSTATE: 54048, SQLERRMC: null
我在网上搜了半天都没有搜到，下载了一个db2常见的错误文档，也没有找到类似的错误，请各位db2大侠们帮帮解决哈。

[huoyin]

我给你贴过来：

SQL1585N A system temporary table space with sufficient page size does not exist.
Explanation:
One of the following conditions could have occurred:

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.
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错误代码的文章，有空可以参考一下（http://blog.csdn.net/huoyin/category/309585.aspx）

[Jenjoy]

谢谢了楼上的 呵呵 小弟实在太爱国了 英文水平实在是一般。