IBM Support

PK64301: DB2 SSID JCL ERROR STEPLIB JOBLIB PWH ANLPARM ANLCNTL DD INVALIDDSN LESS THAN 3-CHARACTER

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DB2 ssid less than 4-characters must be correctly generated when
    building JCL for PWH and other batch jobs.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
    *                 users of component:                          *
    *                 -   PE Server                                *
    *                 -   Classic Interface                        *
    *                 -   Performance Warehouse user               *
    ****************************************************************
    * PROBLEM DESCRIPTION: When SQL PA is requested from           *
    *                      Classic Interface for a DB2 subsystem   *
    *                      with a DB2 ssid name shorter than 4     *
    *                      characters the execution of started     *
    *                      job created in the PWH for SQL PA       *
    *                      will fail.                              *
    *                      In the corresponding job output an      *
    *                      error is reported as UNBALANCED         *
    *                      PARENTHESES ON THE DD STATEMENT.        *
    *                                                              *
    ****************************************************************
    * RECOMMENDATION: Apply this PTF                               *
    ****************************************************************
    PROBLEM SUMMARY:
    For PWH SQLPA started job string was concatenated
    out of several strings which were not checked for
    trailing blanks. Thus, the concatenated string
    contained blanks resulting in errors later on.
    
    PROBLEM CONCLUSION:
    When a specified DB2 subsystem ID (SSID) is shorter than
    4 characters the actual length of the DB2 SSID is used.
    

Problem conclusion

  • When a specified DB2 subsystem ID (SSID) is shorter than
    4 characters the actual length of the DB2 SSID is used.
    
    KEYWORDS : PWH DGOZSQPA SQLPA
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK64301

  • Reported component name

    OM XE DB2PE/PM

  • Reported component ID

    5655OPE00

  • Reported release

    410

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2008-04-10

  • Closed date

    2008-06-03

  • Last modified date

    2017-02-04

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

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

    UK37014

Modules/Macros

  •    DGO@SQPA DGOVMSTR DGOZSQPA
    

Fix information

  • Fixed component name

    OM XE DB2PE/PM

  • Fixed component ID

    5655OPE00

Applicable component levels

  • R410 PSY UK37014

       UP08/06/06 P F806

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":"SSAV2B","label":"IBM Db2 Buffer Pool Analyzer for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"410","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCT4H5","label":"IBM Tivoli OMEGAMON XE for Db2 PE \/ PM \/ BPA"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"410","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 February 2017