IBM Support

IZ50432: FAILURE TO FLUSH CERTAIN DIRTY PAGES MAY LEAD TO ADM1822W MESSAGES BEING REPORTED.

Fixes are available

DB2 Version 9.1 Fix Pack 8  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The bufferpool flushing logic which fullfills the SOFTMAX
criteria
does not take into account "hot" pages (held up by applications)
and
therefore pages holding up the minbufflsn may be skipped and not
flushed.
This can lead to ADM1822W messages being reported in the
db2diag.log, e.g.

2009-03-02-03.58.15.684263+060 E21868047A697 LEVEL: Warning
PID : 2875 TID : 1 PROC : db2agent (SAMPLE) 0
INSTANCE: db2inst1 NODE : 000 DB : (SAMPLE
APPHDL : 0-2040 APPID: 10.21.25.91.65042.090302023522
AUTHID : db2inst1
FUNCTION: DB2 UDB, data protection services, sqlpgResSpace,
probe:1660
MESSAGE : ADM1822W The active log is being held by dirty pages.
This is not
an error, but database performance may be impacted. If possible,
reduce the database work load. If this problem persists, either
decrease the SOFTMAX and/or increase the NUM_IOCLEANERS DB
configuration parameters.

Local fix

  • Defect v9.1: wsdbu00340136
Defect v9.5: wsdbu00539779

Problem summary

  • FAILURE TO FLUSH CERTAIN DIRTY PAGES MAY LEAD TO ADM1822W
MESSAGES BEING REPORTED.

Problem conclusion

  • First Fixed in DB2 v9.1 Fixpack 8

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IZ50432
    • 

  • 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-27
    • 

  • Last modified date
    2009-10-27
    • 





    

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

    • 

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

    
IZ50433
    

    • 



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:
            

            27 October 2009
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback