Database monitor: Formats

 

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

• Database monitor SQL table format
  The following figure shows the format used to create the QSYS/QAQQDBMN performance statistics table, that is shipped with the system.

• Optional database monitor SQL view format
  The following 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 server, and create them, if you choose to do so. These views are optional and are not required for analyzing monitor data.

 

Parent topic:

Performance and query optimization