Not able to connect to db !
Question posted by: satish mullapudi
(Guest)
on
July 17th, 2008 01:45 PM
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
Would you like to answer this question?
Sign up for a free account, or Login (if you're already a member).
|
|
July 17th, 2008 02:15 PM
# 2
|
Re: Not able to connect to db !
On Jul 17, 3:43 pm, satish mullapudi <satishmullapud...@gmail.com>
wrote:
Quote:
Originally Posted by
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
|
|
|
July 17th, 2008 02:55 PM
# 3
|
Re: Not able to connect to db !
On Jul 17, 7:09 pm, Lennart <Erik.Lennart.Jons...@gmail.comwrote:
Quote:
Originally Posted by
On Jul 17, 3:43 pm, satish mullapudi <satishmullapud...@gmail.com>
wrote:
>
>
>
Quote:
Originally Posted by
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
|
>
Quote:
Originally Posted by
This is the entry found in the db2diag.log:
|
>
Quote:
Originally Posted by
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
|
>
Quote:
Originally Posted by
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.
|
|
|
July 17th, 2008 03:25 PM
# 4
|
Re: Not able to connect to db !
On Jul 17, 7:49 pm, satish mullapudi <satishmullapud...@gmail.com>
wrote:
Quote:
Originally Posted by
On Jul 17, 7:09 pm, Lennart <Erik.Lennart.Jons...@gmail.comwrote:
>
>
>
Quote:
Originally Posted by
On Jul 17, 3:43 pm, satish mullapudi <satishmullapud...@gmail.com>
wrote:
|
>
Quote:
Originally Posted by
Quote:
Originally Posted by
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
|
|
>
Quote:
Originally Posted by
Quote:
Originally Posted by
This is the entry found in the db2diag.log:
|
|
>
Quote:
Originally Posted by
Quote:
Originally Posted by
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
|
|
>
Quote:
Originally Posted by
Quote:
Originally Posted by
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.
|
|
>
Quote:
Originally Posted by
What is MAXAPPLS in db cfg?
|
>
Quote:
Originally Posted by
db2 get db cfg for <db>
|
>
Quote:
Originally Posted by
/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
|
|
|
July 17th, 2008 06:15 PM
# 5
|
Re: Not able to connect to db !
On Jul 17, 4:49 pm, satish mullapudi <satishmullapud...@gmail.com>
wrote:
Quote:
Originally Posted by
On Jul 17, 7:09 pm, Lennart <Erik.Lennart.Jons...@gmail.comwrote:
>
>
>
Quote:
Originally Posted by
On Jul 17, 3:43 pm, satish mullapudi <satishmullapud...@gmail.com>
wrote:
|
>
Quote:
Originally Posted by
Quote:
Originally Posted by
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
|
|
>
Quote:
Originally Posted by
Quote:
Originally Posted by
This is the entry found in the db2diag.log:
|
|
>
Quote:
Originally Posted by
Quote:
Originally Posted by
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
|
|
>
Quote:
Originally Posted by
Quote:
Originally Posted by
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.
|
|
>
Quote:
Originally Posted by
What is MAXAPPLS in db cfg?
|
>
Quote:
Originally Posted by
db2 get db cfg for <db>
|
>
Quote:
Originally Posted by
/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
Not the answer you were looking for? Post your question . . .
182,266 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).
|
|
|
Top Community Contributors
|
