IBM Support

PI74975: GROUP BUFFER POOL PARAMETER 'CLASS CASTOUT THRESHOLD (PAGES)' MISSING IN PDB

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Group Buffer Pool parameter 'CLASS CASTOUT THRESHOLD (PAGES)'
    missing in PDB
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM *
    *                 performance database (PDB) users             *
    ****************************************************************
    * PROBLEM DESCRIPTION: Group buffer pool parameter "Class      *
    *                      Castout Threshold (Pages)" missing in   *
    *                      Performance Database (PDB) table        *
    *                      DB2PMSYSPAR_230.                        *
    ****************************************************************
    * RECOMMENDATION: Apply the provided PTF.                      *
    ****************************************************************
    IFCID230 field QBGBGCTN (Group buffer pool class level castout
    threshold) has no corresponding column in the DB2PMSYSPAR_230
    PDB table.
    

Problem conclusion

  • Column CLASS_CASTOUT_T_P has been added to PDB table
    DB2PMSYSPAR_230 for the group buffer pool class castout
    threshold when the threshold is a number of pages and not
    a percentage. The table definition is updated and an ALTER ADD
    COLUMN DDL statement is provided to define the new column in
    the table. The DB2 LOAD utility statement for the table has
    been updated as well.
    
    The necessary data was not present in the sequential data set
    Created by the FILE subcommand.  It was added.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI74975

  • Reported component name

    OM XE DB2PE/PM

  • Reported component ID

    5655OPE00

  • Reported release

    540

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-01-17

  • Closed date

    2017-08-09

  • Last modified date

    2017-09-02

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

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

    UI49431

Modules/Macros

  •    DGOWB230 DGOWC230 DGOWD230 DGOWFILE DGOWL230
    DGOWUPDB DGOW1FIL FPEPW230
    

Fix information

  • Fixed component name

    OM XE DB2PE/PM

  • Fixed component ID

    5655OPE00

Applicable component levels

  • R540 PSY UI49431

       UP17/08/11 P F708

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

Document Information

Modified date:
02 September 2017