IBM Support

PM63304: TCZ SPECIFIED COMMAND PROCEDURES LIBRARY IS USED FOR BOTH STEPLIB AND SYSPROC DSN IN GENERATED JCL

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • During SQLPA configuration in the Tools Customizer (TCz).
    The "Command procedures library" specified on the
    TCz "LPAR Parameters" panel is materialized as the DSN for
    both the DD's STEPLIB and SYSPROC in some generated JCL.
    Additional Symptom:
    2- Generated customization jobs create incorrect data set names
    with &TEMP rather than correct dsname of &&TEMP.
    

Local fix

  • Delete or comment out the extraneous STEPLIB DD.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    *                 All users of SQL Performance Analyzer v4.1   *
    *                                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    *                      1- Same library is used for             *
    *                         STEPLIB and SYSPROC.                 *
    *                      2- For temporary datasets &TEMP         *
    *                         being used rather than &&TEMP.       *
    *                                                              *
    ****************************************************************
    * RECOMMENDATION: APPLY the PTF.                               *
    ****************************************************************
    Code has been changed to correct this condition.
    

Problem conclusion

  • Apply the PTF for problem resolution.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM63304

  • Reported component name

    DB2 SQL PERF AN

  • Reported component ID

    5697F5701

  • Reported release

    410

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2012-04-25

  • Closed date

    2012-07-16

  • Last modified date

    2012-08-09

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

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

    UK80329

Modules/Macros

  •    ANLCAFSP ANLCLODS ANLCRE8I ANLCRE8J ANLCVCLS
    ANLLCHPD ANLWLMSP
    

Fix information

  • Fixed component name

    DB2 SQL PERF AN

  • Fixed component ID

    5697F5701

Applicable component levels

  • R410 PSY UK80329

       UP12/07/18 P F207

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.

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

Document Information

Modified date:
17 March 2021