SAP ABAP Table DB4_SQ3001 (iSeries: Used 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_SQ3001   Table Relationship Diagram
Short Description iSeries: Used 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 QQTOTR QTOTR QQDEC150 DEC 15   0   iSeries: Total Rows in Table (Database Monitor)  
14 QQREST QREST QQDEC150 DEC 15   0   iSeries: Estimated No. of Selected Rows (Database Monitor)  
15 QQFKEY QFKEY QQDEC150 DEC 15   0   iSeries: Estimated Rows Returned by Key Positioning  
16 QQKSEL QKSEL QQDEC150 DEC 15   0   iSeries: Estimated Rows Returned by Key Selection  
17 QQAJN QAJN QQDEC150 DEC 15   0   iSeries: Estimated Number of Joined Rows (Database Monitor)  
18 QQEPT QEPT QQDEC150 DEC 15   0   iSeries: Estimated Processing Time (Database Monitor)  
19 QQJNP QJNP QQDEC150 DEC 15   0   iSeries: Join Position (Database Monitor)  
20 QQJNDS QQJNDS QQDEC150 DEC 15   0   iSeries: Dataspace Number (Database Monitor)  
21 QQJNMT QQJNMT QQC21 CHAR 2   0   iSeries: Join Method (Database Monitor)  
22 QQJNTY QQJNTY QQC21 CHAR 2   0   iSeries: Join Type (Database Monitor)  
23 QQJNOP QQJNOP QQC21 CHAR 2   0   iSeries: Join Operator (Database Monitor)  
24 QQIDXK QQIDXK QQDEC150 DEC 15   0   iSeries: No. of Key Fields of Advised Index  
25 QQKP QQKP QQYN CHAR 1   0   iSeries: Key Positioning (Database Monitor)  
26 QQKPN QQKPN QQDEC150 DEC 15   0   iSeries: No. of Key Positioning Keys (Database Monitor)  
27 QQKS QQKS QQYN CHAR 1   0   iSeries: Key Selection (Database Monitor)  
28 QQDSS QQDSS QQYN CHAR 1   0   iSeries: Dataspace Selection (Database Monitor)  
29 QQIDXA QQIDXA QQYN CHAR 1   0   iSeries: Optimizer Advised Index (Database Monitor)  
30 QQRCOD QQRCODIDU QQRCOD CHAR 2   0   iSeries: Reason Code for Used 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 QQLTLN QQLTLN   CHAR 128   0   iSeries: Library Name (Database Monitor)  
34 QQLTFN QQLTFN   CHAR 128   0   iSeries: Table Name (Database Monitor)  
35 QQLPTL QQLPTL   CHAR 128   0   iSeries: Base Library (Database Monitor)  
36 QQLPTF QQLPTF   CHAR 128   0   iSeries: Base Table (Database Monitor)  
37 QQLILN QQLILN   CHAR 128   0   iSeries: Index Library (Database Monitor)  
38 QQLIFN QQLIFN   CHAR 128   0   iSeries: Index Name (Database Monitor)  
39 QQC11 QQC11 QQC11 CHAR 1   0   iSeries: Reserved Field (Database Monitor)  
40 QQC12 QQC12 QQC12 CHAR 1   0   iSeries: Reserved Field (Database Monitor)  
41 QQC21 QQC21 QQC21 CHAR 2   0   iSeries: Reserved Field (Database Monitor)  
42 QQC22 QQC22 QQC22 CHAR 2   0   iSeries: Reserved Field (Database Monitor)  
43 QQI1 QQI1 QQI1 INT4 10   0   iSeries: Reserved Field (Database Monitor)  
44 QQI2 QQI2 QQI2 INT4 10   0   iSeries: Reserved Field (Database Monitor)  
45 QQC301 QQC301 QQC301 CHAR 30   0   iSeries: Reserved Field (Database Monitor)  
46 QQC302 QQC302   CHAR 30   0   iSeries: Reserved Field (Database Monitor)  
47 QQ1000     CHAR 1000   0    
48 QQIDXD     CHAR 1000   0    
History
Last changed by/on SAP  20070813 
SAP Release Created in 640