|
Problem IC78159
|
Status: Closed |
DB2CLEANCAT MAY REPORT FALSE POSTITIVES FOR ORPHAN ROWS AGAINST SYSROUTINES AND SYSCODEPROPERTIES |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
db2cleancat is an internal tool for cleaning orphan rows in the
system catalog. The utility may report PSM module routine that
are not implemented as orphan rows.
Use the below query to verify if orphan rows truly exists among
SYSIBM.SYSROUTINES and SYSIBM.SYSCODEPROPERTIES:
with properties as (select object_type, object_id, lib_id,
libversion from sysibm.syscodeproperties)
select routineid, lib_id,valid,
implementation from syscat.routines R
where R.implementation = 'db2pvm!pvm_entry'
and
R.MODULEROUTINEIMPLEMENTED <> 'N' and
R.VALID = 'Y' and
not exists
(select P.object_type, P.object_id,
P.lib_id, P.libversion from properties P where
P.object_type = 'F' and P.libversion = 0 and
P.object_id = R.routineid and P.lib_id =
R.lib_id) |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users running db2cleancat on DB2 Version 9.7 GA through Fix *
* Pack 4 on Linux, Unix and Windows. *
****************************************************************
* PROBLEM DESCRIPTION: *
* db2cleancat may return false positives among tables *
* SYSROUTINES and SYSCODEPROPERTIES. *
****************************************************************
* RECOMMENDATION: *
* Request support to send db2cleancat from DB2 Version 9.7 Fix *
* Pack 5 or later. *
**************************************************************** |
| Local Fix: |
Verify the orphan rows returned by db2cleancat using the query
listed in the "Error Description". Need to request for a new
db2cleancat from DB2 support if false positives are found. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
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
|
| Solution |
The problem was first fixed in DB2 Version 9.7 Fix Pack 5. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 16.08.2011
17.01.2012
17.01.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.,
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
