PI90935: DB2 ADMIN TOOL - CM BATCH NO WARNING ON PENDING CHANGES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• CM batch is not turning off the OPT_ANALYZE flag for OC during
  DELTA mode and so the message is skipped.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Adminstration Tool for          *
  *                 z/OS who use CM batch to do compare.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: Message ADB7193I is not issued like     *
  *                      it should be when comparing two         *
  *                      table spaces using CM batch, which      *
  *                      confuses user when shown results.       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Compare of two table spaces using CM batch JCL.
  There is a drop column pending on the source table
  space, i.e., the materializing REORG has not run yet.
  
  AOC takes the pending drop column into account and
  correctly concludes that source and target tables are
  (logically) identical.
  
  However, there is no message indicating that there
  are pending changes. This confuses the user as they
  see 13 columns vs 12 columns in the DB2 catalog.
  Should display message ADB7193I:
  
  ADB7193I There is an outstanding pending change to
  drop specific column. The column will be processed as
  if it was dropped.
  

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:

  UI53291 UI53292

Modules/Macros

•    ADBCCM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI53291

     UP18/01/19 P F801

• RC10 PSY UI53292

     UP18/01/19 P F801

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.