PH07201: CM BATCH COMPARE ANALYZE VALIDATE DOES NOT FLAG ERROR CREATE TRIGGER INSERT INTO TABLE CREATE INDEX COLUMN NOT EXIST

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The CM Batch Compare ANALYZE job does not flag the following
  errors when VALIDATE is set (e.g., VALIDATE_WSL or VALIDATE_DDL
  is set to 'Y'):
  Issue #1: A CREATE TRIGGER statement which references an INSERT
  INTO table that does not exist.
  Issue #2: A CREATE INDEX statement on a new table that
  references a column that does not exist.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool         *
  *                 for z/OS and the Db2 Object Comparison       *
  *                 Tool for z/OS.                               *
  ****************************************************************
  * PROBLEM DESCRIPTION: CM Batch or Compare ANALYZE job         *
  *                      with VALIDATE set does not flag         *
  *                      invalid CREATE statements.              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  This APAR addresses two issues with ANALYZE jobs
  with VALIDATE set (for example, Validate_WSL=-Y- or
  Validate_DDL='Y'):
  
  1. VALIDATE should identify and report errors for
  CREATE TRIGGER statements that reference
  non-existent INSERT INTO tables.
  
  2. VALIDATE should identify and report errors for
  CREATE INDEX statements on a new table that
  reference a column that does not exist.
  

Problem conclusion

• Problems have 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:

  UI62946

Modules/Macros

•    ADB2WVL
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI62946

     UP19/05/15 P F905

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.