PM98341: MISCELLENEOUS DB2 FOR Z/OS INSTALLATION FIXES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Miscelleneous DB2 for z/OS installation and samples fixes
  (1) DB2 9, 10, 11: DSNTEJ66 job step PH066S06 ends with return
      code 12 and these messages
        ERROR: Call to DSN8ES3 failed
        -----> Processing halted
          DSNT408I SQLCODE =   -438, SQLSTATE = 38601, EXTERNAL
                   FUNCTION EXCEPTION FROM SQL ROUTINE TOKENS
                   Unexpected SQLCODE -407        from INSERT
  (2) DB2 9, 10: SYSPROC.DSNWZP and SYSPROC.ADMIN_INFO_SYSPARM
      return a truncated setting for the DSN6SYSP.MON parameter
  (3) DB2 9, 10, 11: DSNTIJXZ / DSNTXAZP always sets the
      GRPATTNM setting to NULL.
  (4) DB2 9, 10, 11: The SYSPROC.ADMIN_INFO_SYSPARM stored
      procedure, the SYSPROC.DSNWZP stored procedure, and
      DSNTIJXZ / DSNTXAZP assigns NONE as the setting of the
      DSN6ARVP.UNIT2 parameter when that parameter is set to
      blank or null.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of the following in DB2 9 for      *
  *                 z/OS, DB2 10 for z/OS, and DB2 11 for z/OS   *
  *                 are affected by this change:                 *
  *                 - Stored procedures SYSPROC.DSNWZP and       *
  *                   SYSPROC.ADMIN_INFO_SYSPARM                 *
  *                 - Installation job DSNTIJXZ, program         *
  *                   DSNTXAZP                                   *
  *                 - IVP job DSNTEJ66, sample native SQL        *
  *                   procedure DSN8.DSN8ES3                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: (1) DB2 9 and 10: SYSPROC.DSNWZP,       *
  *                          SYSPROC.ADMIN_INFO_SYSPARM, and     *
  *                          DSNTXAZP can return a truncated     *
  *                          setting for DB2 subsystem parameter *
  *                          DSN6SYSP.MON.                       *
  *                      (2) DB2 9, 10, 11: SYSPROC.DSNWZP,      *
  *                          SYSPROC.ADMIN_INFO_SYSPARM, and     *
  *                          DSNTXAZP return NONE instead of     *
  *                          blanks as the setting for DB2       *
  *                          subsystem parameter DSN6ARVP.UNIT2  *
  *                          when that parameter is set to       *
  *                          blank or null.                      *
  *                      (3) DB2 9, 10, 11: DSNTXAZP always      *
  *                          returns NULL as the setting of      *
  *                          GRPATTNM, the DSNTIDxx tracking     *
  *                          item for the DB2 data sharing       *
  *                          group attach name.                  *
  *                      (4) DB2 9, 10, 11: DSNTEJ66 job step    *
  *                          PH066S06 ends with return code 12   *
  *                          and these messages:                 *
  *                            ERROR: Call to DSN8ES3 failed     *
  *                            -----> Processing halted          *
  *                              DSNT408I SQLCODE =   -438,      *
  *                              SQLSTATE = 38601, EXTERNAL      *
  *                              FUNCTION EXCEPTION FROM SQL     *
  *                              ROUTINE TOKENS                  *
  *                              Unexpected SQLCODE -407         *
  *                              from INSERT                     *
  ****************************************************************
  * RECOMMENDATION: Apply the fixing PTF for this APAR.          *
  ****************************************************************
  This APAR addresses the following issues:
  
  (1) DB2 9 and 10: SYSPROC.ADMIN_INFO_SYSPARM, SYSPROC.DSNWZP,
      and DSNTXAZP can return a truncated setting for DB2
      subsystem parameter DSN6SYSP.MON.
  
      - SYSPROC.ADMIN_INFO_SYSPARM and SYSPROC.DSNWZP are DB2-
        supplied stored procedures that return the current
        settings of DB2 subsystem and DSNHDECP parameters.
  
      - DSNTXAZP is a program that can be used to refresh a DB2
        CLIST input (DSNTIDxx) member with DB2's current subsystem
        parameter, DSNHDECP parameter, and buffer pool settings.
  
      Currently, in DB2 9 and 10, these programs can truncate the
      setting of the DSN6SYSP.MON subsystem parameter when it is
      a list of monitor trace classes to be started automatically
      during DB2 startup.
  
  (2) DB2 9, 10, 11: SYSPROC.ADMIN_INFO_SYSPARM, SYSPROC.DSNWZP,
      and DSNTXAZP return NONE instead of blanks as the setting of
      DB2 subsystem parameter DSN6ARVP.UNIT2 parameter when that
      parameter is set to blank or null.
  
      The DSN6ARVP.UNIT2 specifies the device type or unit name
      that is to be used for storing the second copy of archive
      log data sets.  It can also be set to blank or null, which
      is the default setting.  Currently, the programs noted
      above report the UNIT2 setting as NONE when it is blank or
      null.
  
  (3) DB2 9, 10, 11: DSNTXAZP always returns NULL as the setting
      of GRPATTNM, the DSNTIDxx tracking item for the DB2 data
      sharing group attach name.
  
      The DB2 data sharing group attach name is an optional
      parameter that specifies a generic group attachment name
      for use by batch programs, the call attachment facility
      (CAF), the RRS attachment facility (RRSAF), IMS, CICS
      Transaction Server for z/OS, and utilities.  Currently,
      DSNTXAZP always returns the setting as NULL even if a
      group attach name has been specified.
  
  (4) DB2 9, 10, 11: DSNTEJ66, job step PH066S06, ends with return
      code 12 and these messages:
        ERROR: Call to DSN8ES3 failed
        -----> Processing halted
          DSNT408I SQLCODE =   -438, SQLSTATE = 38601, EXTERNAL
                   FUNCTION EXCEPTION FROM SQL ROUTINE TOKENS
                   Unexpected SQLCODE -407        from INSERT
  
      DSNTEJ66 creates a native SQL procedure called DSN8.DSN8ES3
      that can be used to generate and return a CREATE PROCEDURE
      statement for a specified stored procedure.  DSNTEJ66 also
      prepares and executes a sample caller of DSN8ES3 called
      DSN8ED9.  Currently, DSN8ES3 can fail with the symptoms
      noted above when operating on a stored procedure that was
      created prior to DB2 9.  The error occurs because such
      stored procedures have an extra row in the SYSIBM.SYSPARMS
      table to record a CCSID or information about varying-length
      character parameters.  The extra row is not expected by
      DSN8ES3 so the failure occurs when it encounters one.
  

Problem conclusion

• In response, this APAR makes the following changes:
  
  (1) DB2 9 and 10: SYSPROC.ADMIN_INFO_SYSPARM, SYSPROC.DSNWZP,
      and DSNTXAZP are fixed to return the full setting for DB2
      subsystem parameter DSN6SYSP.MON.  The full setting is
      already returned in DB2 11.
  
  (2) DB2 9, 10, 11: SYSPROC.ADMIN_INFO_SYSPARM, SYSPROC.DSNWZP,
      and DSNTXAZP are fixed to return blank instead of NONE for
      DSN6ARVP.UNIT2 parameter when that parameter is set to blank
      or null.
  
  (3) DB2 9, 10, 11: DSNTXAZP is fixed to set the GRPATTNM item
      in DSNTIDxx to the DB2 data sharing group attach name if
      one is defined.  Otherwise, GRPATTNM will be set to NULL.
  
  (4) DB2 9, 10, 11: DSN8ES3 is fixed to account for a possible
      extra row in SYSIBM.SYSPARMS for a stored procedure.
  

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:

  UI13936 UI13937 UI13938

Modules/Macros

• DSN@XAZP DSNTXAZP DSNWZIFA DSNWZIFB DSNWZIF9 DSN8ES3
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI13936

     UP14/01/17 P F401

• RB10 PSY UI13937

     UP14/01/17 P F401

• R910 PSY UI13938

     UP14/01/17 P F401

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.