IBM Support

PK64483: OC PERFORMS DROP/CREATE INSTEAD OF ALTER TABLE ALTER PARTITION

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • OC performs DROP/CREATE instead of ALTER TABLE ALTER PARTITION
    

Local fix

  • APPLY PTF.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Object Compare.                     *
    ****************************************************************
    * PROBLEM DESCRIPTION: Clarification of Run SQLID is required  *
    *                      on help panel GOC5H.                    *
    ****************************************************************
    * RECOMMENDATION: Apply The PTF.                               *
    ****************************************************************
    Clarification of Run SQLID is required on help panel GOC5H. The
    following text has been added:Note:If a Run SQLID is specified,
    this sqlid will be the owner of databases and table spaces.  If
    the  specified Run  SQLID is different from  the current owner,
    databases  and table spaces (and all dependent objects) will be
    dropped and recreated to accomplish the change of owner.
    

Problem conclusion

  • Incident is now resolved.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK64483

  • Reported component name

    DB2 OBJECT COMP

  • Reported component ID

    5697G6400

  • Reported release

    720

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-04-15

  • Closed date

    2008-10-08

  • Last modified date

    2008-11-04

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

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

Modules/Macros

  •    GOC5H
    

Fix information

  • Fixed component name

    DB2 OBJECT COMP

  • Fixed component ID

    5697G6400

Applicable component levels

  • R720 PSY UK40599

       UP08/10/16 P F810

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":"720","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 November 2008