Table space load -- Field and controls

DB2 unload format (UNLOAD)

SQL/DS unload format

RESUME NO field

RESUME YES field

DB2 unload format (UNLOAD) field

This unload format specifies that the input record format is compatible with the DB2 unload format. The DB2 unload format is the result of REORG with the UNLOAD ONLY option. Input records that were unloaded by the REORG utility are loaded into the tables from which they were unloaded. You should not add or change column specifications between the REORG UNLOAD ONLY and the LOAD FORMAT UNLOAD. DB2 reloads the records into the same tables from which they were unloaded.

SQL/DS unload format

This unload format specifies that the input record format is compatible with the SQL/DS unload format. The data type of a column in the table to be loaded must be the same as the data type of the corresponding column in the SQL/DS table. SQL/DS strings that are longer than the DB2 limit cannot be loaded.

RESUME No

• table spaces

  Loads records into an empty table space. If the table space is not empty, and you have not used REPLACE, the LOAD terminates with a warning message. For nonsegmented table spaces containing deleted rows or rows of dropped tables, using the REPLACE option provides more efficiency.

• partitions

  Loads records into an empty partition. If the partition is not empty, and you have not used the REPLACE option, the LOAD terminates with a warning message.

RESUME YES field

• table spaces

  Loads records into a non-empty table space. If the table space is empty, a warning message is issued, but the table space is loaded. Loading begins at the current end of data in the table space. Space occupied by rows marked as deleted or by rows of dropped tables is not reused.

• partitions

  Loads records into a non-empty partition. If the partition is empty, a warning message is issued, but the partition is loaded.