SAP ABAP Table DB4_SQ3002 (iSeries: Created Indexes (Database Monitor))

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	DB4_SQ3002	Table Relationship Diagram
Short Description	iSeries: Created Indexes (Database Monitor)

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	QQTIME	☐	QQTIME	QQTIME	CHAR	26	0	iSeries: Record Creation Timestamp (Database Monitor)
3	QQQDTN	☐	QQDTN	QQDEC150	DEC	15	0	iSeries: Query Definition Template Number
4	QQQDTL	☐	QQDTL	QQDEC150	DEC	15	0	iSeries: Query Definition Template Level
5	QQMATN	☐	QMATN	QQDEC150	DEC	15	0	iSeries: Mat. QDT Number (Database Monitor)
6	QQMATL	☐	QMATL	QQDEC150	DEC	15	0	iSeries: Mat. QDT Level (Database Monitor)
7	QQTLN	☐	QQTLN	QQTLN	CHAR	10	0	iSeries: System Name of Library (Database Monitor)
8	QQTFN	☐	QTFN	AS4TAB	CHAR	30	0	iSeries: System Name of Table (Database Monitor)	*
9	QQPTLN	☐	QQPTLN	QQTLN	CHAR	10	0	iSeries: System Name of Base Library (Database Monitor)
10	QQPTFN	☐	QPTFN	AS4TAB	CHAR	30	0	iSeries: System Name of Base Table (Database Monitor)	*
11	QQILNM	☐	QQILNM	QQTLN	CHAR	10	0	iSeries: System Name of Index Library (Database Monitor)
12	QQIFNM	☐	QIFNM	DBINDEX	CHAR	18	0	iSeries: System Name of Index (Database Monitor)
13	QQNTNM	☐	QQNTNM	QQTFN	CHAR	10	0	iSeries: System Name of NLSS Table (Database Monitor)
14	QQNLNM	☐	QQNLNM	QQTLN	CHAR	10	0	iSeries: System Name of NLSS Library (Database Monitor)
15	QQTOTR	☐	QTOTR	QQDEC150	DEC	15	0	iSeries: Total Rows in Table (Database Monitor)
16	QQRIDX	☐	QRIDX	QQDEC150	DEC	15	0	iSeries: Number of Entries in Created Index
17	QQREST	☐	QREST	QQDEC150	DEC	15	0	iSeries: Estimated No. of Selected Rows (Database Monitor)
18	QQFKEY	☐	QFKEY	QQDEC150	DEC	15	0	iSeries: Estimated Rows Returned by Key Positioning
19	QQKSEL	☐	QKSEL	QQDEC150	DEC	15	0	iSeries: Estimated Rows Returned by Key Selection
20	QQAJN	☐	QAJN	QQDEC150	DEC	15	0	iSeries: Estimated Number of Joined Rows (Database Monitor)
21	QQJNP	☐	QJNP	QQDEC150	DEC	15	0	iSeries: Join Position (Database Monitor)
22	QQJNDS	☐	QQJNDS	QQDEC150	DEC	15	0	iSeries: Dataspace Number (Database Monitor)
23	QQJNMT	☐	QQJNMT	QQC21	CHAR	2	0	iSeries: Join Method (Database Monitor)
24	QQJNTY	☐	QQJNTY	QQC21	CHAR	2	0	iSeries: Join Type (Database Monitor)
25	QQJNOP	☐	QQJNOP	QQC21	CHAR	2	0	iSeries: Join Operator (Database Monitor)
26	QQIDXK	☐	QQIDXK	QQDEC150	DEC	15	0	iSeries: No. of Key Fields of Advised Index
27	QQEPT	☐	QEPT	QQDEC150	DEC	15	0	iSeries: Estimated Processing Time (Database Monitor)
28	QQKP	☐	QQKP	QQYN	CHAR	1	0	iSeries: Key Positioning (Database Monitor)
29	QQKPN	☐	QQKPN	QQDEC150	DEC	15	0	iSeries: No. of Key Positioning Keys (Database Monitor)
30	QQKS	☐	QQKS	QQYN	CHAR	1	0	iSeries: Key Selection (Database Monitor)
31	QQDSS	☐	QQDSS	QQYN	CHAR	1	0	iSeries: Dataspace Selection (Database Monitor)
32	QQIDXA	☐	QQIDXA	QQYN	CHAR	1	0	iSeries: Optimizer Advised Index (Database Monitor)
33	QQCST	☐	QQCST	QQC11	CHAR	1	0	iSeries: Constraint Used (Y/N) (Database Monitor)
34	QQCSTN	☐	QQCSTN	DBINDEX	CHAR	18	0	iSeries: Constraint Name (Database Monitor)
35	QQRCOD	☐	QQRCODIDC	QQRCOD	CHAR	2	0	iSeries: Reason Code (Database Monitor)
36	QQTTIM	☐	QQTTIM	QQDEC150	DEC	15	0	iSeries: Time for Index Create (Database Monitor)
37	QQIDXD	☐	QQIDXD	QQIDXD	CHAR	255	0	iSeries: Key Fields for the Advised Index
38	QQLTLN	☐	QQLTLN		CHAR	128	0	iSeries: Library Name (Database Monitor)
39	QQLTFN	☐	QQLTFN		CHAR	128	0	iSeries: Table Name (Database Monitor)
40	QQLPTL	☐	QQLPTL		CHAR	128	0	iSeries: Base Library (Database Monitor)
41	QQLPTF	☐	QQLPTF		CHAR	128	0	iSeries: Base Table (Database Monitor)
42	QQLILN	☐	QQLILN		CHAR	128	0	iSeries: Index Library (Database Monitor)
43	QQLIFN	☐	QQLIFN		CHAR	128	0	iSeries: Index Name (Database Monitor)
44	QQLNTN	☐	QQLNTN		CHAR	128	0	iSeries: NLSS Table (Database Monitor)
45	QQLNLN	☐	QQLNLN		CHAR	128	0	iSeries: NLSS Library (Database Monitor)
46	QQC11	☐	QQC11	QQC11	CHAR	1	0	iSeries: Reserved Field (Database Monitor)
47	QQC12	☐	QQC12	QQC12	CHAR	1	0	iSeries: Reserved Field (Database Monitor)
48	QQC21	☐	QQC21	QQC21	CHAR	2	0	iSeries: Reserved Field (Database Monitor)
49	QQC22	☐	QQC22	QQC22	CHAR	2	0	iSeries: Reserved Field (Database Monitor)
50	QQI1	☐	QQI1	QQI1	INT4	10	0	iSeries: Reserved Field (Database Monitor)
51	QQI2	☐	QQI2	QQI2	INT4	10	0	iSeries: Reserved Field (Database Monitor)
52	QQC301	☐	QQC301	QQC301	CHAR	30	0	iSeries: Reserved Field (Database Monitor)
53	QQC302	☐	QQC302		CHAR	30	0	iSeries: Reserved Field (Database Monitor)
54	QQCRTK	☐			CHAR	1000	0

History

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