Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Configuration Management System (CMS)2018.05

Use > JMX Reference > Modeling Methods > How to Rebuild Indexes on Microsoft SQL Database

How to Rebuild Indexes on Microsoft SQL Databases

UCMDB is an online transaction processing (OLTP) application. It performs many insert, update, and delete operations each day, its indexes might become fragmented. The index fragmentation could be even higher if discovery jobs that run also modify the data.

To help rebuild fragmented indexes on Microsoft SQL database, the RebuildIndexes job is introduced. It uses a stored procedure to defragment the indexes. The RebuildIndexes job is deactivated by default. You can start the job manually when necessary.

How to manually start rebuilding fragmented indexes

You can start rebuilding fragmented indexes manually by using either of the following:

Start the RebuildIndexes job from UCMDB UI
1. On UCMDB UI, go to Administration > Scheduler > Job Scheduler.
2. Select the RebuildIndexes job, and click Edit .
3. Modify the job scheduler information in the Schedule section of the Job Definition dialog.
  
  It is recommended to run the job on a daily basis.
  
  For more information about the scheduler options, see Job Definition Dialog Box.
4. Click OK.
Invoke the rebuildIndexes JMX method from the JMX console
1. Launch the Web browser and navigate to: https://<Server name>:8443/jmx-console, where <Server name> is the name of the machine on which Universal CMDB is installed.
2. Under UCMDB, click UCMDB:service=Dal Services to open the JMX MBean View.
3. Invoke the rebuildIndexes JMX method with a customerID parameter value of 1.

Note

During the rebuilding of the indexes, the UCMDB database log file size may increase. Make sure that the UCMDB database log file has enough disk space.
Before you invoke the rebuildIndexes JMX method, make sure that the discovery, enrichment, or other jobs that modify the data are not running.
The RebuildIndexes job is visible only for Customer 1 (default customer) in UI, even if the Server has multiple customers.
The rebuildIndexes JMX method recreates the indexes for all customers even if the customerID is set to 1, in case the server has multiple customers or has the authorized state.

Send Help Center feedback