SAP table DB4_SQ3000 (iSeries: Table Scans (Database Monitor))

Field Description Data Type Length Decimals Checktable Data Element
QQKEY iSeries: Key Field (Database Monitor) CHAR 17 0 QQKEY
QQTIME iSeries: Record Creation Timestamp (Database Monitor) CHAR 26 0 QQTIME
QQQDTN iSeries: Query Definition Template Number DEC 15 0 QQDTN
QQQDTL iSeries: Query Definition Template Level DEC 15 0 QQDTL
QQMATN iSeries: Mat. QDT Number (Database Monitor) DEC 15 0 QMATN
QQMATL iSeries: Mat. QDT Level (Database Monitor) DEC 15 0 QMATL
QQJNP iSeries: Join Position (Database Monitor) DEC 15 0 QJNP
QQTLN iSeries: System Name of Library (Database Monitor) CHAR 10 0 QQTLN
QQTFN iSeries: System Name of Table (Database Monitor) CHAR 30 0 * QTFN
QQPTLN iSeries: System Name of Base Library (Database Monitor) CHAR 10 0 QQPTLN
QQPTFN iSeries: System Name of Base Table (Database Monitor) CHAR 30 0 * QPTFN
QQTOTR iSeries: Total Rows in Table (Database Monitor) DEC 15 0 QTOTR
QQREST iSeries: Estimated No. of Selected Rows (Database Monitor) DEC 15 0 QREST
QQAJN iSeries: Estimated Number of Joined Rows (Database Monitor) DEC 15 0 QAJN
QQEPT iSeries: Estimated Processing Time (Database Monitor) DEC 15 0 QEPT
QQJNDS iSeries: Dataspace Number (Database Monitor) DEC 15 0 QQJNDS
QQJNMT iSeries: Join Method (Database Monitor) CHAR 2 0 QQJNMT
QQJNTY iSeries: Join Type (Database Monitor) CHAR 2 0 QQJNTY
QQJNOP iSeries: Join Operator (Database Monitor) CHAR 2 0 QQJNOP
QQDSS iSeries: Dataspace Selection (Database Monitor) CHAR 1 0 QQDSS
QQIDXA iSeries: Optimizer Advised Index (Database Monitor) CHAR 1 0 QQIDXA
QQRCOD iSeries: Reason Code for Table Scan (Database Monitor) CHAR 2 0 QQRCODTSC
QQLTLN iSeries: Library Name (Database Monitor) CHAR 128 0 QQLTLN
QQLTFN iSeries: Table Name (Database Monitor) CHAR 128 0 QQLTFN
QQLPTL iSeries: Base Library (Database Monitor) CHAR 128 0 QQLPTL
QQLPTF iSeries: Base Table (Database Monitor) CHAR 128 0 QQLPTF
QQC11 iSeries: Reserved Field (Database Monitor) CHAR 1 0 QQC11
QQC12 iSeries: Reserved Field (Database Monitor) CHAR 1 0 QQC12
QQC21 iSeries: Reserved Field (Database Monitor) CHAR 2 0 QQC21
QQC22 iSeries: Reserved Field (Database Monitor) CHAR 2 0 QQC22
QQI1 iSeries: Reserved Field (Database Monitor) INT4 10 0 QQI1
QQI2 iSeries: Reserved Field (Database Monitor) INT4 10 0 QQI2
QQC301 iSeries: Reserved Field (Database Monitor) CHAR 30 0 QQC301
QQC302 iSeries: Reserved Field (Database Monitor) CHAR 30 0 QQC302
QQ1000 CHAR 1000 0
QQIDXD CHAR 1000 0