PK92925: CM LOB TABLE STOGROUP CHANGE RESULTS IN RC12 AUX TABLES ARE PROCESSED WITH THE BASE TABLE. PLEASE INCLUDE THE BASE TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Object Comparison Tool for z/OS users using the Change
  Management feature to compare complete source DDL for a LOB/AUX
  structure set to implement a USING STOGROUP change found that
  ANALYZE job failed RC12 with a message:
  Compare tablespace source(DB09637.LB21053) and
  target(DB09637.LB21053)
      (A)Field USING changed from 'STOGROUP SYSDEFLT' to 'STOGROUP
  SGXXXXX'
    Tablespace will be altered
  Aux tables are processed with the base table. Please include the
  base table in source and target.
  GOCC002E - Severe error. Compare terminates
  

Local fix

• Do not use the Change Management feature.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool             *
  *                 for z/OS who use Change                      *
  *                 Management to alter a LOB table              *
  *                 space or an auxiliary table.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: During analyze the Object               *
  *                      Compare program issues                  *
  *                      the following error message:            *
  *                                                              *
  *                      GOCC002E - Severe error.                *
  *                      Compare terminates.                     *
  *                                                              *
  *                      Processing stops, and                   *
  *                      the auxiliary tables are                *
  *                      processed with the base                 *
  *                      table. Please include the               *
  *                      base table in the source                *
  *                      and target.                             *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  The base table information needs to be included in
  the version file generated by the ADB2GEN
  program.
  

Problem conclusion

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

Modules/Macros

•    ADBCVOB  ADB1000  ADB2C11A ADB2RE   ADB2REE
  ADB2REM  ADB2REZ
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK55333

     UP10/03/24 P F003

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.