Troubleshooting
Problem
Starting instance on Windows DB2 server gets error: SQL1042C An unexpected system error occurred or SQL1022C There is not enough memory available to process the command
Symptom
db2diag.log logs below messages: 2012-02-09-18.18.54.009000-300 E92834H421 LEVEL: Error (OS) PID : 3248 TID : 3256 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 EDUID : 3256 FUNCTION: DB2 UDB, oper system services, sqloGetAccountSID, probe:30 MESSAGE : ZRC=0x83000534=-2097150668 CALLED : OS, -, LookupAccountName OSERR : 1332 "No mapping between account names and security IDs was done." 2012-02-09-18.18.54.009000-300 I93257H297 LEVEL: Severe PID : 3248 TID : 3256 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 EDUID : 3256 FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:450 MESSAGE : ZRC=0x83000534=-2097150668
Another type of symptom is SQL1022C returned from db2start
2019-01-01-12.29.00.052000-240 I35844860F467 LEVEL: Event
PID : 1234 TID : 2792 PROC : db2syscs.exe
INSTANCE: DB2INST1 NODE : 000
HOSTNAME: ibmtest
EDUID : 2792
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:5659
MESSAGE : ZRC=0xFFFFFC02=-1022
SQL1022C There is not enough memory available to process the
command.
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"Security \/ Plug-Ins - IBM Suplied\/Default","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.8;9.7;9.5;9.1;11.1;10.5;10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Log InLog in 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 Log in button above to access the full document. 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
Modified date:
30 April 2025
UID
swg21584354