Page 1 of 1
Difference between DB2 enterprise stage and DB2 API stage
Posted: Tue Jun 03, 2008 10:15 pm
by adityavarma
Hi ,
can anyone tell me the differences between DB2 enterprise stage and DB2 API stage.
Thanks in advance
Regards,
Aditya
Posted: Wed Jun 04, 2008 9:45 am
by wesd
Enterprise - Parallel read and ability to lookup data in tables using Lookup stage. Must have DPF installed on DB2.
API - sequential read and no lookup ability. A basic stage for reading data.
Posted: Wed Jun 04, 2008 3:59 pm
by vmcburney
There was an article on IBM DeveloperWorks showing how the DB2 Enterprise Stage could run up to 250% faster than the DB2 API stage for retrieving data. See
DataStage Tip: Extracting database data 250% faster.