Troubleshooting
Problem
Customer has 25+ loads job running in parallel and returned DB21018E system error
Symptom
Error message in load application log:
[04066201609012226404523835191144239668427039_04066_nbtjy_D_QHBI132]:201
6-09-01 10:26:884:[INFO]=????:DB21018E A system error occurred.The command line processor could not continue processing.
DB21018E A system error occurred. The command line processor could not
continue processing.
Error message in db2diag.log of node 0:
2016-08-29-23.02.40.339812+480 E696274546A349 LEVEL: Severe (OS)
PID : 12845716 TID : 1 PROC : db2
INSTANCE: **** NODE : 000 HOSTNAME: xxxxx
EDUID : 1
FUNCTION: DB2 UDB, oper system services, sqloForkDaemon, probe:60
CALLED : OS, -, fork
OSERR : EAGAIN (11) "Resource temporarily unavailable"
2016-08-29-23.02.40.342625+480 E696274896A570 LEVEL: Severe (OS)
PID : 11010804 TID : 1 PROC : db2
INSTANCE: **** NODE : 000 HOSTNAME: xxxxx
EDUID : 1
FUNCTION: DB2 UDB, oper system services, sqloForkDaemon, probe:130
MESSAGE : ZRC=0x8300000B=-2097151989
CALLED : OS, -, fork
OSERR : EAGAIN (11) "Resource temporarily unavailable"
DATA #1 : Bitmask, 4 bytes
0x00000004
DATA #2 : String, 105 bytes
Search for ossError*Analysis probe point after this log entry for further
self-diagnosis of this problem.
[04066201609012226404523835191144239668427039_04066_nbtjy_D_QHBI132]:201
6-09-01 10:26:884:[INFO]=????:DB21018E A system error occurred.The command line processor could not continue processing.
DB21018E A system error occurred. The command line processor could not
continue processing.
Error message in db2diag.log of node 0:
2016-08-29-23.02.40.339812+480 E696274546A349 LEVEL: Severe (OS)
PID : 12845716 TID : 1 PROC : db2
INSTANCE: **** NODE : 000 HOSTNAME: xxxxx
EDUID : 1
FUNCTION: DB2 UDB, oper system services, sqloForkDaemon, probe:60
CALLED : OS, -, fork
OSERR : EAGAIN (11) "Resource temporarily unavailable"
2016-08-29-23.02.40.342625+480 E696274896A570 LEVEL: Severe (OS)
PID : 11010804 TID : 1 PROC : db2
INSTANCE: **** NODE : 000 HOSTNAME: xxxxx
EDUID : 1
FUNCTION: DB2 UDB, oper system services, sqloForkDaemon, probe:130
MESSAGE : ZRC=0x8300000B=-2097151989
CALLED : OS, -, fork
OSERR : EAGAIN (11) "Resource temporarily unavailable"
DATA #1 : Bitmask, 4 bytes
0x00000004
DATA #2 : String, 105 bytes
Search for ossError*Analysis probe point after this log entry for further
self-diagnosis of this problem.
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Operating System \/ Hardware - OS Configuration","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"9.7;10.1;10.5;11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
To view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use the link to actual document below to access the full document. You will be asked to log on if you are not already logged in. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
More support for:
Db2 for Linux, UNIX and Windows
Software version:
9.7, 10.1, 10.5, 11.1
Operating system(s):
AIX, Linux, Windows
Document number:
551131
Modified date:
01 May 2025
UID
swg21990025
Manage My Notification Subscriptions