SAP ABAP Table SQ3001_DB4 (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 TRANSP    Transparent table 
Transparent table SQ3001_DB4   Table Relationship Diagram
Short Description iSeries: Used Indexes (Database Monitor)    
Delivery and Maintenance
Pool/cluster      
Delivery Class L   Table for storing temporary data, delivered empty 
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 SQ1000_DB4
2 IPLTIME CHAR14 CHAR14 CHAR 14   0   Text field length 14  
3 QQKEY QQKEY QQKEY CHAR 17   0   iSeries: Key Field (Database Monitor)  
4 QQKEY2 QQKEY2 QQDEC150 DEC 15   0   iSeries: 2nd Key Field of Database Monitor Files  
5 QQTIME QQTIME QQTIME CHAR 26   0   iSeries: Record Creation Timestamp (Database Monitor)  
6 QQQDTN QQDTN QQDEC150 DEC 15   0   iSeries: Query Definition Template Number  
7 QQQDTL QQDTL QQDEC150 DEC 15   0   iSeries: Query Definition Template Level  
8 QQMATN QMATN QQDEC150 DEC 15   0   iSeries: Mat. QDT Number (Database Monitor)  
9 QQMATL QMATL QQDEC150 DEC 15   0   iSeries: Mat. QDT Level (Database Monitor)  
10 QQTLN QQTLN QQTLN CHAR 10   0   iSeries: System Name of Library (Database Monitor)  
11 QQTFN QTFN AS4TAB CHAR 30   0   iSeries: System Name of Table (Database Monitor) *
12 QQPTLN QQPTLN QQTLN CHAR 10   0   iSeries: System Name of Base Library (Database Monitor)  
13 QQPTFN QPTFN AS4TAB CHAR 30   0   iSeries: System Name of Base Table (Database Monitor) *
14 QQILNM QQILNM QQTLN CHAR 10   0   iSeries: System Name of Index Library (Database Monitor)  
15 QQIFNM QIFNM DBINDEX CHAR 18   0   iSeries: System Name of Index (Database Monitor)  
16 QQTOTR QTOTR QQDEC150 DEC 15   0   iSeries: Total Rows in Table (Database Monitor)  
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 QQEPT QEPT QQDEC150 DEC 15   0   iSeries: Estimated Processing Time (Database Monitor)  
22 QQJNP QJNP QQDEC150 DEC 15   0   iSeries: Join Position (Database Monitor)  
23 QQJNDS QQJNDS QQDEC150 DEC 15   0   iSeries: Dataspace Number (Database Monitor)  
24 QQJNMT QQJNMT QQC21 CHAR 2   0   iSeries: Join Method (Database Monitor)  
25 QQJNTY QQJNTY QQC21 CHAR 2   0   iSeries: Join Type (Database Monitor)  
26 QQJNOP QQJNOP QQC21 CHAR 2   0   iSeries: Join Operator (Database Monitor)  
27 QQIDXK QQIDXK QQDEC150 DEC 15   0   iSeries: No. of Key Fields of Advised Index  
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 QQRCOD QQRCODIDU QQRCOD CHAR 2   0   iSeries: Reason Code for Used Index (Database Monitor)  
34 QQCST QQCST QQC11 CHAR 1   0   iSeries: Constraint Used (Y/N) (Database Monitor)  
35 QQCSTN QQCSTN DBINDEX CHAR 18   0   iSeries: Constraint Name (Database Monitor)  
36 QQLTLN QQLTLN   CHAR 128   0   iSeries: Library Name (Database Monitor)  
37 QQLTFN QQLTFN   CHAR 128   0   iSeries: Table Name (Database Monitor)  
38 QQLPTL QQLPTL   CHAR 128   0   iSeries: Base Library (Database Monitor)  
39 QQLPTF QQLPTF   CHAR 128   0   iSeries: Base Table (Database Monitor)  
40 QQLILN QQLILN   CHAR 128   0   iSeries: Index Library (Database Monitor)  
41 QQLIFN QQLIFN   CHAR 128   0   iSeries: Index Name (Database Monitor)  
42 QQC11 QQC11 QQC11 CHAR 1   0   iSeries: Reserved Field (Database Monitor)  
43 QQC12 QQC12 QQC12 CHAR 1   0   iSeries: Reserved Field (Database Monitor)  
44 QQC21 QQC21 QQC21 CHAR 2   0   iSeries: Reserved Field (Database Monitor)  
45 QQC22 QQC22 QQC22 CHAR 2   0   iSeries: Reserved Field (Database Monitor)  
46 QQI1 QQI1 QQI1 INT4 10   0   iSeries: Reserved Field (Database Monitor)  
47 QQI2 QQI2 QQI2 INT4 10   0   iSeries: Reserved Field (Database Monitor)  
48 QQC301 QQC301 QQC301 CHAR 30   0   iSeries: Reserved Field (Database Monitor)  
49 QQC302 QQC302   CHAR 30   0   iSeries: Reserved Field (Database Monitor)  
50 QQ1000 QQ1000   CHAR 255   0   iSeries: Reserved Field (Database Monitor)  
51 QQIDXD_LEN INT2 INT2 INT2 5   0   2 byte integer (signed)  
52 QQIDXD QIDXD QQCHAR1000 LCHR 1000   0   iSeries: Definition of Advised Index (Database Monitor)  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 SQ3001_DB4 SYSID SQ1000_DB4 SYSID    
History
Last changed by/on SAP  20130604 
SAP Release Created in