PM58938: ABND=04E-00E70005 M=DSNTFRCV,LOC=DSNXGRDS.DSNXEPAR:M110 WHEN PROCESSING QUALIFIER """""""AAAAAAA""""""" IN PROCEDURE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS Change Management function
  creates PROCEDURE syntax with additional escape characters, for
  example, input DDL
     QUALIFIER "aaaaaaa"
  
  results in:
     QUALIFIER """""""aaaaaaa"""""""
  When two PROCEDURE's are define in the same unit of work the
  first CREATE PROCEDURE will end with a RC0 however the second
  will cause a DB2 ABEND:
    DUMPID=002 REQUESTED BY JOB (aaaaaaaa)
    DUMP TITLE=ssid,ABND=04E-00E70005,U=aaaaaaa ,M=(N),C=910.RDS
              QL     ,M=DSNTFRCV,LOC=DSNXGRDS.DSNXEPAR:M110
  

Local fix

• Remove the additional quotation marks.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS Change Management function who import   *
  *                 a change that has a 'CREATE PROCEDURE'       *
  *                 statement, and the QUALIFIER and PACKAGE     *
  *                 OWNER keywords have double quotes.           *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      Change Management function generates    *
  *                      the CREATE PROCEDURE statement with     *
  *                      additional escape characters.  For      *
  *                      example, the input DDL:                 *
  *                                                              *
  *                         QUALIFIER "aaaaaaa"                  *
  *                                                              *
  *                      results in:                             *
  *                                                              *
  *                         QUALIFIER """""""aaaaaaa"""""""      *
  *                                                              *
  *                      When two procedures are defined in      *
  *                      the same unit of work the first CREATE  *
  *                      PROCEDURE statement will end with       *
  *                      a RC0, however, the second will cause   *
  *                      a DB2 ABEND04E:                         *
  *                                                              *
  *                        DUMPID=002 REQUESTED BY JOB           *
  *                      (aaaaaaaa)                              *
  *                        DUMP TITLE=ssid,ABND=04E-00E70005,    *
  *                      U=aaaaaaa ,M=(N),C=910.RDSQL     ,      *
  *                      M=DSNTFRCV,                             *
  *                      LOC=DSNXGRDS.DSNXEPAR:M110              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  An invalid CREATE PROCEDURE statement is generated by the
  GOC2DTC program.
  

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:

  UK78054

Modules/Macros

•    ADBCDTS
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK78054

     UP12/04/20 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.