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.

Before you begin

• ../../com.ibm.swg.im.iis.conn.common.usage.doc/topics/t_configuring_db2conn.html#install_config_db2conn.
• Verify if the user connecting to the DB2 database has the correct authority and privileges to perform the actions that your job requires.

1. Import metadata from a DB2 source.
2. Access the DB2 Connector stage from the Designer client.
3. To set up the DB2 Connector stage to read data from a DB2 table:
   1. Configure the DB2 connector as a source of data.
   2. Set up column definitions.
   3. Define usage properties for reading data.
4. To set up the DB2 Connector stage to write data into a DB2 table:
   1. Configure the DB2 Connector stage as the target of data.
   2. Set up column definitions if they are not already specified for the link.
   3. Define usage properties for writing data.
   4. Optional: Define how data is partitioned.
5. Optional: Define how data is buffered.
6. Set up DB2 connector to look up data.
7. Create a reject link to manage rejected data.
8. Compile and run the job.