Filters for JSON-format outputs

When using OMEGAMON Data Provider (ODP), you can optionally filter your Db2 Query Monitor data to send to the JSON-format outputs of OMEGAMON Data Connect.

For more information about these filters for JSON-format outputs, see Filters for JSON-format outputs (IBM Z OMEGAMON Integration Monitor 5.6.0 documentation). Also, consider the following guidance specific to Db2 Query Monitor for certain values when creating these filters:

<product_code>

Specify cqm, the product code for Db2 Query Monitor

fields

Specify field names. You can find these field names in the data dictionary in USS.

These field names are the same as the columns in the performance history database, except the field names are lower case. For example, the performance history database table CQM_SUMM_METRICS has column DB2_CPU. The ODP equivalent is field db2_cpu in summmetr. For a list of columns in the performance history database, see Performance history database tables and column descriptions.

filter:
   enabled: true
   products:
   cqm:
     tables:
       summmetr:
         condition:
           expression: db2_subsystem.equals('DSN1')