PK70132: CM COMPARING 2 TABLES CHECK DATA FAILS IN APPLY WITH MSG DSNU214I. FFA10 PM24212

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Object Comparison Tool APPLY job for an ALTER
  COLUMN to a table with a Foreign Key caused the Index to
  be placed in REBUILD PENDING.  As no REBUILD INDEX utility
  was created the CHECK DATA utility requested failed with RC08
  and message: DSNU214I  AAAAA- DSNUGDTC - REBUILD PENDING ON
  INDEX PROHIBITS PROCESSING
  .
  Additional symptoms: msgdsnu214i
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for         *
  *                 z/OS who run work statement lists or         *
  *                 batch jobs that may put an object into       *
  *                 a rebuild-pending or reorg-pending           *
  *                 state.                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: When an ALTER COLUMN                    *
  *                      operation is performed on a             *
  *                      table, an index may be placed into      *
  *                      REBUILD PENDING status.                 *
  *                      Performing a subsequent CHECK           *
  *                      DATA utility operation may fail due     *
  *                      to the restricted state of the index.   *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  A SQLCODE610 indicates that the object has been
  placed into a restricted state.  It is not always possible
  when the job is constructed to know when this will
  occur or if the object will still be in a restricted state
  when a subsequent process (such as the aforementioned
  CHECK DATA utility) is performed.
  

Problem conclusion

• Program ADBTEP2 has been enhanced to detect a
  SQLCODE610 occurrence and to run a REBUILD or
  REORG utility prior to the next non-SQL statement or at
  the end of input if the object is still in a restricted state.
  

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:

  UK61717

Modules/Macros

•    ADBBIND  ADBCHKPT ADBCHU10 ADBTEPI  ADBTEPR
  ADBTEP2  ADBV99   ADB2PSQL ADB27AC  H0IH720J
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK61717

     UP10/11/02 P F011

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.