DB2 FOR LUW / DB2FORLUW / A10 - 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 v10.1 Fixpack 1 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 10.1 Fix Pack 1 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

First Fixed in v10.1 Fixpack 1

keiner bekannt / siehe Local-Fix

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

13.06.2012
13.11.2012
13.11.2012