Technical Blog Post
Useful tip to monitor usage of the the custom indexes in DB2 Maximo environment.
It is important to monitor the usage of the objects in customized maximo environments. Identifying unused indexes will save the space and
improve performance. IBM DB2 offers catalog information that helps to gather information ,review it and ping point un needed objects.
Please esecute the fallowing SQL
from syscat.indexes where
tbschema='MAXIMO' and inshema='MAXIMO'
order by lastused desc;
Please monitor and environment for some time to identify objects that may be deleted.