SAP Knowledge Base Article - Preview

3315977 - Admin Task Scheduler (ATS) is blocked by SQL1226N The maximum number of client connections are already started

Symptom

The db2diag.log reports messages like 

2023-01-16-11.26.01.832458+060 E257546E531           LEVEL: Warning
PID     : 00000                TID : 140270343546624 PROC : db2acd 
INSTANCE: db2<SID>               NODE : 000
HOSTNAME: XXXXXXXXXX
EDUID   : 16                   EDUNAME: XXXXXXX
FUNCTION: DB2 UDB, Administrative Task Scheduler, AtsTask::run, probe:200
MESSAGE : ZRC=0xFFFFFB36=-1226
SQL1226N  The maximum number of client connections are already started. 

2023-01-16-11.26.01                                  LEVEL: Info
PID     : 00000                TID : 140270343546624 PROC : db2sysc 0
INSTANCE: db2<SID>               NODE : 000
HOSTNAME: XXXXXXXXXX
EDUID   : 16                   EDUNAME: XXXXXXX
FUNCTION: DB2 UDB, base sys utilities, sqeAgentServices::RequestAgentForAppl, probe:2081
MESSAGE : ZRC=0xFFFFFB36=-1226
SQL1226N  The maximum number of client connections are already started.
DATA #1 : <preformatted>
The number of background tasks has reached the limit of 20, will try again later.


2023-01-16-11.26.01.832458+060 E257546E531           LEVEL: Warning
PID     : 00000                TID : 140270343546624 PROC : db2acd 
INSTANCE: db2<SID>               NODE : 000
HOSTNAME: XXXXXXXXXX
EDUID   : 16                   EDUNAME: XXXXXXX
FUNCTION: DB2 UDB, Administrative Task Scheduler, AtsTask::run, probe:201
MESSAGE : ADM15502W  The administrative task scheduler could not execute task 
          "SAPTOOLS.DBH <Collector Name>" because the database is inactive.
DATA #1 : ZRC, PD_TYPE_ZRC, 4 bytes

 


Read more...

Environment

Db2 LUW IBM

Product

SAP NetWeaver all versions

Keywords

ADM15502W  The administrative task scheduler could not execute task , KBA , BC-DB-DB6-DBA , Database Administration , 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.