On Jul 17, 3:43 pm, satish mullapudi <satishmullapud...@[EMAIL PROTECTED]
>
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
|
