Sample SQL queries

As with the STRDBMON monitor, it is up to the user to extract the information from the tables in which all of the monitored data is stored. This can be done through any query interface that the user chooses.

If you are using iSeries™ Navigator with the support for the SQL Monitor, you have the ability to analyze the results direct through the graphical user interface. There are a number of shipped queries that can be used or modified to extract the information from any of the tables. For a list of these queries, go to Common queries on analysis of DB Performance Monitor data the DB2® UDB for iSeries websiteLink outside of Information Center..