SAP Knowledge Base Article - Preview

2417777 - SQL1226N error prevents additional connections

Symptom

The db2diag.log reports the following messages

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.

The above SQL1226N can also be seen for other issues pertaining to background connections discussed further in this article.


Read more...

Environment

DB2 for LUW

Keywords

DB2_PMODEL_SETTINGS=MAX_BACKGROUND_SYSAPPS   
, 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.