SAP ABAP Table DB4IDC0200 (iSeries: Database Performance: Created Indexes (Detail scr.))

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	DB4IDC0200	Table Relationship Diagram
Short Description	iSeries: Database Performance: Created Indexes (Detail scr.)

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	SYSID	☐	SYSYSID	SYCHAR08	CHAR	8	0	Name of SAP System
2	IPLTIME	☐	CHAR14	CHAR14	CHAR	14	0	Text field length 14
3	QQKEY	☐	QQKEY	QQKEY	CHAR	17	0	iSeries: Key Field (Database Monitor)
4	QQPTLN	☐	QQPTLN	QQTLN	CHAR	10	0	iSeries: System Name of Base Library (Database Monitor)
5	QQPTFN	☐	QPTFN	AS4TAB	CHAR	30	0	iSeries: System Name of Base Table (Database Monitor)	*
6	QQTLN	☐	QQTLN	QQTLN	CHAR	10	0	iSeries: System Name of Library (Database Monitor)
7	QQTFN	☐	QTFN	AS4TAB	CHAR	30	0	iSeries: System Name of Table (Database Monitor)	*
8	QQILNM	☐	QQILNM	QQTLN	CHAR	10	0	iSeries: System Name of Index Library (Database Monitor)
9	QQIFNM	☐	QIFNM	DBINDEX	CHAR	18	0	iSeries: System Name of Index (Database Monitor)
10	QQLPTL	☐	QQLPTL		CHAR	128	0	iSeries: Base Library (Database Monitor)
11	QQLPTF	☐	QQLPTF		CHAR	128	0	iSeries: Base Table (Database Monitor)
12	QQLTLN	☐	QQLTLN		CHAR	128	0	iSeries: Library Name (Database Monitor)
13	QQLTFN	☐	QQLTFN		CHAR	128	0	iSeries: Table Name (Database Monitor)
14	QQLILN	☐	QQLILN		CHAR	128	0	iSeries: Index Library (Database Monitor)
15	QQLIFN	☐	QQLIFN		CHAR	128	0	iSeries: Index Name (Database Monitor)
16	QQPLIB	☐	QQPLIB	QQC10	CHAR	10	0	iSeries: Package/Program Library (Database Monitor)
17	QQPNAM	☐	QQPNAM	QQC10	CHAR	10	0	iSeries: Package/Program Name (Database Monitor)
18	QQSNAM	☐	QQSNAM	QQC18	CHAR	18	0	iSeries: Statement Name (Database Monitor)
19	QQCNT	☐	QQCNT	QQDEC150	DEC	15	0	iSeries: No. of Executions of a Statement (Database Monitor)
20	QQCIC	☐	QQCIC	QQDEC150	DEC	15	0	iSeries: Number of Index Creates (Database Monitor)
21	QQTOTR	☐	QTOTR	QQDEC150	DEC	15	0	iSeries: Total Rows in Table (Database Monitor)
22	QQRIDX	☐	QRIDX	QQDEC150	DEC	15	0	iSeries: Number of Entries in Created Index
23	QQRROW	☐	QQRROW	QQDEC150	DEC	15	0	iSeries: Result Rows (Database Monitor)
24	TOTTIME	☐	TOTTIME	QQDEC150	DEC	15	0	iSeries: Total Time (Database Monitor)
25	QQAVGT	☐	QQAVGT	QQDEC150	DEC	15	0	iSeries: Average Time (Database Monitor)
26	QQMINT	☐	QQMINT	QQDEC150	DEC	15	0	iSeries: Minimum Time (Database Monitor)
27	QQMAXT	☐	QQMAXT	QQDEC150	DEC	15	0	iSeries: Maximum Time (Database Monitor)
28	QQMETU	☐	QQMETU	QQTIME	CHAR	26	0	iSeries: Timest. of Most Expensive Stmt. (Database Monitor)
29	QQTTIM	☐	QQTTIM	QQDEC150	DEC	15	0	iSeries: Time for Index Create (Database Monitor)
30	QQIDXA	☐	QQIDXA	QQYN	CHAR	1	0	iSeries: Optimizer Advised Index (Database Monitor)
31	QQCST	☐	QQCST	QQC11	CHAR	1	0	iSeries: Constraint Used (Y/N) (Database Monitor)
32	QQCSTN	☐	QQCSTN	DBINDEX	CHAR	18	0	iSeries: Constraint Name (Database Monitor)
33	QQRCOD	☐	QQRCODIDC	QQRCOD	CHAR	2	0	iSeries: Reason Code (Database Monitor)
34	QQCRTK	☐	QQCRTK	QQCHAR1000	LCHR	1000	0	iSeries: Key Fields of Created Index (Database Monitor)
35	QQSTTX_LEN	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
36	QQSTTX	☐	QQSTTX	QQLCHR	LCHR	8000	0	iSeries: Statement Text (Database Monitor)
37	QQUSER	☐	QQUSER	QQUSER	CHAR	10	0	iSeries: Job User (Database Monitor)

History

Last changed by/on	SAP	20130604
SAP Release Created in