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!
DB2 on z/OS - Most Efficient Database Stage to Use
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 15
- Joined: Mon Jul 20, 2009 7:16 am
DB2 on z/OS - Most Efficient Database Stage to Use
Last edited by skilletrx2 on Fri Aug 07, 2009 5:05 pm, edited 1 time in total.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 15
- Joined: Mon Jul 20, 2009 7:16 am
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?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.
-
- Participant
- Posts: 407
- Joined: Mon Jun 27, 2005 8:54 am
- Location: Walker, Michigan
- Contact:
* DB2 Enterprise Stage does not work for Z/OS, I don't think DB2 UDB Load does either.skilletrx2 wrote: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?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.
* 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.
-
- Participant
- Posts: 15
- Joined: Mon Jul 20, 2009 7:16 am
Thanks for your help is DB2 Connector only available on certain editions of DataStage?Ultramundane wrote:* DB2 Enterprise Stage does not work for Z/OS, I don't think DB2 UDB Load does either.skilletrx2 wrote: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?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.
* 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.
-
- Participant
- Posts: 407
- Joined: Mon Jun 27, 2005 8:54 am
- Location: Walker, Michigan
- Contact:
Yes, introduced in 8.1 is correct. It is not included with 8.1.chulett wrote:Probably introduced in 8.1. ...
http://www-01.ibm.com/support/docview.w ... wg24022735
Thanks.