SAP ABAP Table DB2DB02IXDYN (Tx DB02: Dynamics of the size of indexes)

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	DB2DB02IXDYN	Table Relationship Diagram
Short Description	Tx DB02: Dynamics of the size of indexes

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	IXCREATOR	☑	DB2CREATOR	CHAR8	CHAR	8	0	DB2 creator name
2	IXNAME	☑	DB2IDXNAME	CHAR18	CHAR	18	0	Name of a DB2 for OS/390 index
3	PART_EXTENSION	☑	DB2PARTEXT		INT4	10	0	Extension or Partition (non-partitioned TS) number
4	DBNAME	☐	DB2DBNAME	D2DBNAME	CHAR	8	0	Database name
5	IXSPACE	☐	DB2IXSPACE	CHAR8	CHAR	8	0	Name of the indexspace that contains the index
6	PARTITIONS	☐	DB2NUMPART	DB2SINT	INT2	5	0	Number of partitions of a tablespace or index
7	EXTENTS	☐	DB2NUMEXTI		INT4	10	0	Number of extents
8	EXTENTS_LAST	☐	DB2CHGTBSL	FLTP	FLTP	16	16	Tx DB02: Absolute difference in comparison to previous run
9	EXTENTS_PERC	☐	DB2CHGTBSP		INT4	10	0	Tx DB02: Difference (percent) in comparison to previous run
10	EXTENTS_FIRST	☐	DB2CHGTBSF	FLTP	FLTP	16	16	Tx DB02: Absolute difference in comparison to first run
11	D_EXTENTS	☐	DB2CHGEXDI		INT4	10	0	Number of extents: change per day
12	W_EXTENTS	☐	DB2CHGEXWI		INT4	10	0	Number of extents: change per week
13	M_EXTENTS	☐	DB2CHGEXMI		INT4	10	0	Number of extents: change per month
14	ALLOCSIZE	☐	DB2IXSIZ	DEC11	DEC	11	0	Total size of an index (allocated storage in KB)
15	ALLOCSIZ_LAST	☐	DB2CHGTBSL	FLTP	FLTP	16	16	Tx DB02: Absolute difference in comparison to previous run
16	ALLOCSIZ_PERC	☐	DB2CHGTBSP		INT4	10	0	Tx DB02: Difference (percent) in comparison to previous run
17	ALLOCSIZ_FIRST	☐	DB2CHGTBSF	FLTP	FLTP	16	16	Tx DB02: Absolute difference in comparison to first run
18	D_ALLOCSIZ	☐	DB2CHGSIZD	DEC11	DEC	11	0	Allocated storage in KB: change per day
19	W_ALLOCSIZ	☐	DB2CHGSIZW	DEC11	DEC	11	0	Allocated storage in KB: change per week
20	M_ALLOCSIZ	☐	DB2CHGSIZM	DEC11	DEC	11	0	Allocated storage in KB: change per month
21	FREESIZE	☐	DB2IXFREE	DEC11	DEC	11	0	Free size of an index in KB (allocated minus used storage)
22	FREESIZE_LAST	☐	DB2CHGTBSL	FLTP	FLTP	16	16	Tx DB02: Absolute difference in comparison to previous run
23	FREESIZE_PERC	☐	DB2CHGTBSP		INT4	10	0	Tx DB02: Difference (percent) in comparison to previous run
24	FREESIZE_FIRST	☐	DB2CHGTBSF	FLTP	FLTP	16	16	Tx DB02: Absolute difference in comparison to first run
25	D_FREESIZ	☐	DB2CHGFRED	DEC11	DEC	11	0	Free storage (allocated minus used) in KB: change per day
26	W_FREESIZ	☐	DB2CHGFREW	DEC11	DEC	11	0	Free storage (allocated minus used) in KB: change per week
27	M_FREESIZ	☐	DB2CHGFREM	DEC11	DEC	11	0	Free storage (allocated minus used) in KB: change per month
28	RTS_TOTALENTRIES	☐	DB2RTSTOTALENTRY	FLTP	FLTP	16	16	DB2/zOS: Real-Time Statistics index TOTALENTRIES
29	TOTALENTRIES_LAS	☐	DB2CHGTBSL	FLTP	FLTP	16	16	Tx DB02: Absolute difference in comparison to previous run
30	TOTALENTRIES_PER	☐	DB2CHGTBSP		INT4	10	0	Tx DB02: Difference (percent) in comparison to previous run
31	TOTALENTRIES_FIR	☐	DB2CHGTBSF	FLTP	FLTP	16	16	Tx DB02: Absolute difference in comparison to first run
32	D_TOTALENTRIES	☐	DB2CHGROWD	FLTP	FLTP	16	16	Number of Rows: changes per day
33	W_TOTALENTRIES	☐	DB2CHGROWW	FLTP	FLTP	16	16	Number of Rows: changes per week
34	M_TOTALENTRIES	☐	DB2CHGROWM	FLTP	FLTP	16	16	Number of Rows: changes per month

History

Last changed by/on	SAP	20130604
SAP Release Created in