Where Used List (Data Element) for SAP ABAP Domain QQDEC150 (QQDEC150: DEC(15,0) (DBMon for iSeries))
SAP ABAP Domain
QQDEC150 (QQDEC150: DEC(15,0) (DBMon for iSeries)) is used by
| # | Object Type | Object Name | Object Description | Package | Structure Package | Software Component |
|---|---|---|---|---|---|---|
| 1 | LOGICREAD | iSeries: Number of Logical Reads | ||||
| 2 | PHYSREAD | iSeries: Number of Physical Reads | ||||
| 3 | QAJN | iSeries: Estimated Number of Joined Rows (Database Monitor) | ||||
| 4 | QEPT | iSeries: Estimated Processing Time (Database Monitor) | ||||
| 5 | QFKEY | iSeries: Estimated Rows Returned by Key Positioning | ||||
| 6 | QJNP | iSeries: Join Position (Database Monitor) | ||||
| 7 | QKSEL | iSeries: Estimated Rows Returned by Key Selection | ||||
| 8 | QMATL | iSeries: Mat. QDT Level (Database Monitor) | ||||
| 9 | QMATN | iSeries: Mat. QDT Number (Database Monitor) | ||||
| 10 | QQARSS | iSeries: Average Result Set Size (Database Monitor) | ||||
| 11 | QQAVGT | iSeries: Average Time (Database Monitor) | ||||
| 12 | QQCAPR | iSeries: No of Access Plan Rebuilds (Database Monitor) | ||||
| 13 | QQCIA | iSeries: Index Advice (Database Monitor) | ||||
| 14 | QQCIC | iSeries: Number of Index Creates (Database Monitor) | ||||
| 15 | QQCIU | iSeries: Index Usage (Database Monitor) | ||||
| 16 | QQCLST | iSeries: CLOSE time (Database Monitor) | ||||
| 17 | QQCNT | iSeries: No. of Executions of a Statement (Database Monitor) | ||||
| 18 | QQCOMCNT | iSeries: No. of Executed COMMITs (Database Monitor) | ||||
| 19 | QQCS | QQCS: Sorts count (database monitor for iSeries) | ||||
| 20 | QQCSO | iSeries: No. of Sorts (Database Monitor) | ||||
| 21 | QQCTF | iSeries: No. of Temporaray File Creates (Database Monitor) | ||||
| 22 | QQCTS | iSeries: Number of Table Scans (Database Monitor) | ||||
| 23 | QQDDLCNT | iSeries: Number of Executed DDL Statements | ||||
| 24 | QQDELCNT | iSeries: Number of Executed DELETEs (Database Monitor) | ||||
| 25 | QQDTL | iSeries: Query Definition Template Level | ||||
| 26 | QQDTN | iSeries: Query Definition Template Number | ||||
| 27 | QQEBUF | iSeries: External Buffer (Database Monitor) | ||||
| 28 | QQFETT | iSeries: FETCH time (Database Monitor) | ||||
| 29 | QQFULO | iSeries: Number of FULL OPENs (Database Monitor) | ||||
| 30 | QQIBUF | iSeries: Internal Buffer (Database Monitor) | ||||
| 31 | QQIDACNT | iSeries: Index Advice (Database Monitor) | ||||
| 32 | QQIDAQRYCT | iSeries: Number of Index Advices (Database Monitor) | ||||
| 33 | QQIDATBCNT | iSeries: Number of Tables over which Indexes are Advised | ||||
| 34 | QQIDCCNT | iSeries: Number of Index Creates (Database Monitor) | ||||
| 35 | QQIDXK | iSeries: No. of Key Fields of Advised Index | ||||
| 36 | QQINSCNT | iSeries: Number of Executed INSERTs (Database Monitor) | ||||
| 37 | QQJNDS | iSeries: Dataspace Number (Database Monitor) | ||||
| 38 | QQKEY2 | iSeries: 2nd Key Field of Database Monitor Files | ||||
| 39 | QQKPN | iSeries: No. of Key Positioning Keys (Database Monitor) | ||||
| 40 | QQMAXT | iSeries: Maximum Time (Database Monitor) | ||||
| 41 | QQMINT | iSeries: Minimum Time (Database Monitor) | ||||
| 42 | QQMRGQ | iSeries: Merged QDTs (Database Monitor) | ||||
| 43 | QQOPNT | iSeries: Open time (Database Monitor) | ||||
| 44 | QQORGQ | iSeries: Original Number of QDTs (Database Monitor) | ||||
| 45 | QQOTHCNT | iSeries: Number of Miscellaneous Statements | ||||
| 46 | QQOTHT | iSeries: Any other time (Database Monitor) | ||||
| 47 | QQPID | iSeries: Pool ID (Database Monitor) | ||||
| 48 | QQPSIZ | iSeries: Pool Size (Database Monitor) | ||||
| 49 | QQPSUO | iSeries: Number of PSEUDO OPENs (Database Monitor) | ||||
| 50 | QQQRYCNT | iSeries: Number of Different Statements (Database Monitor) | ||||
| 51 | QQRBKCNT | iSeries: Number of Executed ROLLBACKs (Database Monitor) | ||||
| 52 | QQRROW | iSeries: Result Rows (Database Monitor) | ||||
| 53 | QQSELCNT | iSeries: Number of Executed SELECTs (Database Monitor) | ||||
| 54 | QQSRTCNT | iSeries: Number of Sorts (Database Monitor) | ||||
| 55 | QQSRTTOTR | iSeries: Total Rows Sorted (Database Monitor) | ||||
| 56 | QQSSIZ | iSeries: Sort Size (Database Monitor) | ||||
| 57 | QQSUMCNT | iSeries: Number of Executed SQL Statements | ||||
| 58 | QQTDBTIME | iSeries: Total Database Processing Time (Database Monitor) | ||||
| 59 | QQTMFCNT | iSeries: Number of Temporary Files Created | ||||
| 60 | QQTOTAVGT | iSeries: Overall Average Execution Time (Database Monitor) | ||||
| 61 | QQTSCCNT | iSeries: Number of Table Scans | ||||
| 62 | QQTSCTOTR | iSeries: Total Rows Read by Table Scans | ||||
| 63 | QQTTIM | iSeries: Time for Index Create (Database Monitor) | ||||
| 64 | QQTTIM_SRT | iSeries: Sort Time (Database Monitor) | ||||
| 65 | QQTTIM_TF | iSeries: Create Time of Temporary Table (Database Monitor) | ||||
| 66 | QQUPDCNT | iSeries: Number of Executed UPDATEs (Database Monitor) | ||||
| 67 | QREST | iSeries: Estimated No. of Selected Rows (Database Monitor) | ||||
| 68 | QRIDX | iSeries: Number of Entries in Created Index | ||||
| 69 | QRSS | iSeries: Number of Rows Sorted (Database Monitor) | ||||
| 70 | QTMPR | iSeries: Rows in Temporary Table (Database Monitor) | ||||
| 71 | QTOTR | iSeries: Total Rows in Table (Database Monitor) | ||||
| 72 | TOTTIME | iSeries: Total Time (Database Monitor) |