DB2 connectivity

[suryadev]

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'.

[MT]

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.

[suryadev]

That helps!!


Thanks Michael