DB2 FOR LUW / DB2FORLUW / 970 - DB2

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)

**************************************************************** 
* 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.                                             * 
****************************************************************

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.

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
 

The problem was first fixed in DB2 Version 9.7 Fix Pack 5.

keiner bekannt / siehe Local-Fix

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

16.08.2011
17.01.2012
17.01.2012

9.7.,
9.7.FP5