Access to DB2 on MVS

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Access to DB2 on MVS

Post by admin »

Hello to everyone,

I need to extract data from DB2 database on MVS. Have someone experience about this matter? Could someone tell me if I can approach DB2 on MVS using the Serveur Engine and not the Code Generator? If yes, I need to have CAE or I can use ODBC without any other middleware?

Thanks a lot.

Giovanni Boccia
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

Giovanni,

Come Sta !!

Yes, you can certainly access a DB2 Database on MVS. You can do this through an ODBC Driver with a layer of Middleware.

There are many Middleware products available.

We are currently using NEON Shadow and also IBM DB2 Connect. Either of these work Fine through DataStage.

Regards

Basil Privitera
Altis Consulting



From: "Giovanni Boccia" on 19/06/2001 09:37 ZE2

Please respond to informix-datastage@oliver.com

To:
cc:
Subject: Access to DB2 on MVS



Hello to everyone,

I need to extract data from DB2 database on MVS. Have someone experience about this matter? Could someone tell me if I can approach DB2 on MVS using the Serveur Engine and not the Code Generator? If yes, I need to have CAE or I can use ODBC without any other middleware?

Thanks a lot.

Giovanni Boccia
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

Grazie Basil!

Giovanni Boccia


----- Original Message -----
From: "Basil BPR05 Privitera"
To:
Sent: Tuesday, June 19, 2001 9:46 AM
Subject: Re: Access to DB2 on MVS


> Giovanni,
>
> Come Sta !!
>
> Yes, you can certainly access a DB2 Database on MVS. You can do this
> through an ODBC Driver with a layer of Middleware.
>
> There are many Middleware products available.
>
> We are currently using NEON Shadow and also IBM DB2 Connect. Either
> of these work Fine through DataStage.
>
> Regards
>
> Basil Privitera
> Altis Consulting
>
>
>
> From: "Giovanni Boccia" on 19/06/2001 09:37 ZE2
>
> Please respond to informix-datastage@oliver.com
>
> To:
> cc:
> Subject: Access to DB2 on MVS
>
>
>
> Hello to everyone,
>
> I need to extract data from DB2 database on MVS. Have someone
> experience about this matter? Could someone tell me if I can approach
> DB2 on MVS using the Serveur
Engine
> and not the Code
> Generator? If yes, I need to have CAE or I can use ODBC without any
> other middleware?
>
> Thanks a lot.
>
> Giovanni Boccia
>
>
>
>
>
>
>
>
Locked