On Jul 17, 4:49 pm, satish mullapudi <satishmullapud...@[EMAIL PROTECTED]
>
wrote:
> On Jul 17, 7:09 pm, Lennart <Erik.Lennart.Jons...@[EMAIL PROTECTED]
> wrote:
>
>
>
> > 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
>
> 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
|
