PH12185: CM BATCH COMPARE IMPORT ANALYZE ALTER TABLE DROP COLUMNAME (WITHOUT COLUMN KEYWORD) ADB8044I NO OBJECTS TO PROCESS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• If a CM Batch or Compare change includes an 'ALTER TABLE
  tablename DROP columname' statement (where the statement does
  not specify the keyword 'COLUMN'), ANALYZE reports ADB8044I 'No
  objects to process.'  This ALTER statement is valid, however,
  as the keyword 'COLUMN' is actually optional.  With this APAR
  applied, the statement is processed as a change.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS and DB2 Object Comparison Tool for      *
  *                 z/OS                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: DDL reader does not process an          *
  *                      'ALTER TABLE table_name DROP            *
  *                      column_name RESTRICT'                   *
  *                      statement.                              *
  ****************************************************************
  DDL reader does not process an 'ALTER TABLE table_name
  DROP COLUMN column_name RESTRICT' statement
  when the COLUMN keyword (which is optional) is omitted.
  As a result, the ANALYZE job issues ADB8044I 'No
  objects to process.' With this APAR applied the statement
  will be processed.
  

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:

  UI64659

Modules/Macros

• ADBCDTS
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI64659

     UP19/08/10 P F908

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.