SAP ABAP Table DB2DB02TBDYN (Tx DB02: Dynamics of the size of tables)

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

Table Category	TRANSP	Transparent table
Transparent table	DB2DB02TBDYN	Table Relationship Diagram
Short Description	Tx DB02: Dynamics of the size of tables

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CREATOR	☑	DB2CREATOR	CHAR8	CHAR	8	0	DB2 creator name
2	TBNAME	☑	DB2TBNAME	CHAR18	CHAR	18	0	Name of the table on which the index is defined
3	DBNAME	☐	DB2DBNAME	D2DBNAME	CHAR	8	0	Database name
4	TSNAME	☐	DB2TSNAME	CHAR8	CHAR	8	0	Name of the tablespace
5	TBSIZE	☐	DB2RTSTBSIZE	FLTP	FLTP	16	16	Real Time Statistics: Table size = TOTALENTRIES*AvgRowLen KB
6	TBSIZE_LAST	☐	DB2CHGTBSL	FLTP	FLTP	16	16	Tx DB02: Absolute difference in comparison to previous run
7	TBSIZE_PERC	☐	DB2CHGTBSP		INT4	10	0	Tx DB02: Difference (percent) in comparison to previous run
8	TBSIZE_FIRST	☐	DB2CHGTBSF	FLTP	FLTP	16	16	Tx DB02: Absolute difference in comparison to first run
9	D_TBSIZE	☐	DB2CHGTBSD	FLTP	FLTP	16	16	RTS Table size (= TOTALENTRIES*AvgRowLen KB) daily changes
10	W_TBSIZE	☐	DB2CHGTBSW	FLTP	FLTP	16	16	RTS Table size (= TOTALENTRIES*AvgRowLen KB) weekly changes
11	M_TBSIZE	☐	DB2CHGTBSM	FLTP	FLTP	16	16	RTS Table size (= TOTALENTRIES*AvgRowLen KB) monthly changes
12	RTS_TOTALROWS	☐	DB2RTSTOTALROWS	FLTP	FLTP	16	16	DB2/zOS: Real-Time Statistics tablespace TOTALROWS
13	TOTALROWS_LAST	☐	DB2CHGTBSL	FLTP	FLTP	16	16	Tx DB02: Absolute difference in comparison to previous run
14	TOTALROWS_PERC	☐	DB2CHGTBSP		INT4	10	0	Tx DB02: Difference (percent) in comparison to previous run
15	TOTALROWS_FIRST	☐	DB2CHGTBSF	FLTP	FLTP	16	16	Tx DB02: Absolute difference in comparison to first run
16	D_TOTALROWS	☐	DB2CHGROWD	FLTP	FLTP	16	16	Number of Rows: changes per day
17	W_TOTALROWS	☐	DB2CHGROWW	FLTP	FLTP	16	16	Number of Rows: changes per week
18	M_TOTALROWS	☐	DB2CHGROWM	FLTP	FLTP	16	16	Number of Rows: changes per month
19	SPACEF	☐	DB2TBSPACEF	FLTP	FLTP	16	16	Column SYSIBM.SYSTABLES(SPACEF): DASD space used for table
20	SPACEF_LAST	☐	DB2CHGTBSL	FLTP	FLTP	16	16	Tx DB02: Absolute difference in comparison to previous run
21	SPACEF_PERC	☐	DB2CHGTBSP		INT4	10	0	Tx DB02: Difference (percent) in comparison to previous run
22	SPACEF_FIRST	☐	DB2CHGTBSF	FLTP	FLTP	16	16	Tx DB02: Absolute difference in comparison to first run
23	D_SPACEF	☐	DB2CHGSPFD	FLTP	FLTP	16	16	Change/day for DASD space (SYSIBM.SYSTABLES(SPACEF))
24	W_SPACEF	☐	DB2CHGSPFW	FLTP	FLTP	16	16	Change/week for DASD space (SYSIBM.SYSTABLES(SPACEF))
25	M_SPACEF	☐	DB2CHGSPFM	FLTP	FLTP	16	16	Change/month for DASD space (SYSIBM.SYSTABLES(SPACEF))

History

Last changed by/on	SAP	20130604
SAP Release Created in	732