IBM Support

PM62166: Some DB2PMSACCT_PROGRAM table columns (prefix PCK_) are null in case of DB2 10 and long names,Acct REPORT might also be affected

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Incorrect output with 3 fields being null when reporting
    accounting information after DB2 V10 conversion mode migration.
    Problem occurred on JCL STPE 3 of SAVE to FILE conversion, ie.
    VSAM to QSAM step.
    .
    In Version 9, positions 2337, 2467, and 2597 of the QSAM file
    contained the Location, Collection-ID, and ID respectively.
    Each is a varchar. In Version 10, all three positions contain
    X'000140', followed by binary zeroes. These fields do exist in
    the VSAM file.
    .
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
    *                 users of component:                          *
    *                 -   Batch Reporting                          *
    *                 -   Performance Database users               *
    ****************************************************************
    * PROBLEM DESCRIPTION: PCK_LOCATION, PCK_COLLECTION_ID,        *
    *                      PCK_ID fieds are empty in               *
    *                      DB2PMSACCT_PROGRAM table                *
    *                                                              *
    ****************************************************************
    * RECOMMENDATION: Apply this PTF                               *
    *                                                              *
    ****************************************************************
    PROBLEM SUMMARY:
    Long names section in save load file is empty in case of short
    names and DB2 V10
    
    PROBLEM CONCLUSION:
    Fill long names section with short names in case if long names
    are absent
    

Problem conclusion

  • Fill long names section with short names in case if long names
    are absent
    
    KEYWORDS : PCK_LOCATION PCK_COLLECTION_ID PCK_ID EMPTY DB2 V10
               DB2PMSACCT_PROGRAM TABLE
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM62166

  • Reported component name

    OM XE DB2PE/PM

  • Reported component ID

    5655OPE00

  • Reported release

    510

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-04-10

  • Closed date

    2012-06-14

  • Last modified date

    2012-07-02

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

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

    UK79604 PM67294

Modules/Macros

  • FPEUFTDS FPEUFTS2
    

Fix information

  • Fixed component name

    OM XE DB2PE/PM

  • Fixed component ID

    5655OPE00

Applicable component levels

  • R510 PSY UK79604

       UP12/06/27 P F206

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

Document Information

Modified date:
02 July 2012