IBM Support

IC78159: DB2CLEANCAT MAY REPORT FALSE POSTITIVES FOR ORPHAN ROWS AGAINST SYSROUTINES AND SYSCODEPROPERTIES

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error 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)
    

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.
    

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

Problem conclusion

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

Temporary fix

Comments

APAR Information

  • APAR number

    IC78159

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-08-16

  • Closed date

    2012-01-17

  • Last modified date

    2012-01-17

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 January 2012