PM60792: MSGADB1932W PARSER ERROR - REASON CODE 28 ISSUED BY ADB2GEN INCORRECTLY MAY LEAD TO STORAGE EXHAUSTION

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ADB1932W Parser error - the original DDL will be generated for
  the following object. Please verify the DDL.
              Reason code = 28
  Additional symptom:
  ONCODE451
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use Generate (GEN) to generate      *
  *                 native stored procedures (NSP).              *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS'   *
  *                      GEN function causes the following       *
  *                      ONCODE451 / ONCODE=451 error that       *
  *                      will cause the GEN function to          *
  *                      terminate unexpectedly:                 *
  *                                                              *
  *                      IBM0451S  ONCODE=451                    *
  *                      The STORAGE condition was raised.       *
  *                      From entry point ADB2PA at statement    *
  *                      1554 at compile unit offset >offset<    *
  *                      at entry offset >offset< at address     *
  *                      >address<.                              *
  *                      ERROR condition was raised.             *
  *                                                              *
  *                      The GEN function can not parse          *
  *                      the fetch-first-clause after a full     *
  *                      select statement, which causes          *
  *                      a warning message ADB1932W:             *
  *                                                              *
  *                      Unexpected token after UR keyword       *
  *                      - expected keyword update-,             *
  *                      read_only-, etc. clause                 *
  *                      Processing Stored Procedure             *
  *                      >stp_schema<.>stp_name<                 *
  *                      version >version_id<                    *
  *                      ADB1932W Parser error -                 *
  *                      the original DDL will be                *
  *                      generated for the following             *
  *                      object.                                 *
  *                                                              *
  *                      Please verify the DDL.                  *
  *                          Reason code = 28                    *
  *                      >stp_schema<.>stp_name<.                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The program to generate stored procedures will exhaust the
  memory and can not parse the fetch-first-clause after a
  full-set statement.
  

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:

  UK82089

Modules/Macros

•    ADB2PA   ADB2REH  ADB2REY
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK82088

     UP12/09/27 P F209

• RA20 PSY UK82089

     UP12/09/27 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.