A fix is available
APAR status
Closed as program error.
Error description
db2agent seems hang up when db2logmgr is very busy for archiving logfile. . db2agent is waiting for wake up db2logmgr as following stack. DB2 build information: DB2 v8.1.0.128 s061108 SQL08027 <StackTrace> -------Frame------ ------Function + Offset------ 0x09000000020FA6EC sqloWaitEDUWaitPost + 0x184 0x0900000002D34384 sqlpgPostLogManagerWithoutLatch__FP9SQLP_DBCBil + 0x118 0x0900000002D34034 @50@openExtentRetrieve__FP20sqle_agent_privatecbP8SQLP_ACBP10SQL P_ALRCBPP9SQLP_LECBUilT5 + 0xDC 0x0900000002D067E0 sqlpALR_OpenExtent__FP20sqle_agent_privatecbP8SQLP_ACBUi + 0x8F4 0x0900000002D30174 @50@sqlpALR_ReadPagesDisk__FP20sqle_agent_privatecbP8SQLP_ACB - 0xCD8 0x0900000002D2F898 sqlpALR_LoadReadBuffer__FP20sqle_agent_privatecbP8SQLP_ACBPUiT3 - 0x2C0 0x09000000030815EC sqlp_AsyncLogReadAPI__FP20sqle_agent_privatecbUiP8SQLP_LSNT3PcT2 P14SQLP_RLOG_INFOT2P5sqlca + 0xF80 0x09000000030A4E24 sqlpReadLogInternalAPI__FP20sqle_agent_privatecbUiP8SQLP_LSNT3Pc T2P14SQLP_RLOG_INFOT2P5sqlca + 0xF0 0x0900000001EC2308 sqlpReadLogDRDA__FP5sqldaT1P20sqle_agent_privatecbP5sqlca + 0x110 ... . db2logmgr is working for archiving logfile. <StackTrace> -------Frame------ ------Function + Offset------ ... snip ... sqluhReadEntry__F12SQLO_FHANDLEP11SQLUH_ENTRYP14SQLUH_WORKAREAPc N34PUi + 0x150 0x090000000249C024 sqluhUpdate + 0xADC 0x090000000249B194 sqluhUpdateSingle + 0x180 0x09000000030FAE04 sqlpRecordArchiveInHistFile__FP9SQLP_DBCBUlUiN33T2Pc + 0x348 0x0900000003426110 sqlpgArchiveLogFile__FP9SQLP_DBCBUiUlT3PcT3 + 0x7F0 0x09000000030FE650 sqlpgArchivePendingLogs__FP9SQLP_DBCBUlT2PcPUiT5PUlT5 + 0xE8 0x0900000003423640 sqlpgLogManager__FPcUi + 0x784
Local fix
Problem summary
db2agent seems hang up when db2logmgr is very busy for archiving logfile.
Problem conclusion
Problem was first fixed in Version 8.1 FixPak 16
Temporary fix
Comments
APAR Information
APAR number
IZ04802
Reported component name
DB2 UDB WSUE AI
Reported component ID
5765F4300
Reported release
820
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2007-09-14
Closed date
2008-02-05
Last modified date
2008-02-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
IZ05080
Fix information
Fixed component name
DB2 UDB WSUE AI
Fixed component ID
5765F4300
Applicable component levels
R820 PSN
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":"820","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
05 February 2008