IBM Support

PM17921: INCORRECT SQL SELECT IN DGOSQGEN INCORRECT MAX NUMBER OF POSSIBLE THREADS BATCH AND PERFORMANCE DATABASE USERS

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Formula for MAX NUMBER OF POSSIBLE THREADS does not reflect the
    calculations in DGOFUCAL.
    
    Correct formula should be:
    
    SELECT (TOT_VAR_STORAGE - TOT_AGENT_SYS_STRG) /
                (ACT_ALLIED_THREADS + ACTIVE_DBATS)
        AS THREAD_FOOTPRINT ,
              (EXT_REG_SIZE_MAX - BIT_EXT_LOW_PRI_31 -
    (200*1024*1024) -
             (TOT_GETM_STORAGE + TOT_GETM_STCK_STOR +
    TOT_FIXED_STORAGE)) /
            ((TOT_VAR_STORAGE  - TOT_AGENT_SYS_STRG) /
                (ACT_ALLIED_THREADS + ACTIVE_DBATS))
        AS MAX_THREADS
        FROM DB2PM_STAT_GENERAL ;
    
    ---------+---------+---------+---------+---------+---------+----
    -----+--
           THREAD_FOOTPRINT              MAX_THREADS
    ---------+---------+---------+---------+---------+---------+----
    -----+--
    +0.1547741866666666E+07  +0.5672012542315412E+03
    

Local fix

  • Please use the correct formula mentioned above.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
    *                 users of component                           *
    *                 - Batch Reporting                            *
    *                 - Performance Database users                 *
    ****************************************************************
    * PROBLEM DESCRIPTION: Formula for MAX NUMBER OF POSSIBLE      *
    *                      THREADS provided in DGOSQGEN member     *
    *                      does not reflect the calculation in     *
    *                      DGOFUCAL.                               *
    ****************************************************************
    * RECOMMENDATION: Apply this PTF                               *
    ****************************************************************
    PROBLEM SUMMARY:
    Formula for MAX NUMBER OF POSSIBLE THREADS provided in DGOSQGEN
    member does not reflect the calculation in DGOFUCAL.
    
    PROBLEM CONCLUSION:
    Provide correct SELECT example in DGOSQGEN
    for MAX NUMBER OF POSSIBLE THREADS.
    
    KEYWORDS:
    DGOSQGEN DB2PM_STAT_GENERAL
    MAX NUMBER OF POSSIBLE THREADS
    

Problem conclusion

  • Provide correct SELECT example in DGOSQGEN
    for MAX NUMBER OF POSSIBLE THREADS.
    
    KEYWORDS:
    DGOSQGEN DB2PM_STAT_GENERAL
    MAX NUMBER OF POSSIBLE THREADS
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM17921

  • Reported component name

    OM XE DB2PE/PM

  • Reported component ID

    5655OPE00

  • Reported release

    420

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-07-07

  • Closed date

    2010-07-27

  • Last modified date

    2010-10-05

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

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

    UK59186 UK59187

Modules/Macros

  • DGOSQGEN
    

Fix information

  • Fixed component name

    OM XE DB2PE/PM

  • Fixed component ID

    5655OPE00

Applicable component levels

  • R410 PSY UK59186

       UP10/08/04 P F008

  • R420 PSY UK59187

       UP10/08/04 P F008

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

Document Information

Modified date:
05 October 2010