Hi All,
Now we are doing the performance tuning for our Jobs.Presently we are using DB2 API stage to extract the attributes from database tables.If we use DB2 EE stage to extract the attributes, is it improve the perforamnce ? Please , give me some inputs on the basic difference between API and EE stage and how they will differ in perforamance? our data is in Millions.
Thanks & Regards
Nagesh.
What is the diff between DB2 API and DB2EE stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 222
- Joined: Tue Aug 30, 2005 2:07 am
- Location: pune
- Contact:
What is the diff between DB2 API and DB2EE stage
NageshSunkoji
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If we use DB2 EE stage to extract the attributes, is it improve the perforamnce ?
How about you test it and you tell us?
In theory, because the Enterprise stage can work in parallel, it ought to give better throughput, but your SQL may result in sequential operation - for example if it includes GROUP BY, or if the table is not partitioned - so you may see no discernable difference.
How about you test it and you tell us?
In theory, because the Enterprise stage can work in parallel, it ought to give better throughput, but your SQL may result in sequential operation - for example if it includes GROUP BY, or if the table is not partitioned - so you may see no discernable difference.
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.
Nagesh
To use the Enterprise stage of DB2, the DB2 source database shd be of enterprise edition. If it is not, then there is really no use of using it. U shd check with ur DB2 DBAs and see what version of DB2 u have.
If u do have DB2 EE, then u shd definetly use the enterprise stage, which is a parallel stage. If not, u shd use the DB2 API stage which is a sequential stage.
Thanks
Bindu Madhav
To use the Enterprise stage of DB2, the DB2 source database shd be of enterprise edition. If it is not, then there is really no use of using it. U shd check with ur DB2 DBAs and see what version of DB2 u have.
If u do have DB2 EE, then u shd definetly use the enterprise stage, which is a parallel stage. If not, u shd use the DB2 API stage which is a sequential stage.
Thanks
Bindu Madhav
-
- Participant
- Posts: 222
- Joined: Tue Aug 30, 2005 2:07 am
- Location: pune
- Contact:
Than X
Hi Ray & Bindu,
Thanks for u r response.It is very helpful to me.
Thanks & Regards
Nagesh.
Thanks for u r response.It is very helpful to me.
Thanks & Regards
Nagesh.
NageshSunkoji
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
If you know anything SHARE it.............
If you Don't know anything LEARN it...............