DB2 on z/OS - Most Efficient Database Stage to Use

skilletrx2 · Post by **skilletrx2** » Thu Aug 06, 2009 7:42 pm

Hi gurus!

I was wondering if you all would provide a recommendation on the most efficient way to connect to DB2 on z/OS? I see some native options within the database palette but they seem to just be for DB2 UDB. Can these be used for DB2 on z/OS as well? Any thoughts on the most efficient way would be appreciated. Any connection setups would be appreciated (especially if anyone is using DB2 Connect)

Thanks in advance!

skilletrx2 · Post by **skilletrx2** » Fri Aug 07, 2009 8:15 am

bump, anyone?

ray.wurlod · Post by **ray.wurlod** » Sun Aug 09, 2009 4:53 pm

You want service on the weekend sign up with your support provider for priority service, and learn just how much "urgent" costs. This is an all-volunteer site whose members post when they can, and usually only if they have something to contribute. Things like your "bump" are offensive.

skilletrx2 · Post by **skilletrx2** » Mon Aug 10, 2009 7:10 am

ray.wurlod wrote:You want service on the weekend sign up with your support provider for priority service, and learn just how much "urgent" costs. This is an all-volunteer site whose members post when they can, and usually only if they have something to contribute. Things like your "bump" are offensive.

Sorry about that, carried the 'bump' concept over from the car forums, i'll make sure not to do that here. Anyways, any info on folks connecting to DB2 on z/OS would be greatly appreciated - any DB2 Connect folks?

Ultramundane · Post by **Ultramundane** » Mon Aug 10, 2009 8:41 am

skilletrx2 wrote:
ray.wurlod wrote:You want service on the weekend sign up with your support provider for priority service, and learn just how much "urgent" costs. This is an all-volunteer site whose members post when they can, and usually only if they have something to contribute. Things like your "bump" are offensive.
Sorry about that, carried the 'bump' concept over from the car forums, i'll make sure not to do that here. Anyways, any info on folks connecting to DB2 on z/OS would be greatly appreciated - any DB2 Connect folks?

* DB2 Enterprise Stage does not work for Z/OS, I don't think DB2 UDB Load does either.

* DB2 UDB/API works, but it is too slow and it is a CPU hog.

* ODBC Enterprise stage is faster than DB2 UDB/API stage by about 2.75 times. Probably the best stage for DB2 Z/OS pre-connector stages.

* ODBC Connector stage is faster than DB2 UDB/API stage by about 3 times. Slightly faster than ODBC Enterprise Stage.

* DB2 Connector stage is 4 times faster than DB2 UDB/API stage. It is the best performer.

Note: DB2 Connector also provides BULK LOAD which is also provided via the DB2Z stage. I have tested the two. However, I would expect the DB2 Connector Stage to outperform the DB2Z stage.

In summary, your best choices:
#1) DB2 Connector
#2) ODBC Connector
#3) ODBC Enterprise

Thanks.

skilletrx2 · Post by **skilletrx2** » Tue Aug 11, 2009 9:35 am

Ultramundane wrote:
skilletrx2 wrote:
ray.wurlod wrote:You want service on the weekend sign up with your support provider for priority service, and learn just how much "urgent" costs. This is an all-volunteer site whose members post when they can, and usually only if they have something to contribute. Things like your "bump" are offensive.
Sorry about that, carried the 'bump' concept over from the car forums, i'll make sure not to do that here. Anyways, any info on folks connecting to DB2 on z/OS would be greatly appreciated - any DB2 Connect folks?
* DB2 Enterprise Stage does not work for Z/OS, I don't think DB2 UDB Load does either.

* DB2 UDB/API works, but it is too slow and it is a CPU hog.

* ODBC Enterprise stage is faster than DB2 UDB/API stage by about 2.75 times. Probably the best stage for DB2 Z/OS pre-connector stages.

* ODBC Connector stage is faster than DB2 UDB/API stage by about 3 times. Slightly faster than ODBC Enterprise Stage.

* DB2 Connector stage is 4 times faster than DB2 UDB/API stage. It is the best performer.

Note: DB2 Connector also provides BULK LOAD which is also provided via the DB2Z stage. I have tested the two. However, I would expect the DB2 Connector Stage to outperform the DB2Z stage.

In summary, your best choices:
#1) DB2 Connector
#2) ODBC Connector
#3) ODBC Enterprise

Thanks.

Thanks for your help is DB2 Connector only available on certain editions of DataStage?

chulett · Post by **chulett** » Tue Aug 11, 2009 9:48 am

Probably introduced in 8.1.

Ultramundane · Post by **Ultramundane** » Tue Aug 11, 2009 10:35 am

chulett wrote:Probably introduced in 8.1. ...

Yes, introduced in 8.1 is correct. It is not included with 8.1.

http://www-01.ibm.com/support/docview.w ... wg24022735

Thanks.

andrewn · Post by **andrewn** » Wed Aug 12, 2009 4:52 am

Also, you can't use the DB2 API stage as a 'sparse' lookup and it can't have a reject link.

The ODBC Enterprise stage doesn't have those limitations :D