UCMDB Server Connection Retries to the Database

Configure UCMDB Server Connection Retries to the Database

By default UCMDB server tries to connect to the database for 10 times when there is a network problem.

If you need to increase the number of the retries, do the following:

  1. Open the <UCMDB_Server_Home>\bin\wapper.conf file using a text editor.
  2. Locate the following entry in the wapper.conf file and increase the number of startup retries to a desired value:

    # Number of startup retries before stopping the service
    wrapper.max_failed_invocations=10
  3. Save the file.
  4. Restart the UCMDB server for the change to take affect.

    In case of HA, restart the UCMDB server cluster.

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:

  1. Open the <UCMDB_Server>\conf\connection_pool.conf file using a text editor.
  2. Locate the useValidationQuery setting and set its value to 1, as follows:

    useValidationQuery=1 

    Any other value will use the default mechanism.

  3. Save the connection_pool.conf file.
  4. Restart the UCMDB server.