Data Element list used by SAP ABAP Table SQ1000_DB4 (iSeries: SQL Information (Database Monitor))
SAP ABAP Table
SQ1000_DB4 (iSeries: SQL Information (Database Monitor)) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | CHAR14 | Text field length 14 | ||
| 2 | QQ1000 | iSeries: Reserved Field (Database Monitor) | ||
| 3 | QQAPR | iSeries: Reason Code for Access Plan Rebuild | ||
| 4 | QQAPRT | iSeries: Timestamp of Access Plan Rebuild (Database Monitor) | ||
| 5 | QQARSS | iSeries: Average Result Set Size (Database Monitor) | ||
| 6 | QQAVGT | iSeries: Average Time (Database Monitor) | ||
| 7 | QQC11 | iSeries: Reserved Field (Database Monitor) | ||
| 8 | QQC12 | iSeries: Reserved Field (Database Monitor) | ||
| 9 | QQC21 | iSeries: Reserved Field (Database Monitor) | ||
| 10 | QQC22 | iSeries: Reserved Field (Database Monitor) | ||
| 11 | QQC301 | iSeries: Reserved Field (Database Monitor) | ||
| 12 | QQC302 | iSeries: Reserved Field (Database Monitor) | ||
| 13 | QQCAPR | iSeries: No of Access Plan Rebuilds (Database Monitor) | ||
| 14 | QQCIA | iSeries: Index Advice (Database Monitor) | ||
| 15 | QQCIC | iSeries: Number of Index Creates (Database Monitor) | ||
| 16 | QQCIU | iSeries: Index Usage (Database Monitor) | ||
| 17 | QQCLST | iSeries: CLOSE time (Database Monitor) | ||
| 18 | QQCNAM | iSeries: Cursor Name (Database Monitor) | ||
| 19 | QQCNT | iSeries: No. of Executions of a Statement (Database Monitor) | ||
| 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 | QQDACV | iSeries: Data Conversion (Database Monitor) | ||
| 24 | QQFETT | iSeries: FETCH time (Database Monitor) | ||
| 25 | QQFULO | iSeries: Number of FULL OPENs (Database Monitor) | ||
| 26 | QQHVI | iSeries: Host Variable Implementation (Database Monitor) | ||
| 27 | QQI1 | iSeries: Reserved Field (Database Monitor) | ||
| 28 | QQI2 | iSeries: Reserved Field (Database Monitor) | ||
| 29 | QQJNUM | iSeries: Job Number (Database Monitor) | ||
| 30 | QQJOB | iSeries: Job Name (Database Monitor) | ||
| 31 | QQKEY | iSeries: Key Field (Database Monitor) | ||
| 32 | QQLTU | iSeries: Time Last Used (Database Monitor) | ||
| 33 | QQMAXT | iSeries: Maximum Time (Database Monitor) | ||
| 34 | QQMETU | iSeries: Timest. of Most Expensive Stmt. (Database Monitor) | ||
| 35 | QQMINT | iSeries: Minimum Time (Database Monitor) | ||
| 36 | QQODPI | iSeries: ODP Implementation (Database Monitor) | ||
| 37 | QQOPNT | iSeries: Open time (Database Monitor) | ||
| 38 | QQOTHT | iSeries: Any other time (Database Monitor) | ||
| 39 | QQPLIB | iSeries: Package/Program Library (Database Monitor) | ||
| 40 | QQPNAM | iSeries: Package/Program Name (Database Monitor) | ||
| 41 | QQPSUO | iSeries: Number of PSEUDO OPENs (Database Monitor) | ||
| 42 | QQRROW | iSeries: Result Rows (Database Monitor) | ||
| 43 | QQSNAM | iSeries: Statement Name (Database Monitor) | ||
| 44 | QQSTF | iSeries: Statement Function (Database Monitor) | ||
| 45 | QQSTOP | iSeries: Statement Operation (Database Monitor) | ||
| 46 | QQTIME | iSeries: Record Creation Timestamp (Database Monitor) | ||
| 47 | QQUSER | iSeries: Job User (Database Monitor) | ||
| 48 | QTOTR | iSeries: Total Rows in Table (Database Monitor) | ||
| 49 | QUDEF | iSeries: User-defined Field (Database Monitor) | ||
| 50 | SYSYSID | Name of SAP System | ||
| 51 | TOTTIME | iSeries: Total Time (Database Monitor) |