Difference between DB2 enterprise stage and DB2 API stage

adityavarma · Post by **adityavarma** » Tue Jun 03, 2008 10:15 pm

Hi ,

can anyone tell me the differences between DB2 enterprise stage and DB2 API stage.

Thanks in advance

Regards,
Aditya

wesd · Post by **wesd** » Wed Jun 04, 2008 9:45 am

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.

vmcburney · Post by **vmcburney** » Wed Jun 04, 2008 3:59 pm

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.