IBM Support

PH06905: NEW FUNCTION

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • New function
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Db2 12 for z/OS users of sample                          *
    * program DSN8ED7,  sample job DSNTEJ6Z, and                   *
    * the Db2-supplied stored procedure                            *
    * SYSPROC.ADMIN_INFO_SYSPARM.                                  *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * This APAR makes the following changes:                       *
    * - adds a Db2-supplied load module and                        *
    * DBRM for DSN8ED7.                                            *
    * - reships the DSN8ED7 source code as                         *
    * member DSN8ED7S.                                             *
    * - modifies DSNTEJ6Z to                                       *
    * - bind and run the Db2-supplied                              *
    * DSN8ED7 by default.                                          *
    * - prepare and bind a local DSN8ED7                           *
    * module and DBRM only by option.                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply corrective PTF when available                          *
    ****************************************************************
    DSN8ED7 is a sample program that shows how to call Db2-supplied
    stored procedure SYSPROC.ADMIN_INFO_SYSPARM.  It can be used to
    obtain a listing of the current settings for Db2's subsystem
    parameter (DSNZPxxx) and application defaults (DSNHDECP)
    parameter settings.
    
    Prior to this APAR, Db2 provided only the C language source
    code for DSN8ED7.  The source code can be prepared using sample
    job DSNTEJ6Z.  However, it is inconvenient for customers who do
    not have access to a C compiler.
    

Problem conclusion

Temporary fix

Comments

  • In response, this APAR adds a Db2-supplied load module and
    DBRM for DSN8ED7.  This change allows any Db2 customer to
    use DSN8ED7 to monitor DSNZPxxx and DSNHDECP parameter
    settings.
    
    As part of this change, the DSN8ED7 source code is now
    provided in member DSN8ED7S.  Also, job DSNTEJ6Z is modified
    to bind and execute DSN8ED7 from the Db2-supplied module and
    DBRM by default.  The DSNTEJ6Z prolog now contains guidance
    on how to modify the job to prepare DSN8ED7 from source code
    member DSN8ED7S.
    
    Applying the fixing PTF for this APAR adds these parts to the
    indicated SMP/E target libraries:
    - prefix.SDSNLOAD(DSN8ED7)
      -> This is the Db2-supplied load module for DSN8ED7
    - prefix.SDSNDBRM(DSN@ED7) alias DSN8ED7
      -> This is the Db2-supplied DBRM for DSN8ED7
    - prefix.SDSNSAMP(DSN8ED7S)
      -> This is the new location of the DSN8ED7 source code
         member.  Prior to this APAR, the source code was in
         member DSN8ED7.
    
    Applying the fixing PTF for this APAR deletes this part from
    the indicated SMP/E target library:
    - prefix.SDSNSAMP(DSN8ED7)
      -> This was the previous location of the DSN8ED7 source
         code member.  Effective with this APAR, the source code
         is in member DSN8ED7S.
    
    This APAR also modifies the DSNTEJ6Z sample job to bind and
    run DSN8ED7 from the Db2-supplied DBRM and load module.  The
    prolog of DSNTEJ6Z contains guidance on how to modify the
    job in order to prepare DSN8ED7 from the sample source code,
    DSN8ED7S.  Previously, this job consisted of 3 job steps as
    follows:
    
        Job step  Description
        ========  ===============================================
        PH06ZS01  Prepare a local DSN8ED7 DBRM and module from
                  source member DSN8ED7
        PH06ZS02  Bind the package and plan for the local DSN8ED7
        PH06ZS03  Run the DSN8ED7 module
    
    This APAR introduces a new format for DSNTEJ6Z:
        Job step  Description
        ========  ===============================================
        PH06ZS01  Optional: Prepare DSN8ED7 from DSN8ED7S
                  -> Uncomment and run this step if you want to
                     compile and link DSN8ED7 from source code.
                     - The DBRM will be placed in the
                       prefix.DBRMLIB.DATA library
                     - The load module will be placed in the
                       prefix.RUNLIB.LOAD library
        PH06ZS02  Optional: Bind a package for DSN8ED7 from the
                  DBRM created by the previous job step
                  -> Uncomment and run this step if you also
                     uncomment and run the previous job step
        PH06ZS03  Bind a package for DSN8ED7 from the
                  Db2-supplied DBRM
                  -> Run this job step even if you also
                     uncomment and run job steps PH06ZS01 and
                     PH06ZS02
        PH06ZS04  Bind the plan for DSN8ED7
        PH06ZS05  Run DSN8ED7 to call SYSPROC.ADMIN_INFO_SYSPARM
                  -> The PH06ZS05 STEPLIB DD allocates the
                     prefix.RUNLIB.LOAD
                     library ahead of the
                     prefix.SDSNLOAD
                     library.  If you want to run the Db2-
                     supplied DSN8ED7 module when
                     prefix.RUNLIB.LOAD
                     also contains DSN8ED7 then you need to
                     remove or comment-out
                     prefix.RUNLIB.LOAD
                     from the PH06ZS05 STEPLIB DD
    

APAR Information

  • APAR number

    PH06905

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    C10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-01-03

  • Closed date

    2019-05-30

  • Last modified date

    2019-07-01

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UI62933

Modules/Macros

  • DSN8ED7S DSN@ED7  DSNTINS3 DSNTEJ6Z DSN8ED7
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RC10 PSY UI62933

       UP19/06/20 P F906

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":"BU050","label":"BU NOT IDENTIFIED"},"Product":{"code":"SSEPEK","label":"DB2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
01 July 2019