Bulk Data Movement Guide

10.4.0
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1

Back Next

PWX DB2zOS Connection Attributes for DB2 LOAD Jobs

The following table describes each connection attribute that you can set to control bulk data load operations that use the DB2 LOAD utility:

PWXPC Connection Attribute	Description	Valid Values
Bulk Load	Select to cause PowerExchange to load data to DB2 for z/OS targets using the DB2 LOAD utility.	Default is No.
CTL Template	Member name of the control file template for the DB2 LOAD utility in the RUNLIB library on the PowerExchange target system.	Default is DB2LDCTL.
JCL Template	Member name of the JCL template for the DB2 LOAD utility in the RUNLIB library on the PowerExchange target system.	Default is DB2LDJCL.
Load Options	Option that indicates whether to use the LOAD REPLACE control card for DB2 LOAD utility bulk data load operations.	Select one of the following values: INSERT. Select this option to add the new data being loaded to the data currently in the tablespace or tablespace partition. Corresponds to the LOAD RESUME YES control card. REPLACE. Select this option to replace the data currently in the tablespace or tablespace partition with the new data being loaded. Corresponds to the LOAD REPLACE control card. Default is INSERT.
Mode Time	Wait period for the execution of the DB2 LOAD utility job.	Enter one of the following values: WAIT. Waits for the job to end before returning control to PowerCenter. Specify this option only with a Mode Type of JOB or TASK. NO WAIT. Returns to PowerCenter without waiting for the job to end. Specify this option only with a Mode Type of JOB or NOSUBMIT. TIMED. Waits the number of seconds specified in the TIME connection attribute before returning control to PowerCenter. Specify this option only if you also specified a Mode Type of JOB. DATAONLY. Creates the data file only. Does not create the files and JCL to run the DB2 LOAD utility. Usually, this option is used with a Mode Type of NOSUBMIT. Default is WAIT. If you enter WAIT, PowerExchange disables network operation timeouts for the operation, regardless of the value specified by the TCPIP_OP_TIMEOUT parameter of the PWX Override connection attribute. If you enter TIMED, PowerExchange adds 300 seconds to the value of the TIME connection attribute. If you enter WAIT and the submitted job fails when you run the workflow, the PowerExchange Listener on the z/OS system continues to run. To stop the Listener, perform one of the following actions: Enter the following command from the z/OS operator console: F `task_name`,STOPTASK TASKID=`task_id` For more information, see the "STOPTASK Command" topic in the PowerExchange Command Reference . Enter the STOPTASK command in the Database Row Test dialog box of the PowerExchange Navigator. Select TASK_CNTL in the DB Type list, and select Stop Task in the Fetch box. The SQL Statement box displays stoptask taskid= . Enter a task ID. For more information, see the topic, "Issuing PowerExchange Listener Commands in a Database Row Test," in the PowerExchange Navigator User Guide .
Mode Type	Mode in which PowerExchange runs the DB2 LOAD utility to load data into DB2 tables.	Enter one of the following values: TASK. Runs the LOAD utility as a subtask under the PowerExchange Listener. JOB. Submits a separate job to run the DB2 LOAD utility. NOSUBMIT. Unless Mode Time is DATAONLY, creates the files and JCL to run the DB2 LOAD utility. Does not submit the load job. You must submit the job manually. Default is TASK.
Time	The wait time in seconds when you select JOB for the Mode Type and TIMED for Mode Time.	Valid values are 1 to 99998. Default is 0.
Filename	Data set name or high-level qualifier that PowerExchange uses to create temporary files for bulk data load operations of the DB2 LOAD utility. For more information, see Data Set Names for DB2 Bulk Load Operations	If you need PowerExchange to create a data file for a single partition of a partitioned table, use the following syntax: filename /part xxxx The xxxx variable is the partition number.
Delete Temporary Files	How PowerExchange should handle the temporary files it creates with the DB2 LOAD utility to load data into a DB2 table.	Select one of the following values: NO does not delete the temporary files. BEFORE deletes the temporary files before running the utility. AFTER SUCCESS ONLY deletes the temporary files after running the utility if it ends with a return code 0. AFTER deletes the temporary files after running the utility. Default is NO.
PWX Override	PowerExchange connection overrides, separated by semicolons.	To write informational messages, including the output from a failed LOAD job and the name of the DB2 LOAD reject data set, to the PowerCenter session log, specify the following override: RETLOGINFOMSG=Y The name of the reject file appears in the PWX-00409 message. By default, PWXPC writes PowerExchange error and warning messages but not informational messages to the session log.

For DB2 bulk data load operations, specify either Confirm Write On
or Confirm Write Off
for the Write Mode
connection attribute.

For more information about PWX DB2zOS relational connections in PowerCenter, see PowerExchange Interfaces for PowerCenter
.

Rename Saved Search

Table of Contents

Bulk Data Movement Guide

Bulk Data Movement Guide

PWX DB2zOS Connection Attributes for DB2 LOAD Jobs

PWX DB2zOS Connection Attributes for DB2 LOAD Jobs