IBM Support

Identifying Invalid indexes in Maximo DB2 database.

Technical Blog Post


Abstract

Identifying Invalid indexes in Maximo DB2 database.

Body

The issue is that System Catalog doesn't report the Invalid Indexes.

In order to identify Invalid Index we need to use a SYSPROC.ADMIN_GET_INDEX_INFO routine. To fix an identified indexes please run REBUILD or REORG utilities.  We are interested in value in

INDEX_REQUIRES_REBUILD column , returned by the SYSPROC.ADMIN_GET_INDEX_INFO routine.

Please run the following command:

db2  select    tabname, indname, iid, index_requires_rebuild FROM TABLE(sysproc.admin_get_index_info('I','MAXIMO',''))  where index_requires_rebuild ='Y';

Please review the output and run REBUILD index command using following sample

REBUILD INDEX <SCHEMA.INDEXNAME>;

 

[{"Business Unit":{"code":"BU005","label":"IoT"}, "Product":{"code":"SSLKT6","label":"Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":""}]

UID

ibm11131999