DSXchange

Posted: **Thu Mar 17, 2011 9:01 am**

Hello,

We had 8.0.1 version of IS earlier, and now IS 8.5
All the job have been migrated from 8.0.1 to 8.5

Nothing changed everything is the same in the job but cannot connect to the DB which is DB2.
I used DSDB2PX stage for the job to connect DB2.

do I need to do any specific changes to the stage as I get an error which says:

Code: Select all

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

Posted: **Thu Mar 17, 2011 9:25 am**

Hi suryadev,

you have to catalog the database on your new DataStage server.
This is done "outside" DataStage. On the DataStage server you should have a DB2 client installed to be able to connect to your DB2 data sources. In thios cklient you have to catalog all the databases you are going to use and - if they are remote - you have to catalog "servers" via a "catalog tcpip node " command as well.
Ask your DBA to assist you if you do not know these DB2 commands.

Posted: **Thu Mar 17, 2011 10:10 am**

That helps!!

Thanks Michael

DSXchange

DB2 connectivity

DB2 connectivity

Re: DB2 connectivity