Hierarchy
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-DB2 (Application Component) DB2 for z/OS⤷
STU2 (Package) CCMS for DB2 for OS/390
Basic Data
| Data Element | DB2RTSSHR |
| Short Description | SHRLEVEL parameter of the REORG utility |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | DB2SHRLVL | |
| Data Type | CHAR | Character String |
| Length | 10 | |
| Decimal Places | 0 | |
| Output Length | 10 | |
| 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 | Sharelevel |
| Medium | 15 | Sharelevel |
| Long | 20 | Sharelevel |
| Heading | 10 | Sharelevel |
Documentation
Definition
Specifies the method for performing the reorganization. The parameter following SHRLEVEL indicates the type of access allowed during the RELOAD phase of REORG.
NONE
Specifies that reorganization operates by unloading from the area being reorganized (while applications can read but cannot write to the area), reloading into that area (while applications have no access), and then allowing read/write access again.
If NONE is specified (explicitly or by default), the following parameters cannot be specified: MAPPINGTABLE (for REORG TABLESPACE), MAXRO, LONGLOG, DELAY, and DEADLINE. For REORG TABLESPACE, if SORTDATA is omitted, UNLOAD PAUSE is specified, or UNLOAD ONLY is specified, then NOSYSREC cannot be specified.
REFERENCE
Specifies that reorganization operates by unloading from the area being reorganized (while applications can read but cannot write to the area), reloading into a shadow copy of that area (while applications can read but cannot write to the original copy), switching applications' future access from the original copy to the shadow copy by exchanging the names of the datasets, and then allowing read/write access again.
If REFERENCE is specified, the following parameters cannot be specified:
o LOG (for REORG TABLESPACE). Reorganization with REFERENCE
always creates an image copy and always refrains from logging
records during reloading.
o UNLOAD. Reorganization with REFERENCE always performs UNLOAD
CONTINUE.
o MAPPINGTABLE (for REORG TABLESPACE), MAXRO, LONGLOG, and DELAY.
CHANGE
Specifies that reorganization operates by unloading from the area being reorganized (while applications can read and write to the area), reloading into a shadow copy of that area (while applications have read/write access to the orginal copy of the area), applying the log of the original copy to the shadow copy (while applications can read and usually write to the original copy), switching applications' future access from the original copy to the shadow copy by exchanging the names of the datasets, and then allowing read/write access again.
If CHANGE is specified, the following parameters cannot be specified:
o LOG (for REORG TABLESPACE). Reorganization with CHANGE always
creates an image copy and always refrains from logging records
during reloading.
o SORTDATA, NOSYSREC, SORTKEYS (for REORG TABLESPACE).
Reorganization with CHANGE always operates as if these
parameters were specified.
o UNLOAD. Reorganization with CHANGE always performs UNLOAD
CONTINUE.
History
| Last changed by/on | SAP | 20070813 |
| SAP Release Created in | 700 |
