Initially we were able to connect to database using cicsddt, but after few days, suddenly we are not able to connect,
ERZ037068I/0500: CICSDDT talking to: 'CICSTEST'
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.
- 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.
DBNAME=cicstest user cicstest 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.