IBM Support

PM98341: MISCELLENEOUS DB2 FOR Z/OS INSTALLATION FIXES

A fix is available

Subscribe

You can track all active APARs for this component.

 

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 number

    PM98341

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-10-02

  • Closed date

    2013-12-30

  • Last modified date

    2014-02-05

  • 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.

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
05 February 2014