PI19851: DB2 ADMINISTRATION TOOL FOR Z/OS CM GENERATES NEEDLESS ALTER IMPLICIT LOB TABLESPACE WHEN ALTERING A COLUMN IN THE BASE TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS generates needless ALTER
  IMPLICIT LOB TABLESPACE when altering a column in the base table
  using Chnage Management function and running the change
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS and DB2 Object Comparison Tool          *
  *                 for z/OS who alter a table containing a      *
  *                 LOB column.                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: When altering a table containing a      *
  *                      LOB column and the change leads         *
  *                      to a DROP/CREATE, an unneeded ALTER     *
  *                      statement was generated in the          *
  *                      CHANGE file and it triggered a          *
  *                      REORG which finally caused the          *
  *                      RUN change job to fail with a           *
  *                      Return Code 8 / RC 8:                   *
  *                                                              *
  *                      The following ADMIN ALTER statement     *
  *                      is executed:                            *
  *                                                              *
  *                      ADMIN ALTER IMPLICIT LOB                *
  *                      TABLESPACE                              *
  *                      FOR TABLE table-name                    *
  *                         COLUMN(lob-column-name)              *
  *                      USING STOGROUP stogroup-name.           *
  *                                                              *
  *                      and invalid REORG syntax is             *
  *                      generated by the ADBTEP2 Batch          *
  *                      Restart Program as a result of          *
  *                      the above 'ADMIN ALTER IMPLICIT         *
  *                      LOB TABLESPACE' statement. The          *
  *                      unneeded REORG causes the               *
  *                      following failure:                      *
  *                                                              *
  *                      DSNU005I    155 >timestamp<             *
  *                      DSNUGPTC - LISTDEF ADBREORG             *
  *                      DSNU049I    155 >timestamp<             *
  *                      DSNUGPTC - INVALID OPERAND              *
  *                      'YESLISTDEF' FOR KEYWORD                *
  *                      'STACK'                                 *
  *                      DSNU005I    155 >timestamp<             *
  *                      DSNUGPTC - INCLUDE TABLESPACES          *
  *                      TABLESPACE >tablespace_name<            *
  *                      DSNU005I    155 >timestamp<             *
  *                      DSNUGPTC - REORG TABLESPACE             *
  *                      LIST ADBREORG                           *
  *                      DSNU005I    155 >timestamp<             *
  *                      DSNUGPTC - SCOPE PENDING                *
  *                      UNLDDN ADBREORG                         *
  *                      DSNU005I    155 >timestamp<             *
  *                      DSNUGPTC - COPYDDN ADBCOPY              *
  *                      DSNU005I    155 >timestamp<             *
  *                      DSNUGPTC - SHRLEVEL REFERENCE           *
  *                      DSNU012I    155 >timestamp<             *
  *                      DSNUGBAC - UTILITY EXECUTION            *
  *                      TERMINATED, HIGHEST RETURN              *
  *                      CODE=8                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The problem is caused a unneeded ALTER statement being
  generated in the CHANGE file which causes the ADBTEP2 Batch
  Restart Program to create invalid REORG syntax.
  

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:

  UI21535 UI21536

Modules/Macros

•    ADB2CMF
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI21535

     UP14/09/24 P F409

• RB10 PSY UI21536

     UP14/09/24 P F409

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.