PI39428: DB2 ADMIN INCORRECTLY PLACES REORGIMP STMT IN RCVR CHG FILE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS incorrectly places REORGIMP
  statement in the RECOVER CHG file generated by Object Compare
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the Change Management (CM)      *
  *                 function to reduce the length of a           *
  *                 VARCHAR column in a table which resides      *
  *                 in an implicit tablespace.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using CM to reduce the length of   *
  *                      a VARCHAR column in a table which       *
  *                      resides in an implicit tablespace,      *
  *                      after analyzing and generating a        *
  *                      RECOVER change, DB2 Admin incorrectly   *
  *                      places the REORGIMP statement in the    *
  *                      RECOVER change file generated by the    *
  *                      Object Compare function:                *
  *                                                              *
  *                      For example:                            *
  *                                                              *
  *                      UTILINFO  ...                           *
  *                      CREATE    ALTER TABLE                   *
  *                                >table_name<                  *
  *                      CREATE    ALTER SURNAME                 *
  *                      SET DATA TYPE VARCHAR(50) ;             *
  *                      CREATE    COMMIT ;                      *
  *                      REORGIMP TABLESPACE                     *
  *                      >tablespace_name< ;                     *
  *                                                              *
  *                      The analyzed job fails with error       *
  *                      message ADB9409E / msgadb9409e:         *
  *                                                              *
  *                      ADB9409E Registration could not         *
  *                      be completed.                           *
  *                                                              *
  *                      Reason Code :         16                *
  *                      Reason  . . : Failed while building     *
  *                                    the delta version.        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The REORGIMP statement is incorrectly generated in the RECOVER
  change file.
  

Problem conclusion

• Problem 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:

  UI27948 UI27949

Modules/Macros

•    GOCCMP
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• RA20 PSY UI27948

     UP15/05/29 P F505

• RB10 PSY UI27949

     UP15/05/29 P F505

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.