SAP ABAP Table SQ3000_DB4 (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 TRANSP    Transparent table 
Transparent table SQ3000_DB4   Table Relationship Diagram
Short Description iSeries: Table Scans (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  
2 IPLTIME CHAR14 CHAR14 CHAR 14   0   Text field length 14  
3 QQKEY QQKEY QQKEY CHAR 17   0   iSeries: Key Field (Database Monitor) SQ1000_DB4
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 QQJNP QJNP QQDEC150 DEC 15   0   iSeries: Join Position (Database Monitor)  
11 QQTLN QQTLN QQTLN CHAR 10   0   iSeries: System Name of Library (Database Monitor)  
12 QQTFN QTFN AS4TAB CHAR 30   0   iSeries: System Name of Table (Database Monitor) *
13 QQPTLN QQPTLN QQTLN CHAR 10   0   iSeries: System Name of Base Library (Database Monitor)  
14 QQPTFN QPTFN AS4TAB CHAR 30   0   iSeries: System Name of Base Table (Database Monitor) *
15 QQTOTR QTOTR QQDEC150 DEC 15   0   iSeries: Total Rows in Table (Database Monitor)  
16 QQREST QREST QQDEC150 DEC 15   0   iSeries: Estimated No. of Selected Rows (Database Monitor)  
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 QQJNDS QQJNDS QQDEC150 DEC 15   0   iSeries: Dataspace Number (Database Monitor)  
20 QQJNMT QQJNMT QQC21 CHAR 2   0   iSeries: Join Method (Database Monitor)  
21 QQJNTY QQJNTY QQC21 CHAR 2   0   iSeries: Join Type (Database Monitor)  
22 QQJNOP QQJNOP QQC21 CHAR 2   0   iSeries: Join Operator (Database Monitor)  
23 QQDSS QQDSS QQYN CHAR 1   0   iSeries: Dataspace Selection (Database Monitor)  
24 QQIDXA QQIDXA QQYN CHAR 1   0   iSeries: Optimizer Advised Index (Database Monitor)  
25 QQRCOD QQRCODTSC QQRCOD CHAR 2   0   iSeries: Reason Code for Table Scan (Database Monitor)  
26 QQLTLN QQLTLN   CHAR 128   0   iSeries: Library Name (Database Monitor)  
27 QQLTFN QQLTFN   CHAR 128   0   iSeries: Table Name (Database Monitor)  
28 QQLPTL QQLPTL   CHAR 128   0   iSeries: Base Library (Database Monitor)  
29 QQLPTF QQLPTF   CHAR 128   0   iSeries: Base Table (Database Monitor)  
30 QQC11 QQC11 QQC11 CHAR 1   0   iSeries: Reserved Field (Database Monitor)  
31 QQC12 QQC12 QQC12 CHAR 1   0   iSeries: Reserved Field (Database Monitor)  
32 QQC21 QQC21 QQC21 CHAR 2   0   iSeries: Reserved Field (Database Monitor)  
33 QQC22 QQC22 QQC22 CHAR 2   0   iSeries: Reserved Field (Database Monitor)  
34 QQI1 QQI1 QQI1 INT4 10   0   iSeries: Reserved Field (Database Monitor)  
35 QQI2 QQI2 QQI2 INT4 10   0   iSeries: Reserved Field (Database Monitor)  
36 QQC301 QQC301 QQC301 CHAR 30   0   iSeries: Reserved Field (Database Monitor)  
37 QQC302 QQC302   CHAR 30   0   iSeries: Reserved Field (Database Monitor)  
38 QQ1000 QQ1000   CHAR 255   0   iSeries: Reserved Field (Database Monitor)  
39 QQIDXD_LEN INT2 INT2 INT2 5   0   2 byte integer (signed)  
40 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 SQ3000_DB4 QQKEY SQ1000_DB4 QQKEY    
History
Last changed by/on SAP  20130604 
SAP Release Created in