We have DB2 Enterprise/DB2 API stages in Parallel Extender. Kindly recommend in which scenarion we should go for these Stages. What is the advantage of using an DB2 Enterprise stage than DB2 API stage.
Starting with release 7, DataStage EE offers database connectivity through native parallel and plugin stage types. For some databases (DB2, Informix, Oracle, and Teradata), multiple stage types are
available.
In general, for maximum parallel performance, scalability, and features it is best to use the native
parallel database stages in a job design. Native parallel database stages are:
[code]Native Parallel Database Stages
DB2/UDB Enterprise
Informix Enterprise
Oracle Enterprise
Teradata Enterprise[/code]
Plug-in stage types are intended to provide connectivity to database configurations not offered by
the native parallel stages. Because plug-in stage types cannot read in parallel, and cannot span
multiple servers in a clustered or MPP configuration, they should only be used when it is not
possible to use a native parallel stage.
Because there are exceptions to this rule (especially with Teradata), specific guidelines of when to
use various stage types are provided in the database-specific topics in this section.