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
  7. PowerExchange Security
  8. Secure Sockets Layer Support
  9. PowerExchange Alternative Network Security
  10. PowerExchange Nonrelational SQL
  11. PowerExchange Globalization
  12. Using the PowerExchange ODBC Drivers
  13. PowerExchange Datatypes and Conversion Matrix
  14. DTL__CAPXTIMESTAMP Time Stamps
  15. PowerExchange Glossary

DB2/S390 Bulk Load Properties Tab

DB2/S390 Bulk Load Properties Tab

For DB2 data sources only. On the
DB2/S390 Bulk Load Properties
tab in the
PowerExchange Data Source
wizard, enter the properties to define PowerExchange for DB2 bulk load processing.
Bulk Load
Select this option to enable input on this page.
Corresponding ODBC Parameter: BULKLOAD
Load Options
The load option.
The options are:
  • RESUME
    . Generates a LOAD RESUME statement.
  • REPLACE
    . Generates a LOAD REPLACE statement.
Corresponding ODBC Parameter: LOADOPTIONS, as follows:
  • RESUME is equivalent to LOADOPTIONS=1.
  • REPLACE is equivalent to LOADOPTIONS=4.
Delete Temporary Files
Indicates whether to delete temporary files. The options are:
  • NO.
    Temporary files are not deleted.
  • BEFORE
    . Temporary files are deleted before running the loader.
  • AFTER SUCCESS ONLY
    . For a mode type of
    JOB
    only. Temporary files are deleted after running the loader, if the return code is 0.
  • AFTER
    . For a mode type of
    JOB
    only. Temporary files are deleted after running the loader.
Corresponding ODBC Parameter: DELETETEMPFILES, as follows:
  • NO is equivalent to DELETETEMPFILES=1.
  • BEFORE is equivalent to DELETETEMPFILES=2.
  • AFTER SUCCESS ONLY is equivalent to DELETETEMPFILES=3.
  • AFTER is equivalent to DELETETEMPFILES=4.
JCL Template
The name of the JCL file template on the target system, which is a member in a PDS defined on the system where the PowerExchange Listener is running.
Default is DB2LDJCL. You must customize this JCL before using it.
Corresponding ODBC Parameter: JCLTEMPLATE
CTL Template
The name of the DB2 bulk load control file template on the target system, which is a member in a PDS defined on the system where the PowerExchange Listener is running.
If you specify a CTL template, the
Load Options
option is ignored.
Default is DB2LDJCL. You must customize this JCL before using it.
Corresponding ODBC Parameter: CTLTEMPLATE
Mode Type
The mode type. The options are:
  • JOB
    . Submits as a job to the internal reader.
  • NOSUBMIT
    . Not submitted. Instead, creates the DB2 loader-specific control files and data files, saves them on the target system, and generates an executable JCL deck on disk.
  • TASK
    . Submits as a subtask of the PowerExchange Listener.
Corresponding ODBC Parameter: MODETYPE as follows:
  • TASK is equivalent to MODETYPE=1.
  • NOSUBMIT is equivalent to MODETYPE=2.
  • JOB is equivalent to MODETYPE=3.
Mode Time
The mode time. The options are:
  • WAIT
    . Synchronous. For a mode type of
    JOB
    or
    TASK
    only. Report the results at end the end of the job or task.
  • NOWAIT
    . Asynchronous. For a mode type of
    JOB
    or
    NOSUBMIT
    only. Returns OK when a job is submitted.
  • TIMED
    . Synchronous. For a mode type of
    JOB
    only. Wait for the specified number of seconds.
  • DATAONLY
    . For all mode types, but typically used with the
    NOSUBMIT
    mode type. Creates the data DB2 loader file.
Corresponding ODBC Parameter: MODETIME, as follows:
  • WAIT is equivalent to MODETIME=1.
  • NOWAIT is equivalent to MODETIME=2.
  • TIMED is equivalent to MODETIME=3.
  • DATAONLY is equivalent to MODETIME=4.
Time
Valid only for a mode type of
JOB
and a mode time of
TIMED
.
A value from 0 to 99999, as follows:
  • 0
    . No wait.
  • 99999
    . Wait.
  • Any other value. The number of seconds to wait.
Corresponding ODBC Parameter: TIME
Space
The z/OS space allocation. The options are:
  • TRACK
    . Tracks.
  • CYLINDERS
    . Cylinders.
Corresponding ODBC Parameter: SPACE
Primary Space
Amount of primary space for z/OS files.
Corresponding ODBC Parameter: PRISPACE
Secondary Space
Amount of secondary space for z/OS files.
Corresponding ODBC Parameter: SECSPACE
FName
The file name on the host system. Used as the stem for files created on z/OS.
The files created are:
  • FNAME.DTL
    nnnnn
    Data for load.
  • FNAME.DTL
    nnnnn
    .CTL
    Load commands.
  • FNAME.DTL
    nnnnn
    .SQL
    SQL template - create table.
  • FNAME.DTL
    nnnnn
    .SYSPRINT
    Output from loader.
Corresponding ODBC Parameter: FNAME