Technical Blog Post
Abstract
Useful tip to monitor usage of the the custom indexes in DB2 Maximo environment.
Body
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
select tbshema,tbname,indschema,indname,lastused
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
UID
ibm11131993