IBM Support

PI83063: DB2 ADMIN TOOL / AOC GENERATES UTILITY RELATED DATASETS USING &ZUSER INSTEAD OF PREFIX FOR SYSERR AND SYSPRINT.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The generated JCL from Work Statement List has &ZUSER instead
    of PREFIX for SYSERR and SYSPRINT
    
    PREFIX was specified on the Tool Customizer for DB2 Admin V12
    

Local fix

  • To get around the issue, update SADBSLIB(ADB2UCUU):
    From:
    )SET ASYSER1 = &ZUSER..SYSERR
    to:
    )SET ASYSER1 = &PREFIX..SYSERR
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 Administration Tool             *
    *                 for z/OS.                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: The IBM Tools Customizer for z/OS       *
    *                      parameter:                              *
    *                                                              *
    *                      'HLQ of utility data sets . . PREFIX'   *
    *                                                              *
    *                      does not manage the Admin Tool          *
    *                      generated utility datasets to use       *
    *                      &zprefix as the High Level Qualifier.   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The fix will allow the DB2 Admin Tool Utility function to
    honor the following IBM Tools Customizer for z/OS
    parameter setting:
    
     HLQ of utility data sets . . . PREFIX
    
    This gives the Administrator of DB2 Admin Tool the
    provision to conditionally manage the Admin Tool
    generated utility data sets to use TSO PROFILE
    PREFIX setting as the High Level Qualifier
    

Problem conclusion

  • Problem has been resolved.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI83063

  • 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

    2017-06-15

  • Closed date

    2017-09-22

  • Last modified date

    2017-10-02

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

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

Modules/Macros

  •    ADB2U
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RB20 PSY UI50554

       UP17/09/26 P F709

  • RC10 PSY UI50555

       UP17/09/26 P F709

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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
02 October 2017