PH22848: CM BATCH IMPORT TRIGGER VALIDATE_DDL ADB3014E ADB3002E ADB2WVL COLUMN DOES NOT EXIST NOR KNOWN GLOBAL VARIABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• CM batch import ,with VALIDATE_DDL = 'Y', of a trigger
  referencing a column on a table, may fail validation
  with the following error messages:
  
  ADB3014E ADB2WVL An error occurred while processing the Trigger
   >trigger_name< object in the statement type of
  >statement_type<. The column >column_name< does not
  exist in the table or the table does not
  exist, nor is the column name a known global variable.
  
  ADB3002E ADB2WVL An error occurred while processing the Trigger
  >trigger_name< object in the statement type of
  >statement_type<. The object Table/View >table_name<
  does not exist.
  
  
  
  Keyword:  msgadb3104;msgadb3002E
  

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  *
  *                 who also use triggers.                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: Work statement list (WSL) validation    *
  *                      fails with a parser error while         *
  *                      resolving a table name that is          *
  *                      referenced in a trigger.                *
  ****************************************************************
  A parser error occurs while validating a WSL. The error is
  caused by the failure to resolve a table name that is referenced
  in a trigger object.
  
  ADB3002E ADB2WVL An error occurred while processing the Trigger
  [object_name] object in the statement type of [statement_type].
  The object Table/View [table_name] does not exist.
  
  ADB3014E ADB2WVL An error occurred while processing the Trigger
  [object_name] object in the statement type of [statement_type].
  The column [col_name] does not exist in the table or the
  table does not exist, nor is the column name a known global
  variable.
  

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:

  UI70256

Modules/Macros

• ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI70256

     UP20/07/06 P F006

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.