Page 1 of 1
DB2 API and DB2 Enterprize Stage
Posted: Wed Jul 28, 2004 3:12 pm
by vbeeram
what is the difference between DB2 API and DB2 Enterprise stages?
which one gives better performance?
Thanks
beeram
Posted: Wed Aug 25, 2004 1:02 pm
by gh_amitava
Hi,
DB2 Enterprise stage will give you better performance. Also you can use the 'UPSERT' feature of DB2 Enterprise stage to load data into database.
Regards
Amitava
main difference between DP2 API and DB2 ENT
Posted: Wed Aug 25, 2004 9:35 pm
by mandyli
HI
The DB2/UDB Enterprise (native parallel) stage should be used for reading from, performing
lookups against, and writing to a DB2 Enterprise Server Edition database with Database Partitioning Feature (DPF)
Main difference between DP2 API and DB2 ENT
[quote]The DB2/API (plug-in) stage should only be used to read from and write to DB2 databases on non-
UNIX platforms (such as mainframe editions through DB2-Connect). Sparse Lookup is not
supported through the DB2/API stage.[/quote]
[quote]When writing to a DB2 database in parallel, the DB2/UDB Enterprise stage offers the choice of
SQL (insert / update / upsert / delete) or fast DB2 loader methods. The choice between these
methods depends on required performance, database log usage, and recoverability.[/quote]
Thanks
Man