IBM Support

Useful tip to monitor usage of the the custom indexes in DB2 Maximo environment.

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":"BU005","label":"IoT"}, "Product":{"code":"SSLKT6","label":"Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":""}]

UID

ibm11131993