PM57527: WHEN USING GEN ON MQT ENCOUNTERED ERROR MESSAGE ADB1847E A PARSER ERROR OCCURRED FOR THE FOLLOWING MQT. REASON CODE = 8

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• WHEN USING GEN ON MQT ENCOUNTERED ERROR MESSAGE ADB1847E
  A PARSER ERROR OCCURRED FOR THE FOLLOWING MQT. REASON CODE = 8
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use Generate (GEN) on a             *
  *                 Materialized Query Table (MQT) which has a   *
  *                 correlation name for select column and this  *
  *                 correlation name is used in an               *
  *                 order-by-clause.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: Users of the DB2 Administration Tool    *
  *                      for z/OS who use GEN on a MQT table     *
  *                      encountered the error message           *
  *                      ADB1847E:                               *
  *                                                              *
  *                      ADB1847E A parser error occurred for    *
  *                      the following MQT.                      *
  *                                                              *
  *                      GEN does not complete and ends with     *
  *                      Reason code = 8.                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When the MQT table has a correlation name for a select column
  and this correlation name is used in an order-by-clause, GEN
  does not parse the correlation name correctly.
  

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:

  UK77848

Modules/Macros

•    ADB2PA7
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK77848

     UP12/04/13 P F204

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.