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

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