IBM Support

PK31148: FILTER EXCESSIVE IFCID150 RECORDS COMING TO DB2 IFI READS INTERNAL BUFFER

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When very many threads compete for resources of DB2 subsystems
    being monitored by Omegamon Server, an excessive number of
    IFCID150 records may be created refering to resources holding or
    waiting for locks. As a consequence, these records may overflow
    the DB2 IFI READS internal buffer being used by Omegamon Server
    to hold current snapshots coming from the DB2 subsystems. This
    may prevent gathering of whole snapshot data in the 4MB size
    limited buffer.
    
    
    FPEV9999I PTFS/ 05.118 V210
    FPEV9999I ADRS/032A
    FPEV9999I PSW /078D0000 801C8432
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
    *                 users of component:                          *
    *                 _   PE Server                                *
    ****************************************************************
    * PROBLEM DESCRIPTION: When very many threads compete for      *
    *                      resources of DB2 subsystems             *
    *                      being monitored by Omegamon Server, an  *
    *                      excessive number of IFCID150 records    *
    *                      may be produced referring to resources  *
    *                      holding or waiting for locks. As a      *
    *                      consequence, these records may overflow *
    *                      the DB2 IFI READS internal buffer being *
    *                      used by Omegamon Server to hold current *
    *                      snapshots coming from the DB2           *
    *                      subsystems. This may prevent gathering  *
    *                      of whole snapshot data in the 1MB/4MB   *
    *                      size limited buffer.                    *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The issue specified in the "Problem description" field may cause
    appearance of the "Return area is too small" indicator when
    Performance Expert client user is being performing functions
    requesting thread details to be present in the DB2 snapshots.
    

Problem conclusion

  • The solution given allows to eliminate duplicate IFCIDs 150
    coming with DB2 snapshots and littering the DB2 IFI READS
    Return Area. The filtering process takes place when:
    
    1.THREAD LOCKING is being collected (the SNAPSHOTHISTORY
      and SHTHREADLOCK startup parameters are set to "Y" )
    
    or/and:
    
    2.PE Server is running and users of Performance Expert
      Client or ISPF Monitoring dialogs are performing one
      of the following functions:
    - Thread Summary when at least one condition of the
      ICLUDE / INCLUDE filter is set;
    - Thread Details;
    - Thread in Locking Conflicts;
    - Locking Conflicts
    
    
    KEYWORDS : RETURN AREA IS TOO SMALL IFCID 150
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK31148

  • Reported component name

    OM XE DB2PE/PM

  • Reported component ID

    5655OPE00

  • Reported release

    310

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2006-09-11

  • Closed date

    2007-01-31

  • Last modified date

    2007-02-02

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

    PK23842

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

    PK38442 UK21651

Modules/Macros

  •    DGO@DB2I DGOVDB2F DGOVDB2I
    

Fix information

  • Fixed component name

    OM XE DB2PE/PM

  • Fixed component ID

    5655OPE00

Applicable component levels

  • R310 PSY UK21651

       UP07/02/01 P F701

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

Document Information

Modified date:
02 February 2007