Memory Resident Database Monitor: DDS

 

The following DDS statements are used to create the memory resident database monitor physical and logical files.

• External table description (QAQQQRYI) - Summary Row for SQL Information
  

• External table description (QAQQTEXT) - Summary Row for SQL Statement
  

• External table description (QAQQ3000) - Arrival sequence
  

• External table description (QAQQ3001) - Using existing index
  

• External table description (QAQQ3002) - Index created
  

• External table description (QAQQ3003) - Query sort
  

• External table description (QAQQ3004) - Temporary table
  

• External table description (QAQQ3007) - Optimizer information
  

• External table description (QAQQ3008) - Subquery processing
  

• External table description (QAQQ3010) - Host variable and ODP implementation
  

• External table description (QAQQ3030) - Materialized query table implementation
  

 

Parent topic:

Performance and query optimization