Memory-resident database monitor external table description

 

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 1. External table Description

Monitor 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
QAQQ3030	Materialized Query Tables considered

 

Parent topic:

Monitoring your queries using memory-resident database monitor