|
Problem IC77710
|
Status: Closed |
ROLLFORWARD OF ALTER TABLESPACE RESIZE CAN FAIL WITH TABLESPACE TOO SMALL |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
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 |
| Problem Summary: |
****************************************************************
* 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. *
**************************************************************** |
| Local Fix: |
Restart the database. |
| available fix packs: |
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Upgrade to te fixpack containing this fix. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 26.07.2011
13.03.2012
13.03.2012 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.9
|
 |
