Chapter 9. Tuning Database Link Performance
Database link performance can be improved through changes to the Directory Server's connection and thread management.
9.1. Managing Connections to the Remote Server
Each database link maintains a pool of connections to a remote server. This section describes how to optimize them.
9.1.1. Managing Connections to the Remote Server Using the Command Line
This section describes how you update the settings for a specific database, as well as the default settings.
9.1.1.1. Updating the Database Link Connection Management Settings for a Specific Database
To update the database link connection management settings for a specific database:
- Use the following command to update a setting for a database link:
# dsconf -D "cn=Directory Manager" ldap://server.example.com chaining link-set parameter=value link_name
For a list of parameters you can set, enter:# dsconf -D "cn=Directory Manager" ldap://server.example.com chaining link-set --help
- Restart the Directory Server instance:
# dsctl instance_name restart
9.1.1.2. Updating the Default Database Link Connection Management Settings
To update the default database link connection management settings, use the following command:
# dsconf -D "cn=Directory Manager" ldap://server.example.com chaining config-set-def parameter=value
For a list of parameters you can set, enter:
# dsconf -D "cn=Directory Manager" ldap://server.example.com chaining config-set-def --help
9.1.2. Managing Connections to the Remote Server Using the Web Console
This section describes how you update the settings for a specific database, as well as the default settings.
9.1.2.1. Updating the Database Link Connection Management Settings for a Specific Database
To update the database link connection management settings for a specific database:
- Open the Directory Server user interface in the web console. For details, see Logging Into Directory Server Using the Web Console section in the Red Hat Directory Server Administration Guide.
- Select the instance.
- On the tab, select the database link configuration you want to update.
- Click Show Advanced Settings.
- Update the fields in the advanced settings area:
To display a tooltip and the corresponding attribute name in thecn=configentry for a parameter, hover the mouse cursor over the setting. For further details, see the parameter's description in the Red Hat Directory Server Configuration, Command, and File Reference.. - Click .
- Click the button, and select Restart Instance.
9.1.2.2. Updating the Default Database Link Connection Management Settings
To update the default database link connection management settings:
- Open the Directory Server user interface in the web console. For details, see Logging Into Directory Server Using the Web Console section in the Red Hat Directory Server Administration Guide.
- Select the instance.
- On the tab, select Chaining Configuration.
- Update the fields in the Default Database Link Creation Settings area:
To display a tooltip and the corresponding attribute name in thecn=configentry for a parameter, hover the mouse cursor over the setting. For further details, see the parameter's description in the Red Hat Directory Server Configuration, Command, and File Reference.. - Click .
- Click the button, and select Restart Instance.
