IBM Db2 databases

To access Db2® database systems for Linux, Unix, Windows, IBM i, z/OS®, and dashDB®, use the IBM® InfoSphere® DataStage® Db2® connector.

A connector is a component that provides data connectivity and metadata integration for external data sources, such as relational databases or messaging software. A connector typically includes a stage that is specific to the external data source.

The Db2 Connector is currently the only stage dedicated for accessing Db2 database systems. In previous releases, the following stages were available which are now deprecated:
  • Db2 API stage
  • Db2 UDB Enterprise stage
  • Db2 UDB Load stage
  • Db2Z stage

If you have jobs that use the older stages and want to use the Db2 connector, use the Connector Migration Tool to migrate then.

Note:
  • Partitioning type 'Db2 Connector' does not support DB2 for i database
Db2 connector
Use the IBM Db2 connector to access Db2 database systems and perform various read, write, and load functions.
Db2 connector messages
This message reference includes the messages that are returned by various components of the Db2 connector.
Db2 connector environment variables
The environment variable reference includes the environment variables that the Db2 Connector stage uses.