DB2 FOR LUW / DB2FORLUW / 950 - DB2

An ALTER TABLESPACE RESIZE will work as expected during normal 
database operation. During a ROLLFORWARD on a HADR STANDBY or 
after a RESTORE, the same ALTER TABLESPACE RESIZE 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 RESIZE successfully and 
continue as expected. 
 
This can only happen: 
* when an action right before the ALTER TABLESPACE resize the 
high water mark of the tablespace, for example a  DROP TABLE 
statement. 
* and the REsize 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 users of DB2 V9.5                                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* ROLLFORWARD OF ALTER TABLESPACE RESIZE CAN FAIL WITH         * 
* TABLESPACE TOO SMALL                                         * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Restart database for successful run.                         * 
****************************************************************

Restart the database.

DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
 

Upgrade to te fixpack containing this fix.

keiner bekannt / siehe Local-Fix

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

26.07.2011
13.03.2012
13.03.2012