PM36913: PARSER ERROR WITH MSG - SYNTAX ERROR DURING STATEMENT SCAN. ERROR OCCURED WHEN PARSING THE FOLLOWING STMT.FFA10 PM30841.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Object Compare Tool for z/OS compare can fail with a
  parser error.
  OC will report the parser issue like it is today.
  The fix will be to not process the view in error
  and therefore avoid OC termination.
  Error messages may appear similar to the following:
  arsing of target view failed
  View will be kept unchanged. Please check view definition
  ADB2PA5.TOKENIZE
  Syntax error during statement scan. Text=@
  ADB2PA5: The following statement could not be parsed :
  .
  CREATE VIEW TESTVIEW1 AS SELECT * FROM ATSIGN1@
  ADB0351E  Module : ADB2CMP detected an ONCODE condition 8094 At
           CREATE_VIEWS
  Additional symptoms may also occur: cc12 rc12 rc04 msgadb0351e
  msgadbc002e
  ADBC002E - Severe error. Compare terminates
  .
  Traceback info indicating module ADB2CMP,
  Entry          Statement  CU offset   Entry offset
  CREATE_VIEWS   5193       +00002E72   +00002E72
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 z/OS who include views existing on the       *
  *                 target only in the compare process and set   *
  *                 the 'Suppress DROP of objects' option to     *
  *                 'YES'.                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: When the 'Suppress DROP of objects'     *
  *                      option is set to 'YES' and a view is    *
  *                      only on the target,  the DB2 Object     *
  *                      Comparison Tool tries to process the    *
  *                      view even when the parsing of the view  *
  *                      fails.  This can lead to the error      *
  *                      message ADB0351E, which reports an      *
  *                      ONCODE8094:                             *
  *                                                              *
  *                      ADB0351E  Module : ADB2CMP              *
  *                      detected an ONCODE condition 8094       *
  *                      At  CREATE_VIEWS                        *
  *                      Additional symptoms may also            *
  *                      occur: cc12 rc12 rc04 msgadb0351e       *
  *                      msgadbc002e                             *
  *                      ADBC002E - Severe error. Compare        *
  *                      terminates                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Object Comparison Tool is trying to process the target
  view which needs to be kept even when the parsing of the view
  fails.
  

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:

Modules/Macros

•    GOC2CMF  GOC2CMP  GOC2CMR  GOC2CMS  GOC2CMT
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R720 PSY UK67991

     UP11/05/26 P F105

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.