SAP ABAP Data Element DB2TYPE (Tablespace type)
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
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 | DB2TYPE |
| Short Description | Tablespace type |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | DB2TYPE | |
| Data Type | CHAR | Character String |
| Length | 1 | |
| Decimal Places | 0 | |
| Output Length | 1 | |
| 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 | Type |
| Medium | 20 | Type of tablespace |
| Long | 20 | Type of tablespace |
| Heading | 26 | SYSIBM.SYSTABLESPACE(TYPE) |
Documentation
Definition
Column TYPE in catalog table SYSIBM.SYSTABLESPACE.. The following values are taken from official IBM documentation and may not be valid anymore. Please refer to the most current documentation to be sure.
blank
The table space was created without any of the following options: DSSIZE, LARGE, LOB, and MEMBER CLUSTER.
I
The table space was defined with the MEMBER CLUSTER option and is not greater than 64 gigabytes.
K
The table space was defined with the MEMBER CLUSTER option and can be greater than 64 gigabytes.
L
The table space can be greater than 64 gigabytes.
O
The table space was defined with the LOB option (the table space is a LOB table space).
History
| Last changed by/on | SAP | 20070813 |
| SAP Release Created in | 710 |
