9.6.4.1.2 Customizing Fine-Grained Metric Collection

By default, a set of key performance metrics is automatically enabled for fine-grained collection. But, you can customize fine-grained metric collection by enabling or disabling specific metrics.

• To enable a metric for fine-grained collection, use the ALTER METRICDEFINITION command and specify finegrained=enabled. For example:

  DBMCLI> ALTER METRICDEFINITION N_NIC_KB_TRANS_SEC finegrained=enabled

  DBMCLI> ALTER METRICDEFINITION N_MB_SENT,N_MB_RECEIVED finegrained=enabled

  DBMCLI> ALTER METRICDEFINITION finegrained=enabled WHERE name LIKE 'N_NIC.*'

• To disable a metric for fine-grained collection, use the ALTER METRICDEFINITION command and specify finegrained=disabled. For example:

  DBMCLI> ALTER METRICDEFINITION N_MB_SENT finegrained=disabled

• At any time, to view the metrics enabled for fine-grained collection, use the following command:

  DBMCLI> LIST METRICDEFINITION WHERE finegrained=enabled

• At any time, to view all of the metric definition details, including each metric description and whether the metric is enabled for fine-grained collection, use the following command:

  DBMCLI> LIST METRICDEFINITION DETAIL