Diagnostics reports missing indexes in database

  • 7017953
  • 15-Aug-2016
  • 29-Aug-2016

Environment

Novell ZENworks Configuration Management 11.4 Database
Novell ZENworks Configuration Management 11.4 ZDC
Oracle database 

Situation

Zenworks diagnostics center (ZDC) reports following missing indexes in the database

ERROR    Missing object in table 'ZCONTENT'
         Object type: [Index] , Object name: [IDX_ZCONTENT_K1_K4]
         Detail: [Name: IDX_ZCONTENT_K1_K4, Table: ZCONTENT]
ERROR    Missing object in table 'ZCONTENT'
         Object type: [Index] , Object name: [IDX_ZCONTENT_K1_K4]
         Detail: [Name: IDX_ZCONTENT_K1_K4, Table: ZCONTENT]
ERROR    Missing object in table 'ZZENOBJECT'
         Object type: [Index] , Object name: [IDX_ZZENOBJECT_K1_K6]
         Detail: [Name: IDX_ZZENOBJECT_K1_K6, Table: ZZENOBJECT]
ERROR    Missing object in table 'ZZENOBJECT'
         Object type: [Index] , Object name: [IDX_ZZENOBJECT_K1_K6]
         Detail: [Name: IDX_ZZENOBJECT_K1_K6, Table: ZZENOBJECT]



Resolution

These errors can be ignored.

Cause

These indexes are no longer used/needed.