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.