DB2 Stage

[Maharaj]

Hi

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.

Thanks

Maharaj

[Sreenivasulu]

Hi Maharaj

I heard that the API Stage is faster since it used native plug-ins.
We are using API Stage in our project

Regards
Sreenivasulu

[afssekar]

Hi Sreenivasulu,

DB2 API stage is not a native stage.

[b]please see the following information[/b]

Native Parallel vs. Plug-In Database Stage Usage

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.

[code]Plug-in database stages include:
Plug-In Database Stages
Dynamic RDBMS (v7.1 and later)
DB2/UDB API
DB2/UDB Load
Informix CLI
Informix Load
Informix XPS Load
Oracle OCI Load
RedBrick Load
Sybase IQ12 Load
Sybase OC
Teradata API
Teradata MultiLoad (MultiLoad)
Teradata MultiLoad (TPump) (v7.1 and later)[/code]

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.


Thanks
afs