DB2 FOR LUW / DB2FORLUW / 970 - 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 user having to REORG using LONGLOBDATA option            * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* see error description above                                  * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to version 9.7 Fixpack 4                             * 
****************************************************************

DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in version 9.7 Fixpack 4

Avoid using the LONGLOBDATA option of REORG unless version 9.7 
Fixpack 4 is installed

Vorgänger  : APAR is sysrouted TO one or more of the following: IC73824 
Nachfolger : 

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

15.11.2010
28.04.2011
28.04.2011

9.7.FP4