Summary
When we perform a fresh install of the UCMDB 10.30 (or later), by default there are no composite indexes with the CMDB_ID as a key column . If required then we need to create it from JMX console.
Error
When we perform a fresh install of the UCMDB 10.30 (or later), by default we dont see any composite indices with UD tables.
Cause
When we perform a fresh install of the UCMDB 10.30 (or later), by default there are no
composite indexes with the CMDB_ID as a key column on Oracle database (ROOT tables),
and on Microsoft SQL databases (ROOT and CDM tables). If it is required to create the composite indexes
we need to create the same as per the requirement.
This is expected behavior by default it is not created. If required then we need to create it from JMX console.
Fix
To create/delete composite indexes, we can follow the below procedure.
1. On the UCMDB server, launch the Web browser and enter the following address:
https://localhost:8443/jmx-console
2. Locate UCMDB:service=Dal Services->modifyCompositeIndexes
3. Specify the following parameters of the method:
customerId : Specify the Customer ID (leave empty for the default customer)
class name : Specify the class name (allowed values are root and all)
composite indexes: Specify if the method rebuilds the indexes with CMDB_ID as a key column
True : CMDB_ID is a key column
False : CMDB_ID is not a key column
4. Click Invoke.