UNLOAD | MIGRATE
The UNLOAD keyword signals the beginning of the unload block. It must be followed by one of the two keywords: DATABASE or TABLESPACE. Substitute the MIGRATE keyword for the UNLOAD keyword when you migrate data.
Options
- DATABASE
- The UNLOAD DATABASE option identifies the start of an unload block. You can
include any number of white characters between UNLOAD and
DATABASE. The database_name variable represents the qualified
name of the database. The database name is optional and defaults to the one specified in the
configuration file (db2dbdft) in the section titled “Installing and configuring
Optim™ High Performance Unload.” All of the user-defined (non-system)
table spaces are included. There can be only one UNLOAD DATABASE in a control file.
- Syntax
- UNLOAD DATABASE database_name
- Variable
- A valid database name
- Default
- db2dbdft (in the db2hpu.cfg file)
- TABLESPACE
- The UNLOAD TABLESPACE option identifies the start of an unload block. There can
be any number of white characters between UNLOAD and TABLESPACE.
The tablespace_name variable represents the qualified name of the table space.
The table space name is optional if it can be derived from such places as the table name in the
SELECT clause. All options that follow this keyword must belong to the unload block, until either
the next occurrence of UNLOAD TABLESPACE or the end of the control file.
- Syntax
- UNLOAD TABLESPACE tablespace_name
- Variable
- A valid table space name
- Default
- None
Important: Verify that you have enough memory before running the
UNLOAD TABLESPACE or the UNLOAD DATABASE options. You will
unload all of the user tables in the specified table space or database, and Optim High Performance Unload will attempt to process all of the tables in
parallel if you are unloading data from backup images. This operation can require a significant
amount of memory for buffering because all of the output files will be active at the same
time.
Remember:
- When unloading a full table space, the tablespace_name variable is required.
- When unloading a full table space from backup in standalone mode, the PART option with specific database partition number(s) is required.