comp.sys.ibm.as400.misc - IBM AS/400 miscellaneous topics.
XXXX@XXXXX.COM wrote: > Hi, > > I am not able to run any db2 commands from instance home directory > while from everywhere else it is working fine. > > it is really strange. > > the only comand i am able to run is db2ilist. > > /home/dbinst >db2ilist > dbinst > > when i am running other commands it is returning me prompt back with > no output. > > /home/dbinst >db2 list db directory > /home/dbinst > > > if I am changing to other sub-dir / dir, it is running fine. What is your $PATH environment variable set to? $5 says that "." appears in it before /home/dbinst/sqllib/bin, and there is a script called /home/dbinst/db2 that has the execute bit set. You can verify this by executing `which db2` and see what you get.
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