Hierarchy
⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
⤷ STU2 (Package) CCMS for DB2 for OS/390
Basic Data
Data Element | DB2RTSUNLD |
Short Description | UNLOAD parameter of the REORG utility |
Data Type
Category of Dictionary Type | D | Domain |
Type of Object Referenced | No Information | |
Domain / Name of Reference Type | CHAR8 | |
Data Type | CHAR | Character String |
Length | 8 | |
Decimal Places | 0 | |
Output Length | 8 | |
Value Table |
Further Characteristics
Search Help: Name | ||
Search Help: Parameters | ||
Parameter ID | ||
Default Component name | ||
Change document | ||
No Input History | ||
Basic direction is set to LTR | ||
No BIDI Filtering |
Field Label
Length | Field Label | |
Short | 10 | UNLOAD |
Medium | 15 | UNLOAD |
Long | 20 | UNLOAD |
Heading | 10 | UNLOAD |
Documentation
Definition
Specifies whether the utility job must continue processing or end after the data has been unloaded. Data can be reloaded only into the same table and tablespace (as defined in the DB2 catalog) on the same subsystem. (This does not preclude VSAM redefinition during UNLOAD PAUSE.)
You must specify UNLOAD ONLY for the dataset to be in a format compatible with the FORMAT UNLOAD option of LOAD. However, with LOAD you can load the data only into the same object from which it is unloaded.
CONTINUE
Specifies that, after the data has been unloaded, the utility
continues processing. An edit routine may be called to decode a
previously encoded data row if an index key needs to be extracted
from that row. Otherwise, edit routines or field procedures are
bypassed on both the UNLOAD and RELOAD phases for tablespaces.
Field procedures and validation procedures are not invoked during
either phase.
PAUSE
Specifies that after the data has been unloaded, processing ends.
The utility stops and the RELOAD status is stored in SYSIBM.SYSUTIL
so that processing can be restarted with RELOAD RESTART(PHASE).
This option is useful if you want to redefine data sets during
reorganization. For example, with a user defined dataset, you can:
o Run REORG with the UNLOAD PAUSE option
o Redefine the dataset using access method services
o Restart REORG by resubmitting the previous job and
specifying RESTART(PHASE).
Field procedures and validation procedures are not invoked during
either phase.
ONLY
Specifies that after the data has been unloaded, the utility job
ends and the status in SYSIBM.SYSUTIL corresponding to this
utility ID is removed.
If UNLOAD ONLY is specified with REORG TABLESPACE, any edit
routine or field procedure is invoked during record retrieval in
the UNLOAD phase. This option is not allowed for any tablespace in
DSNDB01 or DSNDB06.
History
Last changed by/on | SAP | 20070813 |
SAP Release Created in | 710 |