SAP ABAP Table SQ3002_DB4 (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 TRANSP    Transparent table 
Transparent table SQ3002_DB4   Table Relationship Diagram
Short Description iSeries: Created 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 QQNTNM QQNTNM QQTFN CHAR 10   0   iSeries: System Name of NLSS Table (Database Monitor)  
17 QQNLNM QQNLNM QQTLN CHAR 10   0   iSeries: System Name of NLSS Library (Database Monitor)  
18 QQTOTR QTOTR QQDEC150 DEC 15   0   iSeries: Total Rows in Table (Database Monitor)  
19 QQRIDX QRIDX QQDEC150 DEC 15   0   iSeries: Number of Entries in Created Index  
20 QQREST QREST QQDEC150 DEC 15   0   iSeries: Estimated No. of Selected Rows (Database Monitor)  
21 QQFKEY QFKEY QQDEC150 DEC 15   0   iSeries: Estimated Rows Returned by Key Positioning  
22 QQKSEL QKSEL QQDEC150 DEC 15   0   iSeries: Estimated Rows Returned by Key Selection  
23 QQAJN QAJN QQDEC150 DEC 15   0   iSeries: Estimated Number of Joined Rows (Database Monitor)  
24 QQJNP QJNP QQDEC150 DEC 15   0   iSeries: Join Position (Database Monitor)  
25 QQJNDS QQJNDS QQDEC150 DEC 15   0   iSeries: Dataspace Number (Database Monitor)  
26 QQJNMT QQJNMT QQC21 CHAR 2   0   iSeries: Join Method (Database Monitor)  
27 QQJNTY QQJNTY QQC21 CHAR 2   0   iSeries: Join Type (Database Monitor)  
28 QQJNOP QQJNOP QQC21 CHAR 2   0   iSeries: Join Operator (Database Monitor)  
29 QQIDXK QQIDXK QQDEC150 DEC 15   0   iSeries: No. of Key Fields of Advised Index  
30 QQEPT QEPT QQDEC150 DEC 15   0   iSeries: Estimated Processing Time (Database Monitor)  
31 QQKP QQKP QQYN CHAR 1   0   iSeries: Key Positioning (Database Monitor)  
32 QQKPN QQKPN QQDEC150 DEC 15   0   iSeries: No. of Key Positioning Keys (Database Monitor)  
33 QQKS QQKS QQYN CHAR 1   0   iSeries: Key Selection (Database Monitor)  
34 QQDSS QQDSS QQYN CHAR 1   0   iSeries: Dataspace Selection (Database Monitor)  
35 QQIDXA QQIDXA QQYN CHAR 1   0   iSeries: Optimizer Advised Index (Database Monitor)  
36 QQCST QQCST QQC11 CHAR 1   0   iSeries: Constraint Used (Y/N) (Database Monitor)  
37 QQCSTN QQCSTN DBINDEX CHAR 18   0   iSeries: Constraint Name (Database Monitor)  
38 QQRCOD QQRCODIDC QQRCOD CHAR 2   0   iSeries: Reason Code (Database Monitor)  
39 QQTTIM QQTTIM QQDEC150 DEC 15   0   iSeries: Time for Index Create (Database Monitor)  
40 QQIDXD QQIDXD QQIDXD CHAR 255   0   iSeries: Key Fields for the Advised Index  
41 QQLTLN QQLTLN   CHAR 128   0   iSeries: Library Name (Database Monitor)  
42 QQLTFN QQLTFN   CHAR 128   0   iSeries: Table Name (Database Monitor)  
43 QQLPTL QQLPTL   CHAR 128   0   iSeries: Base Library (Database Monitor)  
44 QQLPTF QQLPTF   CHAR 128   0   iSeries: Base Table (Database Monitor)  
45 QQLILN QQLILN   CHAR 128   0   iSeries: Index Library (Database Monitor)  
46 QQLIFN QQLIFN   CHAR 128   0   iSeries: Index Name (Database Monitor)  
47 QQLNTN QQLNTN   CHAR 128   0   iSeries: NLSS Table (Database Monitor)  
48 QQLNLN QQLNLN   CHAR 128   0   iSeries: NLSS Library (Database Monitor)  
49 QQC11 QQC11 QQC11 CHAR 1   0   iSeries: Reserved Field (Database Monitor)  
50 QQC12 QQC12 QQC12 CHAR 1   0   iSeries: Reserved Field (Database Monitor)  
51 QQC21 QQC21 QQC21 CHAR 2   0   iSeries: Reserved Field (Database Monitor)  
52 QQC22 QQC22 QQC22 CHAR 2   0   iSeries: Reserved Field (Database Monitor)  
53 QQI1 QQI1 QQI1 INT4 10   0   iSeries: Reserved Field (Database Monitor)  
54 QQI2 QQI2 QQI2 INT4 10   0   iSeries: Reserved Field (Database Monitor)  
55 QQC301 QQC301 QQC301 CHAR 30   0   iSeries: Reserved Field (Database Monitor)  
56 QQC302 QQC302   CHAR 30   0   iSeries: Reserved Field (Database Monitor)  
57 QQCRTK_LEN INT2 INT2 INT2 5   0   2 byte integer (signed)  
58 QQCRTK QQCRTK QQCHAR1000 LCHR 1000   0   iSeries: Key Fields of Created Index (Database Monitor)  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 SQ3002_DB4 SYSID SQ1000_DB4 SYSID    
History
Last changed by/on SAP  20130604 
SAP Release Created in