DB2 UDB stages

MukundShastri · Post by **MukundShastri** » Tue Jun 13, 2006 3:23 am

Can the Db2 UDB stages in Enterprise edition of datastage be used for accessing Db2 installed on MVS operating Systems.

aditya · Post by **aditya** » Tue Jun 13, 2006 9:17 am

Yes...It's all about using the DSN.

The DB2 Database installed on the Mainframe is generally queried via a terminal emulator and the DSN is how you do. So you could go ahead and use the same DSN setup for querying in your DS EE job.

HTH.

Aditya.

ray.wurlod · Post by **ray.wurlod** » Tue Jun 13, 2006 3:20 pm

You can set up DB2 Connect to do this. Ask your DBA.

MukundShastri · Post by **MukundShastri** » Wed Jun 14, 2006 1:50 am

ok. Thanks.

bmadhav · Post by **bmadhav** » Sat Jun 17, 2006 5:20 pm

Mukund
U should use the DB2/UDB API stage in DatStage EE to access DB2 on MVS.

lstsaur · Post by **lstsaur** » Sat Jun 17, 2006 6:12 pm

As Ray said you need to install DB2 Connect. Also, if you are going to use the DB2 UDB API Stage to call the stored procedures using environment variables as parameters, you need to call Ascential to get the patch.