PM69930: DB2 OBJECT COMPARISON TOOL FOR Z/OS ENHANCEMENTS.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• DB2 OBJECT COMPARISON TOOL FOR Z/OS ENHANCEMENTS.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool      *
  *                 for z/OS, FMID H25GA20, who perform source   *
  *                 DDL to target DDL comparisons, or source     *
  *                 DDL to target DB2 catalog comparisons, and   *
  *                 create exclude specifications.               *
  ****************************************************************
  * PROBLEM DESCRIPTION: APAR PM69930 is a rollup APAR for       *
  *                      H25GA20.                                *
  *                                                              *
  *                      The DB2 Object Comparison Tool is used  *
  *                      to perform a source DDL to target DDL   *
  *                      comparison, save the commpare results   *
  *                      on panel ADB2C22 'Save Compare          *
  *                      Results', and submit the compare job.   *
  *                      The 'S-Show summary' line command is    *
  *                      then performed on the saved compare     *
  *                      results on panel ADBPCR 'Manage         *
  *                      Saved Compare Results'. The             *
  *                      'EX-Exclude from source' line           *
  *                      command is performed on the             *
  *                      target object on panel ADBPCRS          *
  *                      'Compare Results', and finally an       *
  *                      exclude specification is created        *
  *                      on panel ADBPCEX 'Create Exclude        *
  *                      Specification', resulting in a          *
  *                      SQLCODE=-104 / SQLCODEN104 error:       *
  *                                                              *
  *                      DSNT408I SQLCODE = -104,                *
  *                      ERROR:  ILLEGAL SYMBOL ",2".            *
  *                      SOME SYMBOLS THAT MIGHT                 *
  *                      BE LEGAL ARE:                           *
  *                      CONCAT || / - + OPTION AT *             *
  *                      ORDER , AS PASSING EMPTY                *
  *                      RETURNING                               *
  *                      DSNT418I SQLSTATE   = 42601             *
  *                      SQLSTATE RETURN CODE                    *
  *                                                              *
  *                      Upon pressing the F3 key to exit from   *
  *                      the error panel ADB2E1 'DB2             *
  *                      Error Display', the Enter key is        *
  *                      pressed on panel ADBPCEX, the           *
  *                      expected panel ADBPCRS 'Compare         *
  *                      Results' is displayed, and the          *
  *                      Merge appears to complete               *
  *                      successfully.                           *
  *                                                              *
  *                      When the DB2 Object Comparison Tool     *
  *                      is used to perform a source DDL to      *
  *                      target DB2 catalog comparison,          *
  *                      upon performing an exclude              *
  *                      specification on the source and target  *
  *                      objects, submitting the compare job,    *
  *                      and running the Work Statement List     *
  *                      (WSL), the job fails with a             *
  *                      SQLCODE=-104 / SQLCODEN104              *
  *                      when the unexpected terminator '?'      *
  *                      (question mark) is appended to the      *
  *                      end of the DROP/CREATE VIEW             *
  *                      statements:                             *
  *                                                              *
  *                      DROP VIEW view_name ?                   *
  *                      COMMIT ?                                *
  *                      DROP view_name ?                        *
  *                      COMMIT ?                                *
  *                                                              *
  *                      DSNT408I SQLCODE = -104,                *
  *                      ERROR:  ILLEGAL SYMBOL "?".             *
  *                      SOME SYMBOLS THAT MIGHT                 *
  *                      BE LEGAL ARE:                           *
  *                      >END-OF-STATEMENT<.                     *
  *                      DSNT418I SQLSTATE   = 42601             *
  *                      SQLSTATE RETURN CODE                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  APAR PM69930 is a rollup APAR for H25GA20.
  
  The DB2 Object Comparison Tool is used to perform a source DDL
  to target DDL comparison, save the compare results on panel
  ADB2C22 'Save Compare Results', and submit the compare job.
  The 'S-Show summary' line command is then performed on the
  saved compare results on panel ADBPCR 'Manage Saved Compare
  Results'. The 'EX-Exclude from source' line command is
  performed on the target object on panel ADBPCRS 'Compare
  Results', and finally an exclude specification is created on
  ADBPCEX 'Create Exclude Specification', resulting in a
  SQLCODE=-104 / SQLCODEN104 error:
  
  DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL ",2".
  SOME SYMBOLS THAT MIGHT BE LEGAL ARE:
  CONCAT || / - + OPTION AT * ORDER , AS PASSING EMPTY
  RETURNING
  DSNT418I SQLSTATE   = 42601 SQLSTATE RETURN CODE
  
  Upon pressing the F3 key to exit from the error panel
  ADB2E1 'DB2 Error Display', the Enter key is pressed on
  panel ADBPCEX, the expected panel ADBPCRS 'Compare Results'
  is displayed, and the Merge appears to complete successfully.
  
  When the DB2 Object Comparison Tool is used to perform a
  source DDL to target DB2 catalog comparison, upon performing
  an exclude specification on the source and target objects,
  submitting the compare job, and running the Work Statement
  List (WSL), the job fails with a SQLCODE=-104 / SQLCODEN104
  when the unexpected terminator '?' (question mark) is appended
  to the end of the DROP/CREATE VIEW statements:
  
  DROP VIEW view_name ?
  COMMIT ?
  DROP view_name ?
  COMMIT ?
  
  DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL "?".
  SOME SYMBOLS THAT MIGHT BE LEGAL ARE:
  >END-OF-STATEMENT<.
  DSNT418I SQLSTATE   = 42601 SQLSTATE RETURN CODE
  

Problem conclusion

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

• Problems have been resolved.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK81324

Modules/Macros

•    GOC$$CCQ GOC$$DSC GOC$$PRM GOC$$SEQ GOCCM2
  GOCFB2VB GOC2CUST
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• RA20 PSY UK81324

     UP12/09/08 P F209

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.