DB2 FOR LUW / DB2FORLUW / 980 - DB2

REORG TABLE using the LONGLOBDATA option may exhaust all 
available data pages in the table's tablespace. The symptoms 
will also include a "SQL2216N  SQL error -289" and a message in 
db2diag.log which would like follows: 
 
2010-11-09-17.38.38.660474+060 E257310E1114        LEVEL: Error 
PID     : 13003                TID  : 140143897863936PROC : 
db2sysc 0 
INSTANCE: db2inst2             NODE : 000          DB   : 
TC_REORG 
APPHDL  : 0-17276              APPID: 
*LOCAL.db2inst2.101109163712 
AUTHID  : DB2INST2 
EDUID   : 215                  EDUNAME: db2agent (MYDB) 0 
FUNCTION: DB2 UDB, buffer pool services, sqlbAllocateExtent, 
probe:840 
 
MESSAGE : ADM6044E  The DMS table space "TBSPCE1" (ID "3") is 
full.  If this is 
          an autoresize or automatic storage DMS tablespace, the 
maximum table 
          space size may have been reached or the existing 
containers or 
          storage paths cannot grow any more. Additional space 
can be added to 
          the table space by either adding new containers or 
extending existing 
          ones using the ALTER TABLESPACE SQL statement. If this 
is an 
          autoresize or automatic storage DMS table space, 
additional space can 
          be added by adding containers to an autoresize table 
space or by 
          adding new storage paths to an automatic storage 
database.

**************************************************************** 
* USERS AFFECTED:                                              * 
* all using LOB data                                           * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* see error description above                                  * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* this issue will be addressed in a future release.            * 
****************************************************************

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

12.01.2011
07.02.2011
07.02.2011