|
Problem IC84179
|
Status: Closed |
Enhance the db2cat tool to identify table which may still be impacted by the consequences of the APARs IZ39997 & IZ40001 |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
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. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All Platforms *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to v10.1 Fixpack 1 or Higher *
**************************************************************** |
| Local Fix: |
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. |
| available fix packs: |
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
|
| Solution |
First Fixed in v10.1 Fixpack 1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 13.06.2012
13.11.2012
13.11.2012 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.1
|
 |
| 10.5.0.1
|
|
