Bulk Data Movement Guide

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

Back Next

Data Set Names for DB2 Bulk Load Operations

PowerExchange creates temporary files for bulk data load operations of the DB2 LOAD utility. The data sets that are generated and their names depend on the

Mode Time

and

Mode Type

connection attributes that you select.

The descriptions of data set names that follow include the following variables:

filename: the high-level qualifier or data set name that you specify for the

Filename

connection attribute.

nnnn: PID of the task.

xxxx: partition number that you specify for the

Filename

connection attribute, using the following syntax: filename/partxxxx.

The following table describes the files that PowerExchange creates if you select

JOB

for the

Mode Type

connection attribute:

File Name	Description
filename .DTL nnnnn or filename .PRN xxxx	File that contains the data for the DB2 LOAD utility to load to a nonpartitioned table or File that contains the data for the DB2 LOAD utility to load to a partitioned table
filename .DTL nnnnn .CTL	File that contains the LOAD commands
filename .DTL nnnnn .SQL	File that contains the SQL template for CREATE TABLE statements
filename .DTL nnnnn .SYSPRINT	File that contains the output from bulk load jobs

The following table describes the files that PowerExchange creates if you select

NOSUBMIT

for the

Mode Type

connection attribute:

File Name	Description
filename or filename .PRN xxxx	File that contains the data for the DB2 LOAD utility to load to a nonpartitioned table or File that contains the data for the DB2 LOAD utility to load to a partitioned table
filename .CTL	File that contains the LOAD commands
filename .SQL	File that contains the SQL template for CREATE TABLE statements
filename .SYSPRINT	File that contains the output from bulk load jobs

The following table describes the files that PowerExchange creates if you select

DATAONLY

for the

Mode Time

connection attribute:

File Name	Description
filename or filename .PRN xxxx	File that contains the data for the DB2 LOAD utility to load to a nonpartitioned table or File that contains the data for the DB2 LOAD utility to load to a partitioned table

Rename Saved Search

Table of Contents

Bulk Data Movement Guide

Bulk Data Movement Guide

Data Set Names for DB2 Bulk Load Operations

Data Set Names for DB2 Bulk Load Operations