Configuration database

Edit online

You can view and update the current configuration database settings with the Configuration Database tab on the Cluster 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. This might have adverse effects on performance and as such Oracle tracing should only be enabled for debugging purposes and disabled once 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. This data is shared with all appliances in the cluster.

Local to the cluster

Specifies the use of the internal configuration database.

Database export: Exports the current configuration data from the internal database so that it can be imported into an external database of the chosen type. This option is useful if you want to migrate the appliance's internal configuration database to an external database. Supported external database types are DB2, Oracle, PostgreSQL, and Microsoft® SQL Server. The exported data are compressed into a zip file. A readme file is included in the zip file to provide instructions on how to import the data into the external database.
Note: For DB2, Oracle, and Microsoft® SQL Server, the configuration database schema (table and index definitions), which is available from the File Downloads area of the appliance, must be applied to the database that will house the configuration data before the data can be imported. For PostgreSQL, this step is not required as the zip file also contains the database schema.

Remote to the cluster

Specifies the use of an external configuration database. Specify the following information for the external configuration database:

Use external database for internal file sharing

Enable this option to allow the configurations to be modified on non-primary nodes of the cluster.

Note: When you enable this option, the appliance will be rebooted when the change is committed. During the reboot, the files will be migrated between the local file system and 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 check box 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 appliance to use for communication with the DB2 server. The certificate must be imported into the lmi_trust_store and rt_profile_keys key files. Use the SSL Certificates page to import the appropriate certificate.
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 check box 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 appliance to use for communication with the Oracle server. The certificate must be imported into the lmi_trust_store and rt_profile_keys key files. Use the SSL Certificates page to import the appropriate certificate.
Service name: The name of the service instance on the external Oracle server.
Driver type: Specifies the type of Oracle JDBC driver that is used to connect to the Oracle server. Available options are Thin and OCI.

PostgreSQL

Note: High availability, with an external PostgreSQL server, is achieved through the use of an external load balancer.

Secure

Select this check box 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 appliance to use for communication with the PostgreSQL server. The certificate must be imported into the lmi_trust_store and rt_profile_keys key files. Use the SSL Certificates page to import the appropriate certificate.

Database name

The name of the database instance on the external PostgreSQL server.

Enable failover support

Select this check box to enable PostgreSQL failover support. Once this box is checked, the failover servers management section is enabled.

Failover servers

Manage the PostgreSQL failover servers in this section.

Add

Click the Add button to add a new failover server. A new dialog opens.
Specify the new failover server address and port.
Click Submit to add the server.

Delete

Select the failover server in the grid.
Click the Delete button to remove the server from the list.

Move Up and Move Down

Select the failover server in the grid.
Click the Move Up or Move Down button to change the order of the server in the list.

Microsoft SQL Server

Instance name: Specifies the name of the SQL Server instance to connect to. If this option is not provided, the default SQL Server instance is used.
Trust server certificate: Select this check box if the server TLS/SSL certificate is not validated.
Windows authentication: Select this check box to enable Windows (Kerberos) authentication for connections to the SQL Server.
Keytab: If windows authentication is selected, then the keytab file is used instead of a password for authentication. Keytab files are uploaded using the Kerberos configuration.