Connection Tab

Use the Connection tab to provide DBMS connection information for all DB Aliases in any Optim™ Directory required to perform delegated tasks.

Note: You can expedite the configuration of the Connection settings for the Server by clicking Merge Current User. This merges the Connection settings for the logged-on user in the Current User registry with settings for the Server machine in the Local Machine registry.
Optim Server Settings dialog, Connection tab

Settings on the Connection tab and the Security tab are related. On the Security tab, you choose Server or Client to specify the source of the User ID and Password information for Optim Directory and DB Alias access.

Note: The Connection String information you enter on the Connection tab is used regardless of whether you select Server or Client on the Security tab. Leave the connection string blank, or select the Always Fail Connection check box to prevent the Server from accessing an Optim Directory and/or DB Alias when performing delegated tasks.

Optim Directory

Select an Optim Directory from the list to display the connection information for the corresponding DB Aliases.

Grid Details

The connection information for the selected Optim Directory includes the following.

Note: The maximum length for a User ID or password varies by DBMS.
DB Alias
DB Aliases in the selected Optim Directory.
User ID
Identifier (1 to 30 characters) that allows the Server to use a particular DB Alias. User IDs are usually assigned and maintained by the database administrator.
Note: If you are using Informix®, you must enter the User ID in upper case for an ANSI database and in lower case for a non-ANSI database.
Password
Enter a password (1 to 30 characters) that allows the Server to access a database using the specified DB Alias.
Verify
Reenter the password for verification.
Connection String
Connection string the Server uses to access a database using the specified DB Alias.
Always Fail Connection
Select this check box to deny access to the corresponding DB Alias. You can use this check box to temporarily deny access to a DB Alias without having to remove the connection string.
Description
Text that describes or explains the purpose of the logon record.

Merge Current User

Click Merge Current User to merge the Connection settings from the Current User registry to the Local Machine registry for the Server component machine. This action does not overlay information previously entered into the Optim Server Settings dialog. This action only merges new settings from the Current User. If the settings are the same, this command is unavailable.



Feedback