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)`

Universal CMDB11.0

Install > Support Matrix > Requirements > Databases

Databases

One of the following supported databases is required to run Universal CMDB 11.0:

Oracle Server
Microsoft SQL Server
PostgreSQL Server

The table below describes hardware requirements for database server:

Deployment	CPU	Memory	Linux Swap	Windows Virtual Memory	Free Disk Space
Enterprise	24 Cores	64 GB	64 GB	96 GB	300 GB

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.

The hardware requirements could be the same as those for UCMDB server, but the DB SPACE depends on the data scale. For example, for a data scale of 30 millions CIs, we recommended 500 GB or more space for data files and 200 GB or more space for log files.

Oracle System Requirements

The following table lists the Oracle Servers supported for working with Universal CMDB. A supported option means that quality assurance personnel have successfully performed basic tests on that option.

Database Version	Edition	System Type	Supported Products
Oracle 12c * (With or without the Oracle Advanced Security Option enabled)	Standard Enterprise	64-bit	UCMDB UCMDB Integration Service Note: Oracle 12c must be installed without container database (CDB). UCMDB does not support Oracle 12c with CDB.
	RAC Enterprise **		UCMDB
Oracle 11.2 (11g R2) * (With or without the Oracle Advanced Security Option enabled)	Standard Enterprise	64-bit	UCMDB Configuration Manager UCMDB Integration Service
	RAC Enterprise **	64-bit	UCMDB Configuration Manager

Note

It is strongly recommended to apply the latest critical Oracle patches per your operating system. For details, consult the Oracle documentation.
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.
For information about how to configure UCMDB to support the Oracle Advanced Security Option (ASO), see the Universal CMDB Hardening Guide.
* Consult the Oracle documentation for supported platforms.
** The connection from UCMDB to an Oracle RAC environment is supported only by using the Oracle native drivers. For detailed instructions, see Universal CMDB Database Guide.

Examples of Tested Deployments

The following table details the deployment environments that have been rigorously tested by quality assurance personnel.

Database Release Version	Edition	System Type	Operating System
Oracle 12.1.0.2.0	Enterprise	64-bit	Windows Server 2012 Standard Edition (64-bit)
Oracle 12.1.0.2.0	Enterprise	64-bit	Oracle Enterprise Linux with Unbreakable Enterprise Kernel v6.x
Oracle 11.2.0.1.0	Enterprise	64-bit	Windows Server 2012 Datacenter Edition (64-bit)
Oracle 11.2.0.1.0	Enterprise	64-bit	Red Hat Enterprise Linux Server 6.4
Oracle 11.2.0.1.0	Enterprise	64-bit	Windows Server 2016

Microsoft SQL System Requirements

The following table lists the Microsoft SQL Servers supported for working with Universal CMDB. A supported option means that quality assurance personnel have successfully performed basic tests on that option.

Database Version	Edition	System Type	Service Packs	Supported Products
Microsoft SQL Server 2017	Standard Enterprise	64-bit		UCMDB UCMDB Integration Service
Microsoft SQL Server 2016	Standard Enterprise	64-bit	SP1 (incl. high availability mode (AlwaysOn))	UCMDB UCMDB Integration Service
Microsoft SQL Server 2014	Standard Enterprise	64-bit	SP2 (incl. high availability mode (AlwaysOn))	UCMDB UCMDB Integration Service
Microsoft SQL Server 2012	Standard Enterprise	64-bit	SP3	UCMDB UCMDB Integration Service
Microsoft SQL Server 2012 Failover Cluster	Enterprise	64-bit	SP1	UCMDB UCMDB Integration Service

Note

Only supported service packs should be installed, with latest patches.
Consult the Microsoft documentation for supported platforms.
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.

Examples of Tested Deployments

The following table details the deployment environments that have been rigorously tested by quality assurance personnel.

Database Release Version	Edition	System Type	Service Packs	Operating System
Microsoft SQL Server 2017	Enterprise	64-bit		Oracle Enterprise Linux with Unbreakable Enterprise Kernel 7.X
Microsoft SQL Server 2017	Enterprise	64-bit		Red Hat Enterprise Linux Server 7.4
Microsoft SQL Server 2016	Enterprise	64-bit		Windows Server 2012 R2 Datacenter Edition (64-bit)
Microsoft SQL Server 2016	Enterprise	64-bit	SP1	Oracle Enterprise Linux with Unbreakable Enterprise Kernel 7.X
Microsoft SQL Server 2012 Cluster	Enterprise	64-bit	SP1	Windows Server 2012 Datacenter Edition (64-bit)
Microsoft SQL Server 2012 Cluster	Enterprise	64-bit	SP1	Windows Server 2012 Standard Edition (64-bit)

PostgreSQL System Requirements

The following table lists the PostgreSQL Servers supported for working with Universal CMDB. A supported option means that quality assurance personnel have successfully performed basic tests on that option.

Database Version	Edition	System Type	Supported Products
PostgreSQL 9.6	Enterprise	64-bit	UCMDB UCMDB Integration Service
PostgreSQL 9.5	Enterprise	64-bit	UCMDB UCMDB Integration Service
PostgreSQL 9.4.8	Embedded *	64-bit	UCMDB UCMDB Integration Service
PostgreSQL 9.4	Enterprise	64-bit	UCMDB UCMDB Integration Service
PostgreSQL 9.3	Enterprise	64-bit	UCMDB UCMDB Integration Service
PostgreSQL Server 9.22	Enterprise	64-bit	UCMDB

Note

Only supported service packs should be installed, with latest patches
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.
Embedded PostgreSQL is not supported on Enterprise deployments of UCMDB.
* Embedded PostgreSQL is supported on Linux systems after the local PostgreSQL is uninstalled. Therefore, to be able to use embedded PostgreSQL, make sure you uninstall the local PostgreSQL that comes with the Linux installation.

Examples of Tested Deployments

The following table details the deployment environments that have been rigorously tested by quality assurance personnel.

Database Release Version	Deployment	System Type	Operating System
PostgreSQL Server 9.4.8	Embedded	64-bit	Windows Server 2016
PostgreSQL Server 9.4	Enterprise	64-bit	Windows Server 2012 Standard Edition
PostgreSQL Server 9.22	External	64-bit	Windows Server 2012 Standard Edition
PostgreSQL Server 9.22	Standalone	64-bit	Red Hat Enterprise Linux Server 6.4
PostgreSQL Server 9.22	Standalone	64-bit	Red Hat Enterprise Linux Server 6.5

Send Help Center feedback