SAP ABAP Table DB4IDC0100 (iSeries: Database Performance: Created Indexes (Main screen))

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB4 (Application Component) DB2 for AS/400
     ⤷ STU4 (Package) CCMS / AS/400

Basic Data

Table Category	INTTAB	Structure
Structure	DB4IDC0100	Table Relationship Diagram
Short Description	iSeries: Database Performance: Created Indexes (Main screen)

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	QQKEY	☐	QQKEY	QQKEY	CHAR	17	0	iSeries: Key Field (Database Monitor)
2	QQPTLN	☐	QQPTLN	QQTLN	CHAR	10	0	iSeries: System Name of Base Library (Database Monitor)
3	QQPTFN	☐	QPTFN	AS4TAB	CHAR	30	0	iSeries: System Name of Base Table (Database Monitor)	*
4	QQLPTL	☐	QQLPTL		CHAR	128	0	iSeries: Base Library (Database Monitor)
5	QQLPTF	☐	QQLPTF		CHAR	128	0	iSeries: Base Table (Database Monitor)
6	QQQRYCNT	☐	QQQRYCNT	QQDEC150	DEC	15	0	iSeries: Number of Different Statements (Database Monitor)
7	QQCIC	☐	QQCIC	QQDEC150	DEC	15	0	iSeries: Number of Index Creates (Database Monitor)
8	QQTOTR	☐	QTOTR	QQDEC150	DEC	15	0	iSeries: Total Rows in Table (Database Monitor)
9	QQRIDX	☐	QRIDX	QQDEC150	DEC	15	0	iSeries: Number of Entries in Created Index
10	QQRROW	☐	QQRROW	QQDEC150	DEC	15	0	iSeries: Result Rows (Database Monitor)
11	QQAVGT	☐	QQAVGT	QQDEC150	DEC	15	0	iSeries: Average Time (Database Monitor)
12	QQTTIM	☐	QQTTIM	QQDEC150	DEC	15	0	iSeries: Time for Index Create (Database Monitor)
13	TOTTIME	☐	TOTTIME	QQDEC150	DEC	15	0	iSeries: Total Time (Database Monitor)
14	QQUSER	☐	QQUSER	QQUSER	CHAR	10	0	iSeries: Job User (Database Monitor)

History

Last changed by/on	SAP	20070813
SAP Release Created in