SAP ABAP Data Element DB2CHGTBSW (RTS Table size (= TOTALENTRIES*AvgRowLen KB) weekly 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	DB2CHGTBSW
Short Description	RTS Table size (= TOTALENTRIES*AvgRowLen KB) weekly 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	8	Chg/week
Medium	11	Change/week
Long	27	RTS Table size: change/week
Heading	27	RTS Table size: change/week

Documentation

Definition

This value is the change to the table size on a weekly 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