Troubleshooting
Problem
DB2 page cleaners (db2pclnr) while writing page to the disk also updates the log files. If db2pclnr is not able to update the log file due to DISK FULL condition then DB2 instance will panic and shutdown
Symptom
DB2 instance panic and shutdown
Cause
Active and Archived log directory is full
Diagnosing The Problem
db2pclnr will have the following function stack
sqlbLogErr
sqlbClnrAsyncWriteSetup
SQLO_LIO_HANDLE_DATA::sqloDispatchNBlocks
sqloLioReadWriteNBlocks
sqlbClnrWritePages
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"DB2 Tools - Troubleshooting","Platform":[{"code":"PF002","label":"AIX"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21681684