PI85408: DB2 ADMIN TOOL - CM BATCH COMPARE/ANALYZE THE JOB ENDS WITH RC=16 / SYSPRINT SHOWS ADB2PA PARSER ERROR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• While running a CM BATCH COMPARE/ANALYZE the job ends with
  RC=16 and SYSPRINT shows:
  
     Unexpected <select-element> syntax
  
     ADB2PA: The following statement could not be parsed :
  
     CREATE VIEW ... <view text> ...
  
     Token number =    296, Token = .
     Unsuccessful parse of DDL statement.
  
     ADB2CID - Now terminating
  
     ADB0006E ADBCCM - Error(s) found.  Please review output.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for z/OS    *
  *                 and DB2 Object Comparison Tool for z/OS      *
  *                 who use the Change Management Batch          *
  *                 (CM Batch) interface to submit a job         *
  *                 to import and analyze a change.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: The CM batch job failed with the        *
  *                      following parser error:                 *
  *                                                              *
  *                      ADB2PA: The following statement         *
  *                      could not be parsed.                    *
  *                      Unexpected >select-element< syntax      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When running CM batch to compare two views, the column's table
  name is missing in the change file. This incomplete column
  name caused a parser error.
  

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:

  UI49819 UI49820

Modules/Macros

•    ADB2PA   ADB2PA7
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI49819

     UP17/08/31 P F708

• RC10 PSY UI49820

     UP17/08/31 P F708

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.