Table space statuses during loads

The following table shows the Db2 object statuses during various load scenarios.

Important

For either LOAD REPLACE or LOAD RESUME YES, all objects relating to the table specified in the INTO clause change status before the load process begins.

Related topics

REPLACE (basic option)

RESUME (basic option)

WRITETO 

BMC-AMI-Load-operational-considerations

Load scenario

Object status

LOAD DATA INDDN SYSREC01 RESUME YES
SHRLEVEL CHANGE
  INTO TABLE <creator>.<tableName>

RW (insert load)

LOAD DATA INDDN SYSREC01 RESUME YES      
  INTO TABLE <creator>.<tableName>

STOP

 LOAD DATA INDDN SYSREC01 RESUME YES
SHRLEVEL CHANGE
  INTO TABLE <creator>.<tableName> PARTS 2,4,6 REPLACE
  INTO TABLE <creator>.<tableName> PARTS 1,3,5 RESUME YES

PARTS 1, 3, 5 STOP

PARTS 2, 4, 6 RW

Other partitions and NPIs RW

LOAD DATA INDDN SYSREC01 REPLACE
SHRLEVEL REFERENCE
  INTO TABLE <creator>.<tableName>

RO

LOAD DATA INDDN SYSREC01 REPLACE
SHRLEVEL CHANGE
  INTO TABLE <creator>.<tableName>

RW

LOAD DATA INDDN SYSREC01 REPLACE
SHRLEVEL CHANGE
  INTO TABLE <creator>.<tableName> PART 2 REPLACE

PART 2 RW

NPIs RW

With +WRITETO(A) BMC AMI Load parameter:

LOAD DATA INDDN SYSREC01 RESUME NO REPLACE
  INTO TABLE <creator>.<tableName>

STOP

With +WRITETO(B) BMC AMI Load parameter:

LOAD DATA INDDN SYSREC01 RESUME NO REPLACE
  INTO TABLE <creator>.<tableName>

RO

With +WRITETO(A) BMC AMI Load parameter:

 LOAD DATA INDDN SYSREC01
  INTO TABLE <creator>.<tableName> PART 2 REPLACE

PART 2 STOP

Other partitions and NPIs RW

With +WRITETO(B) BMC AMI Load parameter:

 LOAD DATA INDDN SYSREC01
  INTO TABLE <creator>.<tableName> PART2 REPLACE

PART 2 RO

Other partitions and NPIs RW

With +WRITETO(A) BMC AMI Load parameter:

 LOAD DATA INDDN SYSREC01
  INTO TABLE <creator>.<tableName> PARTS 2,4,6 REPLACE
    (field specifications)
  INTO TABLE <creator>.<tableName> PARTS 1,3,5 RESUME YES
    (field specifications)

PARTS 1-6 STOP

Other partitions and NPIs RW

With +WRITETO(B) BMC AMI Load parameter:

 LOAD DATA INDDN SYSREC01
  INTO TABLE <creator>.<tableName> PARTS 2,4,6 REPLACE
    (field specifications)
  INTO TABLE <creator>.<tableName> PARTS 1,3,5 RESUME YES
    (field specifications)

PARTS 1, 3, 5 STOP

PARTS 2, 4, 6 RO

Other partitions and NPIs RW

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*