Symptom
The IOCP related issue found in the db2diag.log:
===========
2022-05-02-06.23.16.161040-360 E42320681A980 LEVEL: Warning (OS)
PID : 12345 TID : 12345 PROC : db2sysc 0
INSTANCE: db2<sid> NODE : 000 DB : <sid>
HOSTNAME: <hostname>
EDUID : 12345 EDUNAME: db2pclnr (sid) 0
FUNCTION: DB2 UDB, oper system services, sqloLioAIOCollect, probe:22
CALLED : OS, -, GetMultipleCompletionStatus
OSERR : ETIMEDOUT (78) "Connection timed out"
MESSAGE : Incomplete IO requests and unexpected long IOCP wait detected.
DATA #1 : I/O Completion Port, PD_TYPE_IO_PORT, 4 bytes
0x000000E1
2022-05-02-06.23.16.674903-360 E42334402A957 LEVEL: Severe (OS)
PID : 12345 TID : 12345 PROC : db2sysc 0
INSTANCE: db2<sid> NODE : 000 DB : <sid>
HOSTNAME: <hostname>
EDUID : 12345 EDUNAME: db2pclnr (sid) 0
FUNCTION: DB2 UDB, oper system services, sqloLioAIOCollect, probe:21
CALLED : OS, -, GetMultipleCompletionStatus
OSERR : ETIMEDOUT (78) "Connection timed out"
MESSAGE : ALERT - Unexpected long IOCP wait detected.
DATA #1 : I/O Completion Port, PD_TYPE_IO_PORT, 4 bytes
0x000000EE
===========
Read more...
Environment
SAP on IBM Db2 for Linux, UNIX, and Windows
Keywords
I/O Completion Port, ETIMEDOUT, Connection timed out, Unexpected long IOCP wait detected , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview