IBM Support

PH63655: ALLOW TO SPECIFY THE USERID THAT CALLS SYSPROC.ADMIN_INFO_SYSPARM

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • A parmlib parameter should allow to choose on behalf of which
    userid Db2 HPU invokes the SYSPROC.ADMIN_INFO_SYSPARM Db2 stored
    procedure. This allows to avoid giving the MONITOR1 privilege,
    required to call this stored procedure, to the submitter of the
    Db2 HPU step.
    
    This capability is useful when the setting of Db2 HPU implies
    the invocation of SYSPROC.ADMIN_INFO_SYSPARM which occurs if any
    of the following conditions is true:
    
        the VUU100/ENBHIST parmlib parameter is set to= AS_DB2_ZPARM
    
        the value of the VUU030/ULOPTNS parmlib parameter contains
    USE_ADMIN_INFO_SYSPARM(YES).
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 High Performance Unload for     *
    *                 z/OS                                         *
    ****************************************************************
    * PROBLEM DESCRIPTION: allow to specify the userid that calls  *
    *                      SYSPROC.ADMIN_INFO_SYSPARM              *
    ****************************************************************
    * RECOMMENDATION: Apply the PTF                                *
    ****************************************************************
    (HPU 5.2 only)
     A parmlib parameter should allow to choose on behalf of which
    userid Db2 HPU invokes the SYSPROC.ADMIN_INFO_SYSPARM Db2
    stored procedure. This allows to avoid giving the MONITOR1
    privilege, required to call this stored procedure, to the
    submitter of the Db2 HPU step.
    
    This capability is useful when the setting of Db2 HPU implies
    the invocation of SYSPROC.ADMIN_INFO_SYSPARM which occurs if
    any of the following conditions is true :
    - the VUU100/ENBHIST parmlib parameter is set to AS_DB2_ZPARM
    - the value of the VUU030/ULOPTNS parmlib parameter contains
    USE_ADMIN_INFO_SYSPARM(YES).
    

Problem conclusion

  • Code has been changed to fix this problem
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH63655

  • Reported component name

    DB2 HI PERF UNL

  • Reported component ID

    5697F4400

  • Reported release

    520

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / New Function / Xsystem

  • Submitted date

    2024-10-09

  • Closed date

    2024-11-20

  • Last modified date

    2024-12-03

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

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

Modules/Macros

  • INZ$$PRM INZCHECK INZTDSC  INZTPMEM INZUTILK
    

Fix information

  • Fixed component name

    DB2 HI PERF UNL

  • Fixed component ID

    5697F4400

Applicable component levels

  • R520 PSY UI99095

       UP24/11/23 P F411  

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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"520","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
03 December 2024