Datastage connection with DB2 v2 for OS/2

gccc_ceron · Post by **gccc_ceron** » Thu Mar 21, 2013 8:41 am

Hi,

I need to read tables from a DB2 v2 for OS/2 with Datastage v8.1 over AIX,
but connection parameters in .odbc.ini configuration file doesn't work.

I tried with 2 parameter formats, LUW and AS/400 but it doesn't work.

Please, help me with this connection problem.

Thanks,

Christian

ray.wurlod · Post by **ray.wurlod** » Thu Mar 21, 2013 3:10 pm

Do you have DB2 Connect installed on the DataStage engine? This is the software needed to connect to DB2 on different platforms.

ray.wurlod · Post by **ray.wurlod** » Tue Mar 26, 2013 3:37 pm

Open/create a parallel job. Make sure the Palette is visible (if not, use View menu). You should find DB2 Connector (as DB2 UDB with adjacent dropdown) in the Database folder of the Palette.

If it's not there, verify that the installation of FP1 was totally successful.

ray.wurlod · Post by **ray.wurlod** » Wed Mar 27, 2013 3:30 pm

Can you find it in the Stage Types \ Parallel \ Database section of your Repository?

Did you check the install log to determine whether or not it was installed?

gccc_ceron · Post by **gccc_ceron** » Mon Sep 23, 2013 4:12 pm

How do I configure DB2 connect in Datastage AIX server ??

ray.wurlod · Post by **ray.wurlod** » Tue Sep 24, 2013 12:24 am

Usually by asking the DBA nicely.