PM64979: DB2 ADMIN TOOL GEN DOES NOT SUPPORT GENERATING STP DDL WHEN TEXTSTORED IN DDL HAS SQL COMMENT IN BEGINNING OF TEXT FFA20 PM69923

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Adminitration tool for z/OS GEN command does not support
  generating STP DDL when the text stored in DDL contains an SQL
  comment in the first portion of the text
  Additional symtoms:
  IEA995I SYMPTOM DUMP OUTPUT  011
    USER COMPLETION CODE=4039 REASON CODE=00000000
    RUN PROG(ADB2GEN) PLAN(ADB)
  ssid      ENDED DUE TO ERROR+
  SYSTEM ABEND CODE 0C4   REASON CODE 00000004
  IBM0534S ONCODE=8094  Protection exception
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the Generate (GEN) command to   *
  *                 generate Native Stored Procedure (NSP) DDL   *
  *                 when the text stored in DDL contains a SQL   *
  *                 bracketed comment in the first portion of    *
  *                 the text.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 Administration Tool GEN command     *
  *                      did not support generating Native       *
  *                      Stored Procedure (NSP) DDL when the     *
  *                      text stored in the DDL contains an SQL  *
  *                      bracketed comment in the first portion  *
  *                      of the text, and will fail with an      *
  *                      ABEND0C4:                               *
  *                                                              *
  *                      Additional symptoms:                    *
  *                      IEA995I SYMPTOM DUMP                    *
  *                      OUTPUT  011                             *
  *                        USER COMPLETION                       *
  *                      CODE=4039 REASON                        *
  *                      CODE=00000000                           *
  *                        RUN PROG(ADB2GEN)                     *
  *                        PLAN(ADB)                             *
  *                      ssid      ENDED DUE TO                  *
  *                       ERROR+                                 *
  *                      SYSTEM ABEND CODE 0C4                   *
  *                      REASON CODE 00000004                    *
  *                      IBM0534S ONCODE=8094                    *
  *                      Protection exception                    *
  *                                                              *
  *                      The bracketed comment is added before   *
  *                      the 'CREATE PROCEDURE' DDL statement.   *
  *                      The bracketed comment is correct, but   *
  *                      GEN can not generate the DDL statement. *
  *                                                              *
  *                      An example:                             *
  *                      (slash+asterisk SOME COMMENT followed   *
  *                      by asterisk+slash)                      *
  *                      CREATE PROCEDURE  ...                   *
  *                      ...                                     *
  *                                                              *
  *                                                              *
  *                 The example above verbally describing the    *
  *                 format for the SQL bracketed comments (slash *
  *                 +asterisk SOME COMMENT followed by asterisk  *
  *                 +slash) is due to an internal RETAIN issue.  *
  *                 Please translate the verbal description      *
  *                 into valid SQL bracketed comments.           *
  ****************************************************************
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  GEN can not generate the Native Stored Procedure (NSP) DDL
  when the text stored in the DDL contains a SQL comment in the
  first portion of the text.
  

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:

Modules/Macros

•    ADBCDTS  ADB2PA5
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK81227

     UP12/08/24 P F208

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.