PM79011: CORRECT THE EXPLANATION OF THE OPTION "CONTENT OF APPLY JOB(S)" ON THE PANEL GOC5H

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Correct the explanation of the option "Content of apply job(s)"
  on the panel GOC5H.
  

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:

  UK91199 UK91200

Modules/Macros

•    GOC5H
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• RA10 PSY UK91199

     UP13/01/29 P F301

• RA20 PSY UK91200

     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.