DB2 API and DB2 Enterprize Stage

[vbeeram]

what is the difference between DB2 API and DB2 Enterprise stages?
which one gives better performance?


Thanks
beeram

[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

[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