Hierarchy
⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
⤷ STU2 (Package) CCMS for DB2 for OS/390
Basic Data
Data Element | DB2RTSLOG |
Short Description | LOG option of the REORG TABLESPACE utility |
Data Type
Category of Dictionary Type | D | Domain |
Type of Object Referenced | No Information | |
Domain / Name of Reference Type | DB2YESNO | |
Data Type | CHAR | Character String |
Length | 3 | |
Decimal Places | 0 | |
Output Length | 3 | |
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 | Log |
Medium | 15 | Log |
Long | 20 | Log |
Heading | 8 | Log |
Documentation
Description
Specifies whether records are logged during the RELOAD phase of REORG. If the records are not logged, the tablespace is recoverable only after an image copy has been taken. If you specify COPYDDN, RECOVERYDDN, SHRLEVEL REFERENCE, or SHRLEVEL CHANGE, an image copy is taken during REORG execution.
YES
Logs records during the RELOAD phase. This option is not allowed
for any tablespace in DSNDB01 or DSNDB06, or if the SHRLEVEL
REFERENCE or CHANGE options are used.
If SHRLEVEL NONE is specified or implied, the default is LOG YES.
NO
Does not log records. Puts the tablespace in copy pending status
if either of these conditions is true:
o REORG is executed at the local site, and neither COPYDDN,
SHRLEVEL REFERENCE, nor SHRLEVEL CHANGE are specified.
o REORG is executed at the remote site, and RECOVERYDDN is not
specified.
History
Last changed by/on | SAP | 20070813 |
SAP Release Created in | 710 |