Connection Tab

The Connection tab displays the name of the database associated with the DB Alias and a connection string that enables Optim to access it.

Example of the Connection tab on the DB Alias Editor

Connection String

The value used by Optim to connect to the database associated with the DB Alias. This entry varies according to the database management system:

DBMS Connection String Example
DB2® Database Name or Alias
Informix® Server Name
Oracle Connection String or Host String
SQL Server Data Source Name (DSN) or Server
Sybase ASE Server Name
Teradata (see Note) TDP ID for client connection to Server system. This prompt is labeled Server for Teradata.
Note: You can create a DB Alias for a Teradata database, but you cannot create the Optim™ Directory in a Teradata database. Therefore, you must create the Optim Directory in another supported database, such as Oracle or DB2 with a Federation Server instance, and the DB Alias in that database must point to the Teradata database.

DB Name

The DB Name (1 to 64 characters) identifies the database associated with the DB Alias. This parameter applies to database management systems that support multiple database instances within a single database server, such as Sybase ASE and SQL Server.