IBM Support

Spectrum Protect Server fails to start with ANR0169E SQL12225N

Troubleshooting


Problem

Startup of the Spectrum Protect server may fail with the following error:
SQL1225N  The request failed because an operating system process, thread, or swap space limit was reached.  SQLSTATE=57049

Symptom

The following output may be seen when the server fails to start:
ANR0172I rdbdb.c(2516): Error encountered performing action ActivateDatabase.
ANR0162W Supplemental database diagnostic information:  -1225:SQLSTATE 57049:
The operating system process limit has been reached.:-1225 (SQL1225N  The request
failed because an operating system process, thread, or swap space limit was reached.  SQLSTATE=57049).
ANR0171I dbiconn.c(1936): Error detected on 0:1, database in evaluation mode.
ANR0169E An unexpected error has occurred and the IBM Spectrum Protect server is stopping.
ANR0162W Supplemental database diagnostic information:  -1:57049:-1225 ([IBM][CLI Driver] SQL1225N 
The request failed because an operating system process, thread, or swap space limit was reached.  SQLSTATE=57049
In the db2diag.log you may see the following errors when the server fails to start:
 2019-11-14-15.40.12.347963+660 E33174E486            LEVEL: Severe
PID     : 119306               TID : 139867115742976 PROC : db2sysc 0
INSTANCE: tsminst1             NODE : 000
HOSTNAME: tsmserver.local
FUNCTION: DB2 UDB, oper system services, sqloEDUEntry, probe:10
CALLED  : DB2 UDB, oper system services, sqloGetShrEDUWaitElem
RETCODE : ZRC=0x850F0081=-2062614399=SQLO_SSEM_EXCEED_MAX
          "Requesting too many semaphores"
          DIA8336C Requested too many semaphores.
2019-11-14-15.40.12.348786+660 I34782E599            LEVEL: Error
PID     : 119306               TID : 139898816292608 PROC : db2sysc 0
INSTANCE: tsminst1             NODE : 000            DB   : TSMDB1
APPHDL  : 0-7                  APPID: *LOCAL.tsminst1.191114043955
AUTHID  : TSMINST1             HOSTNAME: tsmserver.local
EDUID   : 18                   EDUNAME: db2agent (TSMDB1) 0
FUNCTION: DB2 UDB, base sys utilities, sqeAgent::startAgent, probe:2846
RETCODE : ZRC=0x870F00F2=-2029059854=SQLO_NORES
          "no resources to create process or thread"
DATA #1 : signed integer, 4 bytes
1
2019-11-14-15.40.12.349020+660 I35382E640            LEVEL: Severe
PID     : 119306               TID : 139898816292608 PROC : db2sysc 0
INSTANCE: tsminst1             NODE : 000            DB   : TSMDB1
APPHDL  : 0-7                  APPID: *LOCAL.tsminst1.191114043955
AUTHID  : TSMINST1             HOSTNAME: tsmserver.local
EDUID   : 18                   EDUNAME: db2agent (TSMDB1) 0
FUNCTION: DB2 UDB, base sys utilities, sqeAgentServices::RequestAgentForAppl, probe:2163
RETCODE : ZRC=0xFFFFFB37=-1225
                     SQL1225N  The request failed because an operating system process,
                     thread, or swap space limit was reached.

Document Location

Worldwide

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEQVQ","label":"IBM Spectrum Protect"},"Component":"Server","Platform":[{"code":"PF016","label":"Linux"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB69","label":"Storage TPS"}}]

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.

Document Information

Modified date:
22 June 2026

UID

ibm11107405

Page Feedback