Database monitor formats

This section contains the formats used to create the database monitor SQL tables and views.

Database monitor SQL table format
Displays the format used to create the QSYS/QAQQDBMN performance statistics table, that is shipped with the system.
Optional database monitor SQL view format
These examples show the different optional SQL view format that you can create with the SQL shown. The column descriptions are explained in the tables following each example. These views are not shipped with the system, and you must create them, if you choose to do so. These views are optional and are not required for analyzing monitor data.

Parent topic: Database performance and query optimization