Bulk Data Movement Guide

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

Back Next

DB2 LOAD Utility Options

Unless you select

DATAONLY

for the

Mode Time

connection attribute, PowerExchange uses the DB2LDCTL or DB2LDCTP control card template to generate a load control file for the DB2 LOAD utility. If you select

DATAONLY

for the

Mode Time

connection attribute, you must provide the load control file.

PowerExchange generates the following load options for nonpartitioned tables:

LOAD DATA RESUME NO REPLACE INTO TABLE table_name

LOAD DATA RESUME YES INTO TABLE table_name

PowerExchange generates the following load options for partitioned tables:

LOAD DATA INTO TABLE table_name PART n INDDN PAR0000n REPLACE

LOAD DATA INTO TABLE table_name PART n INDDN PAR0000n RESUME YES

Using the DB2 LOAD Utility to Load Bulk Data

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Bulk Data Movement Guide

Bulk Data Movement Guide

DB2 LOAD Utility Options

DB2 LOAD Utility Options