PM71353: DB2 OBJECT COMPARISON TOOL FOR Z/OS DOES NOT PROCESS IMMEDIATE DEFINITION CHANGE BEFORE PENDING DEFINITION CHANGE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Object Comparison Tool for z/OS does not process immediate
  definition changes before pending definition changes.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison           *
  *                 and DB2 Administration Tool for z/OS         *
  *                 who run Object Compare or use the            *
  *                 'Alter Table ALT' (ALT) function on DB2      *
  *                 10 New Function Mode (NFM), and the          *
  *                 changes to the table space result in         *
  *                 a pending definition change on the           *
  *                 table space.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 Object Compare Tool                 *
  *                      generates the following ALTER           *
  *                      statements in the APPLY                 *
  *                      jobs or Work Statement                  *
  *                      Lists (WSL):                            *
  *                                                              *
  *                      ALTER TABLESPACE                        *
  *                      >dbname>.>tsname<                       *
  *                      BUFFERPOOL nn;                          *
  *                      ALTER INDEX                             *
  *                      >ixschema<.>ixname<                     *
  *                      ADD INCLUDE COLUMN                      *
  *                      colname;                                *
  *                                                              *
  *                      On DB2 10 NFM, altering the             *
  *                      buffer pool of the table space          *
  *                      could result in pending definition      *
  *                      changes on the table space, which       *
  *                      will cause the subsequent ALTER         *
  *                      INDEX statement to fail with a          *
  *                      SQLCODEN20385 /                         *
  *                      SQLCODE=-20385:                         *
  *                                                              *
  *                      DSNT408I SQLCODE = -20385,              *
  *                      ERROR:  THE STATEMENT                   *
  *                      CANNOT BE PROCESSED                     *
  *                      BECAUSE THERE ARE                       *
  *                      PENDING DEFINITION                      *
  *                      CHANGES FOR OBJECT                      *
  *                      >dbname<.>tsname< OF                    *
  *                      TYPE TABLESPACE                         *
  *                      (REASON 14)                             *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DB2 Object Compare Tool generates the following ALTER
  statements in the APPLY jobs or Work Statement Lists
  (WSL):
  
  ALTER TABLESPACE >dbname<.>tsname<
  BUFFERPOOL nn;
  ALTER INDEX >ixschema<.>ixname<
  ADD INCLUDE COLUMN colname;
  
  On DB2 10 NFM, altering the buffer pool of the table space
  could result in pending definition changes on the table space,
  which will cause the subsequent ALTER INDEX statement to
  fail with a SQLCODEN20385 / SQLCODE=-20385:
  
  DSNT408I SQLCODE = -20385, ERROR:  THE STATEMENT
  CANNOT BE PROCESSED BECAUSE THERE ARE
  PENDING DEFINITION CHANGES FOR OBJECT
  >dbname<.>tsname< OF TYPE TABLESPACE
  (REASON 14)
  

Problem conclusion

• Program has been resolved.
  

Temporary fix

Comments

APAR Information

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

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

Modules/Macros

•    ADBCDTS  ADBGAJOB ADBHALT  ADBHC11A ADBTREO
  ADB2CMF  ADB2CMP  ADB2CMR  ADB2CMS  ADB2CMT  ADB25TL1 ADB7000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK91201

     UP13/01/29 P F301

• RA20 PSY UK91202

     UP13/01/29 P F301

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.