Hierarchy
⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
⤷ STU2 (Package) CCMS for DB2 for OS/390
Basic Data
Data Element | DB2TABSIZD |
Short Description | Reserved storage space of a table in KBytes |
Data Type
Category of Dictionary Type | D | Domain |
Type of Object Referenced | No Information | |
Domain / Name of Reference Type | DEC11 | |
Data Type | DEC | Counter or amount field with comma and sign |
Length | 11 | |
Decimal Places | 0 | |
Output Length | 14 | |
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 | Size (KB) |
Medium | 18 | Table size (KB) |
Long | 20 | Table size (KB) |
Heading | 0 |
Documentation
Definition
The storage space reserved by the table in KB.
The size of a table is roughly computed using the information in the DB2 directory:
Size (KB) = NPAGES * PGSIZE.
Field NPAGES in the DB2 directory table SYSIBM.SYSTABLES defines the number of pages that contain table records. This field can only be maintained by DB2 with the utility RUNSTATS, which must be triggered externally. The given value could therefore be obsolete. The field STATSTIME in table SYSIBM.SYSTABLES shows when the field was last updated. If there are no statistics available, the size of the table is defined as 0 KB.
The field PGSIZE in the DB2 directory table SYSIBM.SYSTABLESPACE defines the page size of the corresponding tablespace in KB.
DB2 permits a page to contain records of more than one table, but only for "simple tablespaces" that are not used in R/3.
History
Last changed by/on | SAP | 20070813 |
SAP Release Created in |