I am trying to run a DataStage job code of 8.7 version on 11.7. job has below stages:

     output file1                 output File2
           ^                            ^
           |                            |
Db2 --> transform <-- hash file --> transform <-- Db2

In 8.7 Datstage the job is working fine. But in 11.7 it is throwing below error:

Exception thrown from CC_DB2Connection::getVersionServerPtf, file CC_DB2Connection.cpp, line 3848: DB2 function SQLExecDirect() failed:  SQLSTATE = 42S02: Native Error Code = -204: Msg = [IBM][CLI Driver][DB2/AIX64] SQL0204N  "SYSIBMADM.ENV_INST_INFO" is an undefined name.  SQLSTATE=42704 

I tried look into SYSIBMADM.ENV_INST_INFO table in DB2 throw Dbeaver(SQL tool) and I am able to perform select statement on it through my userid/password(diff from what is being used in job).

I tried connecting to the server through command line using the userid/password used in job and able to perform select statement on SYSIBMADM.ENV_INST_INFO.

Request you to please guide me through it as I am doing code migration of several projects on 11.7 version from 8.7 and this is a blocker for me.

Thank you in advance.

0

There are 0 best solutions below