|
Problem IC72575
|
Status: Closed |
REORG TABLE USING THE LONGLOBDATA OPTION MAY RETURN "SQL2216N SQL ERROR "-289" |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All user having to REORG using LONGLOBDATA option *
****************************************************************
* PROBLEM DESCRIPTION: *
* see error description above *
****************************************************************
* RECOMMENDATION: *
* Upgrade to version 9.7 Fixpack 4 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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
|
| Solution |
First fixed in version 9.7 Fixpack 4 |
| Workaround |
Avoid using the LONGLOBDATA option of REORG unless version 9.7
Fixpack 4 is installed |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC73824
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 15.11.2010
28.04.2011
28.04.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
