Create only a data file to use as input for the DB2 LOAD utility. In this case, you must run the DB2 LOAD utility outside of PowerExchange. You can submit the job manually or use a job scheduler or the PowerExchange DTLREXE utility.

Create the following items:

a data file to use as input for the LOAD utility
load cards to run the LOAD utility
JCL to submit the LOAD utility as a separate job

Then submit the DB2 LOAD utility job and wait for the job to complete. To run the utility as a separate job, set the PWXPC

Mode Type

connection attribute to JOB.

Create the data file and load cards. Then execute the DB2 LOAD utility in the PowerExchange Listener address space. To run the utility as a subtask of the PowerExchange Listener, set the

Mode Type

connection attribute to TASK.

Although it is possible to run a single instance of the DB2 LOAD utility in the PowerExchange Listener address space by configuring the connection with a

Mode Type

of TASK, JCL prevents the use of a DD name more than once in a job. If you try to run a second instance of the DB2 LOAD utility in the PowerExchange Listener address space, the dynamic allocation of the data sets with the DD names SYSDISC, SYSERR, SYSIN, SYSMAP, SYSPRINT, SORTOUT, SYSUT1 fails because they are already in use by the other DB2 LOAD instance.