Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange
  3. DBMOVER Configuration File
  4. Netport Jobs
  5. PowerExchange Message Logs and Destination Overrides
  6. SMF Statistics Logging and Reporting
  7. PowerExchange Security
  8. Secure Sockets Layer Support
  9. PowerExchange Alternative Network Security
  10. PowerExchange Nonrelational SQL
  11. DTLDESCRIBE Metadata
  12. PowerExchange Globalization
  13. Using the PowerExchange ODBC Drivers
  14. PowerExchange Datatypes and Conversion Matrix
  15. Appendix A: DTL__CAPXTIMESTAMP Time Stamps
  16. Appendix B: PowerExchange Glossary

Netport Jobs and DB2 Bulk Data Loads

Netport Jobs and DB2 Bulk Data Loads

When a DB2 bulk data load operation is run from a netport job, the load runs as a task of the netport job, not as a separately submitted job.
A sample netport job, such as CAPXJCL, can be used as a template for creating such a netport job. The sample job must be edited to add the DD statements that would normally be in the DB2 LOAD JCL.
For example:
//SORTOUT DD UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND) //SORTWK01 DD UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND) //SYSDISC DD UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND) //SYSERR DD UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND) //SYSMAP DD UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND) //SYSUT1 DD UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND) //UTPRINT DD SYSOUT=*
The netport job cannot have a DD statement for SYSPRINT. This output is allocated to a file for DB2 LOAD.

0 COMMENTS

We’d like to hear from you!