|
Problem IC83080
|
Status: Closed |
FURTHER ENHANCEMENTS TO DB2CAT TO CHECK FOR TABLES AFFECTED BY APARS IZ39997 & IZ40001. APAR IC79996 IMPROVEMENT |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
The APAR IC79996: Enhance the db2cat tool to identify table
which may still be impacted by the consequences of the APARs
IZ39997 & IZ40001
Does not detect the situation when we have a regular view of the
same
name as the orphaned MST.
Example:
Dependent MST DESCRIPTION
-------------------------
Schema of the dependent Table : MARIAJ
Table name of the dependent Table : V_TEST
Refresh Option :
MST type : Sts View
Isolation Level : 1
Arithmetic Warning Level : 78
$ db2 drop table test
DB21034E The command was processed as an SQL statement because
it was not a valid Command Line Processor command. During SQL
processing it returned:
SQL0901N The SQL statement failed because of a non-severe
system error. Subsequent SQL statements can be processed.
(Reason "Dependent MST's packed Descriptor not found".)
SQLSTATE=58004
1. If there are no views defined with the same name as the
orphaned statsview , db2cat with APAR IC79996 will report the
corruption:
db2cat -d test_db -s mariaj -n test -v
****************************************************************
Validating Packed Descriptor: MARIAJ .TEST
Orphan dependent MST (count = 0) found in packed descriptor:
MARIAJ .V_TEST
2.
If we have a view with the same name (it does not need to have
the same columns) as the Orphan dependent MST, the db2cat
enhanced with APAR IC79996 will not detect this corruption.
db2 create view v_test as select c1,c3 from test
****************************************************************
Validating Packed Descriptor: MARIAJ .TEST
No Corruption Detected.
----------------------------------------------------------------
This APAR will make additional improvements to db2cat so the
corruption is detected in both cases. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 and Fix Pack 7 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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
|
| Solution |
Problem was first fixed in DB2 Version 9.7 and Fix Pack 7 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC87854
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 02.05.2012
20.10.2012
20.10.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.7
|
 |
