Use of the system table SYSINFO.CACHESTATISTICS
You can use the system table CACHESTATISTICS to determine the following database information, among other things:
Displaying all caches whose hit rate is below 90%
SELECT name, accesscount, hitrate
FROM SYSINFO.CACHESTATISTICS
WHERE hitrate < '90'
Displaying the caches that show more failed accesses than successful ones
SELECT *
FROM SYSINFO.CACHESTATISTICS
WHERE successfulaccesscount < unsuccessfulaccesscount