You can use the DB2 LOAD utility with PowerExchange to load data to a table partition. As with a nonpartitioned table, PowerExchange can produce customized JCL and load cards for running the LOAD utility, generate a data file that contains the data to be loaded, and automatically submit the bulk load job to load data to the target.

However, PowerExchange cannot generate and submit a single bulk load job to load data to multiple table partitions. To write to multiple partitions in a single load job, you can define a separate target in PowerCenter for each partition and define connection attributes to create only a data file for the DB2 LOAD utility to load for each target. You can provide the loader control file and JCL for a single DB2 LOAD job that loads the data into each partition. In the PowerCenter workflow, after the data is written to a data file for each partition, you can include a separate PowerCenter command that users DTLREXE to submit the DB2 LOAD job. Alternatively, you can submit the job outside of PowerCenter by using a job scheduler or some other facility.