Removing non-detectable resource identifiers from the performance monitoring tool database

Every metric value stored in the database is associated with a metric name and resource identifier (single entity). However, the performance monitoring tool does not perform detectability check of stored entities. The identifiers of deleted and renamed resources remain in the database forever. Starting from IBM Spectrum Scale version 5.0.2, the missing identifiers that do not return any value over the retention period of 14 days can be reviewed and deleted by using the mmperfmon command.

In order to avoid deleting temporarily missing identifiers, all entities that are not detectable are retained for the time period of 14 days. If the retention period has expired, and no values have been returned for the undetectable entity for over 14 days, it is listed on expiredKeys list and can be deleted.

Follow the given steps to clean up the performance monitoring tool database:

1. To view expired keys, issue the following command:

   mmperfmon query --list=expiredKeys

   The system displays output similar to this:

   Found expired keys:
   test_nodename|GPFSFilesystem|gpfsgui-cluster-2.novalocal|fs1
   test_nodename|GPFSFilesystem|gpfsgui-cluster-2.novalocal|fs2
   test_nodename|GPFSFilesystemAPI|gpfsgui-cluster-2.novalocal|fs2
   test_nodename|GPFSFilesystemAPI|gpfsgui-cluster-2.novalocal|fs1
   test_nodename|GPFSFilesystem|gpfsgui-cluster-2.novalocal|gpfs0
   test_nodename|DiskFree|/mnt/gpfs0
   test_nodename|Netstat
   test_nodename|GPFSFilesystem|gpfsgui-cluster-2.novalocal|objfs
   test_nodename|GPFSVFS
   test_nodename|GPFSNode
   test_nodename|GPFSFilesystemAPI|gpfsgui-cluster-2.novalocal|gpfs0
   test_nodename|GPFSFilesystemAPI|gpfsgui-cluster-2.novalocal|objfs
   test_nodename|DiskFree|/gpfs/fs2
   test_nodename|DiskFree|/gpfs/fs1
   test_nodename|GPFSRPCS
   test_nodename|CPU
   test_nodename|GPFSNodeAPI
   test_nodename|Load
   test_nodename|DiskFree|/mnt/objfs
   test_nodename|Memory

2. To delete expired key, issue the following command:

   mmperfmon delete --key ‘test_nodename|DiskFree|/mnt/gpfs0‘

   The system displays output similar to this:

   Check expired keys completed. Successfully 3 keys deleted.

The following table shows you resources types and responsible sensors, included in the detectability validation procedure.