IZ64009: PAGE CLEANER CAN CAUSE INTERMITTENT DELAYS OF UPTO ONE MINUTE

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

APAR status

• Closed as program error.

Error description

• A DB2 database server may become intermitently unresponsive with
  delays of up to 1 minute.
  Associated with these delays messages simialr to the following
  maybe written to the db2diag.log :
  
  - SQLB_FIXP "Page Fixed" coming from "sqlpgResSpace, probe:1270"
  - ADM1823E The active log is full
  
  An associated sympton is that minBuffLSN may not be moving up
  for up to one minute.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * DB2 UDB LUW (linux/unix/windows)                             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * A DB2 database server may become intermitently unresponsive  *
  * with                                                         *
  * delays of up to 1 minute.                                    *
  *                                                              *
  * Associated with these delays messages similar to the         *
  * following                                                    *
  * maybe written to the db2diag.log :                           *
  *                                                              *
  *                                                              *
  *                                                              *
  * - SQLB_FIXP "Page Fixed" coming from "sqlpgResSpace,         *
  * probe:1270"                                                  *
  * - ADM1823E The active log is full                            *
  *                                                              *
  *                                                              *
  *                                                              *
  * An associated sympton is that minBuffLSN may not be moving   *
  * up                                                           *
  * for up to one minute.                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Version 9.1 Fix Pack 9                            *
  ****************************************************************
  

Problem conclusion

• Problem was first fixed in Version 9.1 Fix Pack 9
  

Temporary fix

Comments

APAR Information

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

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

  IZ64103 IC64248

Modules/Macros

• SQB
  

Fix information

• Fixed component name

  DB2 UDB ESE HP-

• Fixed component ID

  5765F4103

Applicable component levels

• R910 PSN

     UP