You can use the JCL and control card templates without modification if you accept the default JCL statements and control cards for the DB2 LOAD utility. Alternatively, you can edit these templates to change the control cards or to use other load utilities.

The RUNLIB data set contains the default DB2LDJCL or DB2LDJCP template member. Make sure that the

JCL Template

attribute refers to this member in the connection.

In the JCL, substitution variables begin with a percent sign (%). Before submitting the DB2 LOAD job to z/OS, PowerExchange resolves defined substitution variables with the appropriate values. For more information, seeSubstitution Variables in the Loader JCL Templates.

If the SECURITY statement is set to 2 in the DBMOVER configuration member, make sure to include USER=%USER and PASSWORD=%PWD in the JCL.

You can retain discarded update records for a short time by changing the SYSDISC DD in the JCL from:

to:

This edited statement creates the discards file with a name in the format

HLQ.basename.SYSDISC

.

Informatica recommends that the DB2 LOAD utility control report from the SYSPRINT file be written to the session log of the caller. To write the SYSPRINT file to the session log, set RETLOGINFOMSG=Y in the

PWX OVERRIDE

connection attribute.

For more information about DD statement requirements for the DB2 LOAD utility, see the IBM DB2 documentation.