PM27503: OC PARSER ERROR ON NSP WITH MQT - MSGADB1847E - WARNING : ERROR PARSING DDL NSP STATEMENT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Object Compare Tool for z/OS can produce incorrect CHG file
  for NSP which contains MQT ( Materialized Query Table ). The OC
  compare job fails with rc0 while joblog shows msgadb1847e and
  CHG file contains NSP definition that fails with sqlcoden104 .
  .
  Problem appears to be caused by schema qualifier on MQT table
  name.
  .
  

Local fix

• Edit CHG file to remove schema qualifier from MQT
  name references.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison           *
  *                 Tool for z/OS who use materialized           *
  *                 query tables (MQTs) in Native Stored         *
  *                 Procedures (NSPs).                           *
  ****************************************************************
  * PROBLEM DESCRIPTION: The ADB1847E parser error               *
  *                      message is issued when running          *
  *                      the DB2 Object Comparison Tool.         *
  *                                                              *
  *                      The detailed parser error message       *
  *                      states the expected keyword is AS.      *
  *                      The token in error is a period.         *
  *                      e.g.                                    *
  *                        Expected AS                           *
  *                        Error occurred when parsing the       *
  *                          following stmt :                    *
  *                        CREATE PROCEDURE P1                   *
  *                          BEGIN                               *
  *                        ...                                   *
  *                          END                                 *
  *                                                              *
  *                        Token number =   123, Token = .       *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  The ADB1847E parser error message is issued when
  running the DB2 Object Comparison Tool.
  
  The detailed parser error message
  states the expected keyword is AS.
  The token in error is a period.
  e.g.
    Expected AS
    Error occurred when parsing the
      following stmt :
    CREATE PROCEDURE P1
      BEGIN
    ...
      END
  
    Token number =   123, Token = .
  

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

•    ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK63573

     UP11/02/06 P F102

• R720 PSY UK63574

     UP11/02/06 P F102

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.