PM13145: (D)COLUMN AAA DROPPED RESULTS IN RELATED OBJECTS LEFT IN CHKP ST ATUS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Object Comparison Tool for z/OS did not build the CHECK
  utilities needed to ensure that related tablespaces were not
  left in Checkpend'ing / CHKP status after columns were dropped
  from a table.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 or the DB2 Object Comparison Tool            *
  *                 for z/OS who run work statement lists        *
  *                 (WSL) or batch jobs that may put an          *
  *                 object into a check-pending state, and       *
  *                 include a CHECK utility to resolve the       *
  *                 condition.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: When an object is placed into           *
  *                      check-pending state and the             *
  *                      CHECKBEGIN/CHECKEND                     *
  *                      process is run to remove the            *
  *                      condition, certain child                *
  *                      table spaces may still be in            *
  *                      the check-pending status.               *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  When the CHECKBEGIN/CHECKEND statements are
  used, the product will perform the CHECK utility on the
  specified table space.  It will then look for child table
  spaces of that specified table space and perform a
  CHECK utility on them if needed.
  
  If multiple child tables exist in a table space, the fetch of
  additional child tables was prematurely ended.  The
  fetch order of the table spaces is not predictable, which
  may cause different results under other circumstances
  (such as same change against similar environments
  or subsystems).
  

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:

  UK62876 UK62877

Modules/Macros

•    ADB2CHK
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK62876

     UP11/02/05 P F102

• R720 PSY UK62877

     UP10/12/11 P F012

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.