Topic
  • No replies
HPR
HPR
3 Posts

Pinned topic Problem while connecting to DB2 using cicsddt

‏2010-02-24T08:59:47Z |
We configured DB2 client and TXSeries for mutlipleplatforms,
Initially we were able to connect to database using cicsddt, but after few days, suddenly we are not able to connect,

>cicsddt
ERZ037068I/0500: CICSDDT talking to: 'CICSTEST'
ERZ037069I/0501: Version 1.0 : 25-07-1995
ERZ037070I/0502: Contacting Database ...
ERZ037226W/0737: (Bind to database failed (SQL Error: 'SQL0001N Binding or precompilation did not complete successfully. SQLSTATE=00000')

But I am able to connect to the same database using "db2 connect" command.

For refernce:

  1. db2 connect to cicstest user cicstest using cicstest

Database Connection Information

Database server = DB2/NT 9.7.0
SQL authorization ID = CICSTEST
Local database alias = CICSTEST

These are the environment variables that were set on the system.

Environmental variables:

CICSDB2CONF_CONNECT_USER=cicstest
DBNAME=cicstest user cicstest using cicstest
DB2NAME=cicstest
DB2DIR=/opt/IBM/db2/V9.5
DB2PASSWD=cicstest
DB2USER=cicstest
DB2COMM=tcpip
DB2INSTANCE=db2inst1
DB2DBDFT=CICSTEST
CICSDB2CONF_CONNECT_USING=cicstest
DB2CONNECTSTRING=connect to cicstest user cicstest using cicstest

Other environment variables like PATH,LIBPATH are all correctly set to include respective db2 install paths.

We have been looking at this for a few days now.. Any assistance would be appreciated.