comp.sys.ibm.as400.misc - IBM AS/400 miscellaneous topics.
while opening a new DB2 connection using ODBC connection i get the following error message ERROR  [IBM][CLI Driver] SQL30061N The database alias or database name \"DATABASENAME \" was not found at the remote node. SQLSTATE=08004\r\n\r\nERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed"string here i find some additional spaces are appended along with the DATABASENAME and hence my connection fails.how to make a successful connection here? server is DB2 UDB for OS/390 7.1.1 client is DB2 CONNECT PE DB2 v8.2 installed in windows XP I used IBM DB2 Data Access Application Blocks for .NET which uses .NET native provider for DB2...still i get the same error message! -Satish
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