We are running an app which is exporting a table and are running into this error.
SQL0659N Maximum size of a table object has been exceeded. SQLSTATE=54032
So far we have tried the following:
1) REORG on the table
2) Doubling the size of the DMS tablespace
We have over 800GB of free space available in our SMS tempspaces, so that is not an issue either. We have a case open with IBM support but no far any luck with suggestions.
Anyone ever encountered this issue? It would be nice to see WHAT object it is choking on, instead of just suggesting one of them.
http://publib.boulder.ibm.com/infoce...m0/sql0600.htm
Quote:
SQL0659N Maximum size of a table object has been exceeded.
Explanation: One or more of the objects which make up a table has reached its maximum size. The storage objects that make up a table are:
* Data: This is where basic column data is stored
* Index: This is where all indexes on the table are stored
* Long Data: This is where LONG VARCHAR and LONG VARGRAPHIC column data is stored
* Lob/Lob Allocation: This is where BLOB, CLOB, and DBCLOB column data and control information are stored
Once a storage object has grown to its maximum size, it cannot be extended further.
User Response: To make existing space within the object available to store new data, the following actions may be taken:
* Reorganize the table
* Delete unnecessary rows from the table
* Drop an index from the table
* Update rows to reduce the amount of data (a reorg may be required after this action in order to reclaim unused storage)
sqlcode: -659
sqlstate: 54032
|
dBforums
>
SQL0659N Maximum size of a table object has been exceeded. SQLSTATE=54032
07-16-07, 21:20
Linear Mode
