SAP ABAP Table DB4_SQ3000 (iSeries: Table Scans (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_SQ3000	Table Relationship Diagram
Short Description	iSeries: Table Scans (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	QQJNP	☐	QJNP	QQDEC150	DEC	15	0	iSeries: Join Position (Database Monitor)
8	QQTLN	☐	QQTLN	QQTLN	CHAR	10	0	iSeries: System Name of Library (Database Monitor)
9	QQTFN	☐	QTFN	AS4TAB	CHAR	30	0	iSeries: System Name of Table (Database Monitor)	*
10	QQPTLN	☐	QQPTLN	QQTLN	CHAR	10	0	iSeries: System Name of Base Library (Database Monitor)
11	QQPTFN	☐	QPTFN	AS4TAB	CHAR	30	0	iSeries: System Name of Base Table (Database Monitor)	*
12	QQTOTR	☐	QTOTR	QQDEC150	DEC	15	0	iSeries: Total Rows in Table (Database Monitor)
13	QQREST	☐	QREST	QQDEC150	DEC	15	0	iSeries: Estimated No. of Selected Rows (Database Monitor)
14	QQAJN	☐	QAJN	QQDEC150	DEC	15	0	iSeries: Estimated Number of Joined Rows (Database Monitor)
15	QQEPT	☐	QEPT	QQDEC150	DEC	15	0	iSeries: Estimated Processing Time (Database Monitor)
16	QQJNDS	☐	QQJNDS	QQDEC150	DEC	15	0	iSeries: Dataspace Number (Database Monitor)
17	QQJNMT	☐	QQJNMT	QQC21	CHAR	2	0	iSeries: Join Method (Database Monitor)
18	QQJNTY	☐	QQJNTY	QQC21	CHAR	2	0	iSeries: Join Type (Database Monitor)
19	QQJNOP	☐	QQJNOP	QQC21	CHAR	2	0	iSeries: Join Operator (Database Monitor)
20	QQDSS	☐	QQDSS	QQYN	CHAR	1	0	iSeries: Dataspace Selection (Database Monitor)
21	QQIDXA	☐	QQIDXA	QQYN	CHAR	1	0	iSeries: Optimizer Advised Index (Database Monitor)
22	QQRCOD	☐	QQRCODTSC	QQRCOD	CHAR	2	0	iSeries: Reason Code for Table Scan (Database Monitor)
23	QQLTLN	☐	QQLTLN		CHAR	128	0	iSeries: Library Name (Database Monitor)
24	QQLTFN	☐	QQLTFN		CHAR	128	0	iSeries: Table Name (Database Monitor)
25	QQLPTL	☐	QQLPTL		CHAR	128	0	iSeries: Base Library (Database Monitor)
26	QQLPTF	☐	QQLPTF		CHAR	128	0	iSeries: Base Table (Database Monitor)
27	QQC11	☐	QQC11	QQC11	CHAR	1	0	iSeries: Reserved Field (Database Monitor)
28	QQC12	☐	QQC12	QQC12	CHAR	1	0	iSeries: Reserved Field (Database Monitor)
29	QQC21	☐	QQC21	QQC21	CHAR	2	0	iSeries: Reserved Field (Database Monitor)
30	QQC22	☐	QQC22	QQC22	CHAR	2	0	iSeries: Reserved Field (Database Monitor)
31	QQI1	☐	QQI1	QQI1	INT4	10	0	iSeries: Reserved Field (Database Monitor)
32	QQI2	☐	QQI2	QQI2	INT4	10	0	iSeries: Reserved Field (Database Monitor)
33	QQC301	☐	QQC301	QQC301	CHAR	30	0	iSeries: Reserved Field (Database Monitor)
34	QQC302	☐	QQC302		CHAR	30	0	iSeries: Reserved Field (Database Monitor)
35	QQ1000	☐			CHAR	1000	0
36	QQIDXD	☐			CHAR	1000	0

History

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