MVS database connection from DS on Unix

G_Backman · Post by **G_Backman** » Tue Jan 24, 2006 4:51 pm

Hello,

I am new to the Datastage enviornment. I need your help.

We have some requirement in which I need to extract data from DB2 database on MVS system on remote server and load it to our FTP directory. We have to perform this task by developing job on Datastage v7.5 on unix enviornment.

Just wondering is it possible to use DB2 API stage or ODBC stage as a source in my design and extract the data from the DB2 database on MVS?

Thanks

ray.wurlod · Post by **ray.wurlod** » Tue Jan 24, 2006 5:14 pm

Welcome aboard. :D

You can do it with DB2 stage, but will need to have DB2 Connect software installed on the DataStage server machine.

You can do it with ODBC stage, but will need an SQL bridge of some kind or DB2 Connect software.

Also check out IBM's Information Integrator software.

G_Backman · Post by **G_Backman** » Wed Jan 25, 2006 8:22 am

Thanks Ray,

We have DB2 v8 on the same UNIX box where Ascential is installed. So I think "DB2 Connect" will work.

Or DB2 Connect software is some different thing.

Regards,

George

bmadhav · Post by **bmadhav** » Sun Jan 29, 2006 12:38 pm

DB2 v8 u are talking about is the DB2 client on the Unix box. u will need a catalog entry on the UNIX box to the DB2 server on mainframe.
DB2 Connect is software that is designed to leverage your enterprise information no matter where it is stored.