IBM Support

PK67682: DB2 OBJECT COMPARE REBUILD INDEX IF OPTION DEFER=YES IS CHOSEN.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • DB2 OBJECT COMPARE REBUILD INDEX IF OPTION DEFER=YES IS CHOSEN.
    OC DOES NOT GENERATE A REORG FOR A MAXROW WHEN "ALL RELEVANT"
    SPECIFIED THEREFORE ONLY NEW ROWS EFFECTED BY CHANGES
    

Local fix

  • APPLY PTF.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users  of DB2  Admin &  Object Comparison    *
    *                 Tool who uses masking function to specify    *
    *                 overwrites DSSIZE, PRIQTY, SECQTY,  DEFER    *
    *                 and DEFINE for table space or index space    *
    *                 attributes.                                  *
    ****************************************************************
    * PROBLEM DESCRIPTION: Overwrite masks DSSIZE, PRIQTY, SECQTY, *
    *                      DEFER  and DEFINE are  not supported in *
    *                      functions COMPARE, GEN, MIGRATE and  CM *
    *                      IMPORT.  Overwrite  masks DSSIZE, DEFER *
    *                      and  DEFINE  are not  supported in  the *
    *                      function WSL CLONING.                   *
    ****************************************************************
    * RECOMMENDATION: Apply The PTF.                               *
    ****************************************************************
    New overwrites DSSIZE, PRIQTY, SECQTY, DEFER and DEFINE are
    supported  in all masking related  functions  COMPARE, GEN,
    MIGRATE, WSL CLONING and CM IMPORT.
    Masking allows to specify the above 5 overwrites in two below
    formats -:
     (1) Direct overwrite value
     (2) Rexx user exit format.
    
    The details of masking overwrite formats can be viewed in the
    Admin user guide (V72) .
    
    Admin need to be  customized by the Admin installer,by invoking
    ADB2CUST exec, to tell Admin the data set name of the rexx exit
    library where rexx user exits can be made available.
    

Problem conclusion

Temporary fix

Comments

  • The problem has been fixed in V7.2 only.
    

APAR Information

  • APAR number

    PK67682

  • Reported component name

    DB2 OBJECT COMP

  • Reported component ID

    5697G6400

  • Reported release

    720

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-06-16

  • Closed date

    2008-10-08

  • Last modified date

    2009-11-30

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

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

Modules/Macros

  •    GOCCMP   GOC2CMF  GOC2CMP  GOC2CMR  H25G720J
    

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:
12 February 2021