IBM Support

PH53885: B37 ON ADBDIAG AND THEN ERROR DOING REVOKE SYSADM

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • User is trying to use IBM Db2 Administration Tool in order to
    revoke unnecessary SYSADM privileges. However, when trying to
    use  Revoke Report first to determine which privileges
    theoretically would be affected. they get the following error
    messages:
    
    IEC030I B37-04,IFG0554A,DBM1SVD,TSUSER2,ADBDIAG,6042,DWRK99,
    SYS23058.T140609.RA000.DBM1SVD.R0101736
    IBM0141S ONCODE=41 The TRANSMIT condition was raised because of
    an uncorrectable
    error in output (FILE= ADBDIAG).
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
    *                                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION: When trying to use the revoke impact    *
    *                      report to a revoke many unnecessary     *
    *                      SYSADM privileges, users may receive a  *
    *                      B37-04 error for the ADBDIAG file even  *
    *                      though they did not set any DEBUG       *
    *                      settings.                               *
    ****************************************************************
    When users are using panels to revoke unnecessary SYSADM
    privileges, they may first ask for the Revoke impact report to
    see what privileges would be affected.  However, the request
    for the report may end in a B37-04 error for File ADBDIAG which
    is usually used for DEBUG purposes.
    

Problem conclusion

  • The problem has been resolved.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH53885

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2023-04-12

  • Closed date

    2023-07-10

  • Last modified date

    2023-08-01

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

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

    UI92667 UI92675

Modules/Macros

  • ADB2RIP
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RC10 PSY UI92667

       UP23/07/13 P F307

  • RD10 PSY UI92675

       UP23/07/13 P F307

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":"12.1.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
01 August 2023