LI72977: DB2PGCLNR WILL LEAK QUEUE OF AIO.

DB2 Version 9.5 Fix Pack 3b for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 2a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 2  for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4  for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• db2pgclnr will open queue using io_queue_init when open file.
  However db2pgclnr does not remove queue while db2pgclnr has
  gone.
  Therefore AIO queue will be increase, if AIO queue exceed
  aio_max_nr, io_queue_init will return
  EAGAIN.
  EAGAIN will be occur when aio_nr > aio_max_nr.
  You will see the following messages in db2diag.log
  
  2007-12-17-23.26.11.572841+540 E30653G310         LEVEL: Error
  (OS)
  PID     : 23641                TID  : 3086718656  PROC :
  db2pclnr 0
  INSTANCE: db2inst1             NODE : 000
  FUNCTION: DB2 UDB, oper system services, sqloLioInit, probe:10
  CALLED  : OS, -, io_queue_init                    OSERR: EAGAIN
  (11)
  

Local fix

Problem summary

• db2pgclnr will open queue using io_queue_init when open file.
  However db2pgclnr does not remove queue while db2pgclnr has
  gone.
  Therefore AIO queue will be increase, if AIO queue exceed
  aio_max_nr, io_queue_init will return
  EAGAIN.
  EAGAIN will be occur when aio_nr > aio_max_nr.
  You will see the following messages in db2diag.log
  
  2007-12-17-23.26.11.572841+540 E30653G310         LEVEL: Error
  (OS)
  PID     : 23641                TID  : 3086718656  PROC :
  db2pclnr 0
  INSTANCE: db2inst1             NODE : 000
  FUNCTION: DB2 UDB, oper system services, sqloLioInit, probe:10
  CALLED  : OS, -, io_queue_init                    OSERR: EAGAIN
  (11)
  

Problem conclusion

• First fixed in DB2 UDB Version 9.5, FixPak 2
  

Temporary fix

Comments

APAR Information

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

  LI72961

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

Fix information

• Fixed component name

  DB2 UDE ESE LIN

• Fixed component ID

  5765F4104

Applicable component levels

• R950 PSN

     UP