Database Monitor (DBMon) enhanced status information

How can I tell what public database monitors are running? I need to end a public database monitor - how can I specify which one? What are the public database monitors filtering on?

See this TechNote for more information on Database Monitor impacts: https://www.ibm.com/support/pages/node/882914

On the IBM i, several colleagues may running database monitors to collect information - tuning an applications, trying to understand a SQLCode, etc.

How can a IBM i Database Engineer (aka Database Administrator) see what is all running?

On the IBM i you can have up to 10 public database monitor collections running.

How can someone tell how many are running? What are they filtering on?

New in IBM i 7.1 there is a new view in QSYS that has this information - QSYS2.DATABASE_MONITOR_INFO.

There are 29 columns of information but here is a sample query with just a few:

Here is output from my IBM i:








In this case, we have information on 4 database monitor collections.
- two are currently collecting information (i.e. 'running') as they are 'ACTIVE'
- one is INACTIVE
- one is CLOSING

See this URL for more information

https://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_75/rzajq/rzajqviewdbmoninfo.htm

So if you wanted/needed to end a public database monitor, the MONITOR_ID can be used.

For example, to end the ACTIVE database monitor that is going to output file KTRISKO/NEWMON and collecting information for all QSQSRVR jobs,

ENDDBMON MONID(7498102027)
 

- Each job can also have one private (just for that job) running - this is not covered in this TechNote and does not count toward the 10 public database monitor collections