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":"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
ibm11131999