What is the diff between DB2 API and DB2EE stage

[Nageshsunkoji]

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.

[ray.wurlod]

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.

[bmadhav]

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

[Nageshsunkoji]

Hi Ray & Bindu,

Thanks for u r response.It is very helpful to me.

Thanks & Regards
Nagesh.