The memory resident database monitor uses its own set of tables instead
of using the single table with logical files that the STRDBMON monitor
uses. The memory resident database monitor tables closely match the
suggested logical files of the STRDBMON monitor.
Table 7. External table Description
| QAQQQRYI | Query (SQL) information |
| QAQQTEXT | SQL statement text |
| QAQQ3000 | Table scan |
| QAQQ3001 | Index used |
| QAQQ3002 | Index created |
| QAQQ3003 | Sort |
| QAQQ3004 | Temporary table |
| QAQQ3007 | Optimizer time out/ all indexes considered |
| QAQQ3008 | Subquery |
| QAQQ3010 | Host variable values |
The information relating to the locked tables (QQQ3005) was omitted and the replan information was combined with the QAQQQRYI, and QQQ3010 (ODP and host variable information) is found in both QAQQ3010 and QAQQQRYI tables.