IBM Support

IZ50325: ENHANCE DIAGNOSTIC INFORMATION WHEN AGRESSIVELY FLUSHING PAGES FLUSHING LOGIC IS INVOKED.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Reaching this point does not mean a code problem. Instead,
    this is a warning indicating that despite our earlier
    aggressive attempts to flush the bufferpool several times
    in a row we have failed to move up MinBuffLSN, which means
    that there must be an application holding up this hot
    dirty page for a longer period of time. There is nothing
    we can do about this; the application holding up the page
    should be investigated. We will produce some extended
    diagnostic information here.
    
    db2diag.log sample:
    
    2009-05-05-19.58.56.871940-240 E90316E711         LEVEL: Warning
    PID     : 12009                TID  : 183045175872PROC :
    db2agent (SAMPLE)
    INSTANCE: db2inst1             NODE : 000         DB   : RAWDB
    APPHDL  : 0-11                 APPID: *LOCAL.psustr.090505235827
    AUTHID  : PSUSTR
    FUNCTION: DB2 UDB, data protection services, sqlpgResSpace,
    probe:1270
    MESSAGE : ZRC=0x00020173=131443=SQLB_FIXP "Page fixed during
    hard check point."
    DATA #1 : <preformatted>
    LSNs are:
     copyLowTran    : 0000000003F3B5D6
     copyMinBuff    : 0000000003EDA3CE
     savedCurMinBuff: 0000000003EDA3CE
     flushlsn       : 0000000003EE3FFB
    After flushing buffer pool:
     curMinBuff     : 0000000003EDF3E6
     copyNextLsn    : 0000000003F63F36
    

Local fix

  • n/a
    

Problem summary

  • ENHANCE DIAGNOSTIC INFORMATION WHEN AGRESSIVELY FLUSHING PAGES
    FLUSHING LOGIC IS INVOKED.
    

Problem conclusion

  • Problem was first fixed in Version 9.1 Fix Pack 8
    

Temporary fix

Comments

APAR Information

  • APAR number

    IZ50325

  • Reported component name

    DB2 UDB ESE HP-

  • Reported component ID

    5765F4103

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-05-05

  • Closed date

    2009-10-20

  • Last modified date

    2009-10-20

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

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

    IZ50326 IC63972

Fix information

  • Fixed component name

    DB2 UDB ESE HP-

  • Fixed component ID

    5765F4103

Applicable component levels

  • R910 PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
20 October 2009