IBM Support

JR31686: MIGRATION FROM V8.1 OR V8.2 TO V9.1 MAY CAUSE ORPHANED ROWS IN CATALOG TABLE SYSIBM.SYSCOLDIST

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The problem was caused by the removal of the
    SYSIBM.SYSPROCOPTIONS catalog table in v9.1.
    
    Corresponding statistics on
    SYSPROCOPTIONS from SYSIBM.SYSCOLDIST we migrated table as
    is, which may lead to orphan rows. Other catalog tables
    recording column statistics that may also be affected are:
    SYSCOLGROUPS, SYSCOLGROUPSCOLS, SYSCOLGROUPDIST,
    SYSCOLGROUPDISTCOUNTS.
    

Local fix

  • Contact support to run db2cleancat utility
    

Problem summary

  • MIGRATION FROM V8.1 OR V8.2 TO V9.1 MAY CAUSE ORPHANED ROWS IN
    CATALOG TABLE SYSIBM.SYSCOLDIST
    

Problem conclusion

  • First fixed in DB2 UDB Version 9, FixPak 8
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR31686

  • Reported component name

    DB2 UDB ESE WIN

  • Reported component ID

    5765F4101

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-01-15

  • Closed date

    2009-10-15

  • Last modified date

    2009-10-15

  • 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 UDB ESE WIN

  • Fixed component ID

    5765F4101

Applicable component levels

  • R910 PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 October 2021