IBM Support

PK18764: OBJECT COMPARE INCORRECTLY UPDATES TABLE AND INDEX PARTITION INFORMATION

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Object Compare incorrectly generated updated for a partitioned
    table and index that was identical to the catalog entry.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 Object Comparison Tool, who     *
    *                 compare  Partition  Tables  and Indexes,     *
    *                 may be affected.                             *
    ****************************************************************
    * PROBLEM DESCRIPTION: Table and Index Partition Information   *
    *                      was incorrectly updated.                *
    *                      .*                                      *
    *                      Object Compare  incorrectly generated   *
    *                      updates for a  Partitioned  table and   *
    *                      index  that  was  identical  to   the   *
    *                      catalog entry.                          *
    *                      .*                                      *
    *                      Incorrect  changes  were  made  in an   *
    *                      identical partition table and index.    *
    *                      .*                                      *
    *                      Starting  with DB2 V8 the patitioning   *
    *                      index does  not have to be clustered.   *
    *                      Processing  of PART keyword specified   *
    *                      after NOT CLUSTER was missing.          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    See Problem Description.
    

Problem conclusion

  • Apply the fix.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK18764

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    710

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2006-01-27

  • Closed date

    2006-04-22

  • Last modified date

    2006-05-01

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

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

Modules/Macros

  •    GOC2DTC
    

Fix information

  • Fixed component name

    DB2 OBJECT COMP

  • Fixed component ID

    5697G6400

Applicable component levels

  • R310 PSY UK13805

       UP06/04/29 P F604

  • R710 PSY UK13806

       UP06/04/28 P F604

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAUVH","label":"IBM Db2 Object Comparison Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"710","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
01 May 2006