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 > Database > Introducing the Database Environment > Introduction to Preparing the Database Environment > Databases in Use Overview

Databases in Use Overview

To work with Universal CMDB, you must set up the CMDB database. The CMDB database is used for storage of configuration information that is gathered from the various Universal CMDB and third-party applications and tools. This information is used when building Universal CMDB views.

You can set up the Universal CMDB databases on a Microsoft SQL Server, on an Oracle Server, or on a PostgreSQL Server, depending on the type of database server used in your organization.

If you are working with a Microsoft SQL Server database, refer to Deploying the Microsoft SQL Server Database.

If you are working with an Oracle Server database, refer to Deploying the Oracle Server Database.

If you are working with a PostgreSQL Server database, refer to Deploying the PostgreSQL Server Database.

Note

It is strongly recommended to host database server (Oracle, Microsoft SQL, or PostgreSQL) on a physical machine, and it should be an independent server without other applications (including the UCMDB server) running on it.

Also, if the database server machine is a virtual machine, the resource MUST be dedicated for the database server.
Apart from the embedded PostgreSQL database server, installing UCMDB server and database server (Oracle, Microsoft SQL, or PostgreSQL) together on the same machine is not supported.

Database servers must be set to the same time zone, daylight savings settings and time as the Universal CMDB servers.
For details on working in a non-English language Universal CMDB environment, see the section on non-English locales in the interactive Universal CMDB Deployment Guide.
The UCMDB server(s) should be located in the same LAN with the database servers (without a proxy and firewalls between them). Otherwise, your system's performance may be impacted.

Send Help Center feedback