By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,835 Members | 1,951 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,835 IT Pros & Developers. It's quick & easy.

Not able to connect to db !

P: n/a
Hi All,
Am using Db2 v.8.2 ESE on Win 2003 Server. Am trying to connect to an
already created db. But am getting the following error:
db2 connect to DBNAME
SQL1226N The maximum number of client connections are already
started.
SQLSTATE=57030

This is the entry found in the db2diag.log:

2008-07-17-07.06.03.008000-240 I9868300H289 LEVEL: Error
PID : 764 TID : 2056 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleGetAgent, probe:70
MESSAGE : Agent not allocated, sqlcode = -1226

I have tried to stop all the Db2 services using db2_kill &
db2_all"db2_kill" . Next db2stop & db2start , but of no use still
getting the same error. Am not able to get on why we are facing the
issue of "max. number of client conns. are already started" when no
appln. is connected to the db.
Any help in the reg. is highly appreciated.

Thanks in Advance
Satish
Jul 17 '08 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On Jul 17, 3:43 pm, satish mullapudi <satishmullapud...@gmail.com>
wrote:
Hi All,
Am using Db2 v.8.2 ESE on Win 2003 Server. Am trying to connect to an
already created db. But am getting the following error:
db2 connect to DBNAME
SQL1226N The maximum number of client connections are already
started.
SQLSTATE=57030

This is the entry found in the db2diag.log:

2008-07-17-07.06.03.008000-240 I9868300H289 LEVEL: Error
PID : 764 TID : 2056 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleGetAgent, probe:70
MESSAGE : Agent not allocated, sqlcode = -1226

I have tried to stop all the Db2 services using db2_kill &
db2_all"db2_kill" . Next db2stop & db2start , but of no use still
getting the same error. Am not able to get on why we are facing the
issue of "max. number of client conns. are already started" when no
appln. is connected to the db.
Any help in the reg. is highly appreciated.
What is MAXAPPLS in db cfg?

db2 get db cfg for <db>
/Lennart
Jul 17 '08 #2

P: n/a
On Jul 17, 7:09 pm, Lennart <Erik.Lennart.Jons...@gmail.comwrote:
On Jul 17, 3:43 pm, satish mullapudi <satishmullapud...@gmail.com>
wrote:
Hi All,
Am using Db2 v.8.2 ESE on Win 2003 Server. Am trying to connect to an
already created db. But am getting the following error:
db2 connect to DBNAME
SQL1226N The maximum number of client connections are already
started.
SQLSTATE=57030
This is the entry found in the db2diag.log:
2008-07-17-07.06.03.008000-240 I9868300H289 LEVEL: Error
PID : 764 TID : 2056 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleGetAgent, probe:70
MESSAGE : Agent not allocated, sqlcode = -1226
I have tried to stop all the Db2 services using db2_kill &
db2_all"db2_kill" . Next db2stop & db2start , but of no use still
getting the same error. Am not able to get on why we are facing the
issue of "max. number of client conns. are already started" when no
appln. is connected to the db.
Any help in the reg. is highly appreciated.

What is MAXAPPLS in db cfg?

db2 get db cfg for <db>

/Lennart
Am Sorry lenmart,
Am not able to get the db cfg for the db , bcoz , when am issuing the
cmd: db2 get db cfg for DBNAME, am gettign the following error:
The command is not valid at this point.
Jul 17 '08 #3

P: n/a
On Jul 17, 7:49 pm, satish mullapudi <satishmullapud...@gmail.com>
wrote:
On Jul 17, 7:09 pm, Lennart <Erik.Lennart.Jons...@gmail.comwrote:
On Jul 17, 3:43 pm, satish mullapudi <satishmullapud...@gmail.com>
wrote:
Hi All,
Am using Db2 v.8.2 ESE on Win 2003 Server. Am trying to connect to an
already created db. But am getting the following error:
db2 connect to DBNAME
SQL1226N The maximum number of client connections are already
started.
SQLSTATE=57030
This is the entry found in the db2diag.log:
2008-07-17-07.06.03.008000-240 I9868300H289 LEVEL: Error
PID : 764 TID : 2056 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleGetAgent, probe:70
MESSAGE : Agent not allocated, sqlcode = -1226
I have tried to stop all the Db2 services using db2_kill &
db2_all"db2_kill" . Next db2stop & db2start , but of no use still
getting the same error. Am not able to get on why we are facing the
issue of "max. number of client conns. are already started" when no
appln. is connected to the db.
Any help in the reg. is highly appreciated.
What is MAXAPPLS in db cfg?
db2 get db cfg for <db>
/Lennart

Am Sorry lenmart,
Am not able to get the db cfg for the db , bcoz , when am issuing the
cmd: db2 get db cfg for DBNAME, am gettign the following error:
The command is not valid at this point.
Lenmart,
I remenber seeing the values of MAXAGENTS as 400, MAX_COORDAGENT =
MAXAGENTS & the other values mostly set to default values only.

Regards,
Satish
Jul 17 '08 #4

P: n/a
On Jul 17, 4:49 pm, satish mullapudi <satishmullapud...@gmail.com>
wrote:
On Jul 17, 7:09 pm, Lennart <Erik.Lennart.Jons...@gmail.comwrote:
On Jul 17, 3:43 pm, satish mullapudi <satishmullapud...@gmail.com>
wrote:
Hi All,
Am using Db2 v.8.2 ESE on Win 2003 Server. Am trying to connect to an
already created db. But am getting the following error:
db2 connect to DBNAME
SQL1226N The maximum number of client connections are already
started.
SQLSTATE=57030
This is the entry found in the db2diag.log:
2008-07-17-07.06.03.008000-240 I9868300H289 LEVEL: Error
PID : 764 TID : 2056 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleGetAgent, probe:70
MESSAGE : Agent not allocated, sqlcode = -1226
I have tried to stop all the Db2 services using db2_kill &
db2_all"db2_kill" . Next db2stop & db2start , but of no use still
getting the same error. Am not able to get on why we are facing the
issue of "max. number of client conns. are already started" when no
appln. is connected to the db.
Any help in the reg. is highly appreciated.
What is MAXAPPLS in db cfg?
db2 get db cfg for <db>
/Lennart

Am Sorry lenmart,
Am not able to get the db cfg for the db , bcoz , when am issuing the
cmd: db2 get db cfg for DBNAME, am gettign the following error:
The command is not valid at this point.
Can you provide the full error msg?

/Lennart

Jul 17 '08 #5

This discussion thread is closed

Replies have been disabled for this discussion.