home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC91261 Status: Closed

DB2TOP INACCURATELY REPORTS TABLESPACE STATUS INSTEAD OF "MOVE IN
PROGRESS" AND "REDISTRIBUTE IN PROGRESS" DURING ITS RESIZE

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
db2top utility inaccurately reports tablespace status during its 
resize. It reports state as "Unknown [0x80000]" instead of text 
that customer might expect: "Move in Progress". "Redistribute in 
progress" - [0x40000] is also affected.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* db2top utility                                               * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 9.7 Fix Pack 10                       * 
****************************************************************
Local Fix:
Use output from table space state command which translate 
numeric code into meaningful description : 
$ db2tbst 0x80000 
State = Move in Progress 
$ db2tbst 0x40000 
State = Redistribute in Progress
Solution
Fixed in DB2 version 9.7 Fix Pack 10
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
03.04.2013
13.11.2014
13.11.2014
Problem solved at the following versions (IBM BugInfos)
9.7.FP10
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.10 FixList