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

Use > Database > Introducing the Database Environment > Introduction to Preparing the Database Environment > UCMDB Server Connection Retries to the Database

UCMDB Server Connection Retries to the Database

Configure UCMDB Server Connection Pool Connections Validations

There are several best practices used regarding database connections. The most popular approach uses a connection pool to interact with the database as opposed to creating and closing the connection every time a request to UCMDB database is needed. Making a connection every time is very costly on the way UCDMB operates. Because of this reason UCMDB uses a connection pool, Apache DBCP Component, which is a third party library used. Once the pool is operating, every time a UCMDB component needs a connection to database it takes one from the pool that is already established. After using the connection it is returned to the pool.

One role of the connection pool is to ensure that the connections are opened and can be used at any time. There are several ways the Apache DBCP can achieve this. One is using validation queries which means a select statement is run against the database server. For example, “select 1 from dual" is the Oracle specific validation query.

The latest database drivers provides the feature of testing the database connection without running a validation query. UCMDB uses this mechanism by default.

In case the old mechanism is needed to be used, you can configure it as follows:

Open the <UCMDB_Server>\conf\connection_pool.conf file using a text editor.
Locate the useValidationQuery setting and set its value to 1, as follows:
```
useValidationQuery=1 
```
Any other value will use the default mechanism.
Save the connection_pool.conf file.
Restart the UCMDB server.

Send Help Center feedback