DSXchange

I am using a PX DB2 API stage to connect the DB2 database, I could able to see the data in view data option but I got the below error while running.


Src_DB2API_MS_REFERENCE_DATA_MR2_M055_B_A,0: Fatal Error: Fatal: [IBM][CLI Driver] SQL1013N The database alias name or database name "S3MSDB01" could not be found. SQLSTATE=42705
DSTAGE-DB2CLI-0005`:`Unable to connect to DB2 server 'S3MSDB01'.

Any help on this please.

Are you connecting to the database on a remote server? If so, you need to invoke the DB2 instance using the environment available.

kris007 wrote:Are you connecting to the database on a remote server? If so, you need to invoke the DB2 instance using the environment available.

I'm facing this issue as well, do we need have an entry in datastage server to connect to the DB2 database. [ Something similar to a TNS entry for Oracle?]

Probably in db2nodes.cfg. Check with your DB2 DBA. DataStage is just another client application as far as DB2 is concerned.