Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • PowerExchange for CDC and Mainframe 10.5.3
  • All Products

Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange Bulk Data Movement
  3. PowerExchange Listener
  4. Adabas Bulk Data Movement
  5. Datacom Bulk Data Movement
  6. DB2 for i5/OS Bulk Data Movement
  7. DB2 for Linux, UNIX, and Windows Bulk Data Movement
  8. DB2 for z/OS Bulk Data Movement
  9. IDMS Bulk Data Movement
  10. IMS Bulk Data Movement
  11. Microsoft SQL Server Bulk Data Movement
  12. Oracle Bulk Data Movement
  13. Sequential File Bulk Data Movement
  14. VSAM Bulk Data Movement
  15. Writing Data with Fault Tolerance
  16. Monitoring and Tuning Options

Bulk Data Movement Guide

Bulk Data Movement Guide

Back Next

PWX DB2zOS Connection Attributes for DB2 LOAD Jobs

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.
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
.
0 COMMENTS
We’d like to hear from you!