DB2 FOR LUW / DB2FORLUW / 970 - DB2

An ALTER TABLESPACE REDUCE will work as expected during normal 
database operation. During a ROLLFORWARD on a HADR STANDBY or 
after a RESTORE, the same ALTER TABLESPACE REDUCE can fail with 
SQLB_TBSPACE_TOO_SMALL. The database will be marked bad due to 
this error. After a restart of the database, the ROLLFORWARD 
will finish the ALTER TABLESPACE REDUCE successfully and 
continue as expected. 
 
This can only happen: 
* when an action right before the ALTER TABLESPACE reduces the 
high water mark of the tablespace, for example a   DROP TABLE 
statement. 
* and the REDUCE shrinks the tablespace below the previous high 
water mark (before the DROP TABLE). 
 
The following message can be found in the db2diag.log file: 
 
2011-01-25-17.29.04.069318-300 I542180A638        LEVEL: Error 
PID     : 1663102              TID  : 5182        PROC : db2sysc 
INSTANCE: xxxx               NODE : 000         DB   : SAMPLE 
APPHDL  : 0-10                 APPID: *LOCAL.xxxxx.110125222809 
AUTHID  : xxxxx 
EDUID   : 5182                 EDUNAME: db2redom (SAMPLE) 
FUNCTION: DB2 UDB, buffer pool services, 
sqlbValidateContOpsMain, probe:150 
MESSAGE : ZRC=0x8002013A=-2147352262=SQLB_TBSPACE_TOO_SMALL 
          "Cannot reduce tablespace size as requested" 
DATA #1 : <preformatted> 
useablePages is less than the High Water Mark 
useablePages = 9998 
HighWaterMark = 19472

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See error description above.                                 * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 5.                       * 
****************************************************************

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 DB2 Version 9.7 Fix Pack 5.

keiner bekannt / siehe Local-Fix

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

27.01.2011
08.12.2011
08.12.2011

9.7.FP5