PH25089: COMPARE TABLESPACE DROPPED ADDED COLUMNS RUN JOB LOAD FAILS INVALID COLUMN SPECIFICATION FOR ADB_IGNOREFIELD_20

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A compare of a tablespace containing a table with one dropped
  column and one additional column may fail during the
  load phase of the run job with the following message:
  
  INVALID COLUMN SPECIFICATION FOR ADB_IGNOREFIELD_20
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS or Db2 Object Comparison Tool for z/OS. *
  ****************************************************************
  * PROBLEM DESCRIPTION: The comparison of a table space that    *
  *                      contains a table with one dropped and   *
  *                      one added column fails in the execution *
  *                      step when executing the LOAD            *
  *                      statement:                              *
  *                                                              *
  *                      INVALID COLUMN SPECIFICATION            *
  *                      FOR ADB_IGNOREFIELD_20                  *
  *                                                              *
  *                      for the dropped DECIMAL column.         *
  ****************************************************************
  When a user tries to run a Change Management (CM) batch job for
  a table with one dropped and one added column,  the LOAD
  statement fails with the following message when trying to
  load a dropped DECIMAL column:
  
  INVALID COLUMN SPECIFICATION
  FOR ADB_IGNOREFIELD_20
  

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:

  UI70854

Modules/Macros

• ADB27AC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI70854

     UP20/08/04 P F008

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.