Use sp_metrics ‘flush’ to flush all aggregated metrics in memory to the system catalog.The aggregated metrics for all statements in memory are zeroed out.
The syntax of removing QP metrics from the system catalog is:
sp_metrics ‘drop’, ‘@gid’ [, ‘@id’]
To remove one entry, use:
sp_metrics ‘drop’, ‘<gid>’, ‘<id>’
You can also use filter to remove QP metrics from the system catalog, based on some metrics conditions. The syntax is:
sp_metrics ‘filter’, ‘@gid’, [, ‘@predicate’]
For example:
sp_metrics ‘filter’,’1’,’lio_max < 100’
deletes all QP metrics in group 1 where lio_max < 100.
