IBM InfoSphere Information Server
DB2 connector
You can use the DB2 connector to create jobs that read, write and load data. To use it you first need to configure it.
- Configuring the DB2 connector
To use the DB2 Connector stage in a job, you must first configure DB2 environment variables and set privileges for DB2 users. The DB2 connector connects to your databases using the DB2 client on the DataStage nodes. The connector requires that each database be cataloged in the DB2 client. - Configuring parallel processing for the DB2 connector with DB2 for Linux, UNIX, and Windows databases
You can configure the DB2® connector to read or write data in parallel mode. The distribution of parallel processes across hardware is based on the DB2 for Linux, UNIX, and Windows partition distribution. - Designing jobs by using the DB2 connector
You can use the IBM® DB2 connector to develop jobs that read, write, and load data, and that store components from one job in the repository to reuse in another job. - Looking up data by using reference links
You can use the IBM DB2 connector to look up data directly from a DB2 table by using a reference link to link the DB2 Connector stage to a Lookup stage. The Lookup stage is a processing stage. It is used to perform lookup operations on a data set read into memory from any other Parallel job stage that can output data. You can specify a condition on each of the reference links, such that the stage will only perform a lookup on that reference link if the condition is satisfied. - Specifying job parameters
You can define parameters for an IBM DB2 connector job that allow you to set or change the value of a property at runtime. In the stage editor, you can create, select, or remove parameters from any properties that support parameters. - Generating SQL statements in the connector at design time
- Validating SQL statements in the connector at design time
- Defining data buffering
To improve performance and resolve bottlenecks, you can specify how input and output data for an IBM DB2 Connector stage is buffered. Although the size and operation of the buffer are usually the same for all links on all stages, you can modify the settings for specific links. - Data type conversions
IBM InfoSphere® DataStage® supports a set of SQL data types that are different from DB2 SQL data types. - Compiling and running DB2 connector jobs
You compile DB2 connector jobs into executable scripts that you can schedule and run. - Troubleshooting
When running jobs using the DB2 connector, you might encounter errors that can be fixed by troubleshooting and adjusting values for properties or configurations.
Related information:
Last updated: 2018-02-01 PDF version of this information: IBM InfoSphere DataStage and QualityStage Connectivity Guide for IBM DB2 Databases