Configuration database

Edit online

You can view and update the current configuration database settings with the Configuration Database tab on the Database Configuration management page.

Note: If Oracle is set as the external configuration database and either the local management interface or runtime server trace specification includes Oracle trace points (for example, oracle.*) the underlying Oracle JDBC JAR file is changed to a debugging JAR file. The debugging JAR file might adversely affect performance. Enable Oracle tracing only for debugging purposes and disable it after the debugging is complete.
Warning: Enabling trace for Oracle components “oracle.*” might result in the Oracle database administrator password being logged in clear text.

The configuration database stores configuration data, including policy information.

Local to the cluster
Specifies the use of the internal configuration database.
Remote to the cluster
Specifies the use of an external configuration database. Specify the following information for the external configuration database:
Type
The database type, which is one of DB2, Oracle, PostgreSQL, or Microsoft SQL Server.
Address
The IP address or hostname of the external database server.
Port
The port on which the external database server is listening.
Username
The name of the database administrator.
Password
The password for the database administrator.
DB2
Secure
Select this checkbox to create a secure connection with the DB2® server.
Note: Before a secure connection can be established, you must first import the certificate for the environment to use for communication with the DB2 server. The certificate must be imported into the lmi_trust_store and rt_profile_keys key files.
Database name
The name of the database instance on the external DB2 server.
Enable HADR and ACR
Select this checkbox to enable High Availability Disaster Recovery and Automatic Client Reroute.
Alternate Address
The IP address or hostname of the failover database server in the HADR configuration.
Alternate Port
The port on which the failover database server in the HADR configuration is listening.
Oracle
Secure
Select this checkbox to create a secure connection with the Oracle server.
Note: Before a secure connection can be established, you must first import the certificate for the environment to use for communication with the Oracle server. The certificate must be imported into the lmi_trust_store and rt_profile_keys key files.
Certificate Store
The name of the store that contains the keys that are used to communicate with the Oracle server.
Service name
The name of the service instance on the external Oracle server.
PostgreSQL
Note: High availability, with an external PostgreSQL server, is achieved by using an external load balancer.
Secure
Select this checkbox to create a secure connection with the PostgreSQL server.
Note: Before a secure connection can be established, you must first import the certificate for the environment to use for communication with the PostgreSQL server. The certificate must be imported into the lmi_trust_store and rt_profile_keys key files.
Database name
The name of the database instance on the external PostgreSQL server.
Enable failover support
Select this checkbox to enable PostgreSQL failover support. After this box is checked, the failover servers management section is enabled.
Failover servers
Manage the PostgreSQL failover servers in this section.
Add
  1. Click the Add button to add a failover server. A new dialog opens.
  2. Specify the new failover server address and port.
  3. Click Submit to add the server.
Delete
  1. Select the failover server in the grid.
  2. Click the Delete button to remove the server from the list.
Move Up and Move Down
  1. Select the failover server in the grid.
  2. Click the Move Up or Move Down button to change the order of the server in the list.
MSSQL
Database name
The name of the database instance on the external MSSQL® server.
Instance name
The database instance name to connect to. When it isn't specified, a connection is made to the default instance.
Failover partner
The name of the failover server used in a database mirroring configuration. This property is used for an initial connection failure to the principal server. After you make the initial connection, this property is ignored.