DB2 FOR LUW / DB2FORLUW / 970 - DB2

Enhance the db2cat tool to identify table which may still be 
impacted by the consequences of the APARs: 
 
IZ39997: DROP TABLE FAILING WITH -901 WHICH HAD DEPENDENT 
STATISTICAL VIE WS 
Fixed in DB2 Version 9.1 Fix Pack 7 or higher 
IZ40001: DROP TABLE FAILING WITH -901 WHICH HAD DEPENDENT 
STATISTICAL VIE WS 
Fixed in DB2 Version 9.5 Fix Pack 4 or higher 
 
Although these APARs has already been addressed in this , 
customer 
database/tables may still be impacted by this and can cause 
problem including: 
 
SQL0901N - When trying to DROP TABLE 
SQL0750N - When trying to RENAME TABLE 
SQL0750N - When using ADMIN_TABLE_MOVE Procedure 
 
This Enhancement to the db2cat utility will allow customers to 
check to see if any of the tables may suffer the listed 
consequences and they can look into fixing it.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All Platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to v9.7 Fixpack 6 or Higher                          * 
****************************************************************

To use this enhancement: 
 
db2cat -d <database> -s <schema> -n <table> -v -o <output 
filename> 
 
eg. 
 
db2cat -d db2 -s NEWTON -n T1 -v -o bad.output 
.... 
**************************************************************** 
* 
Validating Packed Descriptor: NEWTON.T1 
 
Orphan dependent MST (count = 0) found in packed descriptor: 
NEWTON.ITEM_STATSVIEW 
 
The above shows that we have a problem on this table.

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
 

Fixed in v9.7 Fixpack 6

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC84179 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

25.11.2011
17.07.2012
17.07.2012

9.7.FP6