SAP ABAP Table DB2IXDYNT (Template for List Output: Dynamics of 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	INTTAB	Structure
Structure	DB2IXDYNT	Table Relationship Diagram
Short Description	Template for List Output: Dynamics of Size of Indexes

Delivery and Maintenance

Pool/cluster
Delivery Class
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	NAME	☐	DB2IDXNAME	CHAR18	CHAR	18	0	Name of a DB2 for OS/390 index
2	CREATOR	☐	DB2CREATOR	CHAR8	CHAR	8	0	DB2 creator name
3	INDEXSPACE	☐	DB2IXSPACE	CHAR8	CHAR	8	0	Name of the indexspace that contains the index
4	DBNAME	☐	DB2DBNAME	D2DBNAME	CHAR	8	0	Database name
5	PARTITIONS	☐	DB2NUMPART	DB2SINT	INT2	5	0	Number of partitions of a tablespace or index
6	PART	☐	DB2PARTNRS	DB2SINT	INT2	5	0	Partition number
7	EXTENTS	☐	DB2NUMEXTS	DEC3	DEC	3	0	Total number of extents of a tablespace or index
8	CH_EXTENTS	☐	DB2CHGEXTT	DEC3	DEC	3	0	Number of extents: change per time interval
9	ALLOCSIZE	☐	DB2TSSIZ	DEC11	DEC	11	0	Total size of a tablespace (allocated storage in KB)
10	CH_ALLOCSZ	☐	DB2CHGSIZT	DEC11	DEC	11	0	Allocated storage in KB: change per time interval
11	FREESIZE	☐	DB2TSFREE	DEC11	DEC	11	0	Free size of a tablespace in KB (allocated minus used stor.)
12	CH_FREESIZ	☐	DB2CHGFRET	DEC11	DEC	11	0	Free storage in KB: Change per time interval

History

Last changed by/on	SAP	20070813
SAP Release Created in	700