SAP ABAP Data Element DB2CHGTBSM (RTS Table size (= TOTALENTRIES*AvgRowLen KB) monthly changes)
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
⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
⤷ STU2 (Package) CCMS for DB2 for OS/390
Basic Data
Data Element | DB2CHGTBSM |
Short Description | RTS Table size (= TOTALENTRIES*AvgRowLen KB) monthly changes |
Data Type
Category of Dictionary Type | D | Domain |
Type of Object Referenced | No Information | |
Domain / Name of Reference Type | FLTP | |
Data Type | FLTP | Floating point number, accurate to 8 bytes |
Length | 16 | |
Decimal Places | 16 | |
Output Length | 22 | |
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 | 9 | Chg/month |
Medium | 12 | Change/month |
Long | 28 | RTS Table size: change/month |
Heading | 28 | RTS Table size: change/month |
Documentation
Definition
This value is the change to the table size on a monthly basis.
The size of the table is calculated by Number of Rows * Average Row Length, where:
- Number of Rows =
- For single-table-tablespaces: The value of column TOTALROWS of table SYSIBM.TABLESPACESTATS for the tablespace the table is residing in.
- For multi-table-tablespaces: The value of column TOTALENTRIES of table SYSIBM.INDEXSPACESTATS for the primary key of the table.
- Average Row Length = The value of column AVGROWLEN of table SYSIBM.SYSTABLES for the table in question. It is calculated by RUNSTATS utility and thus is -1 if RUNSTATS has never been running on the table.
Since Real Time Statistics quite accurately reflect the number of rows, this approximation provides a sufficient accuracy.
The size is set to -1 if statistics have not been gathered for calculation of Average Row Length or if the object is a view, an alias or a temporary table.
History
Last changed by/on | SAP | 20070813 |
SAP Release Created in | 700 |