A DB alias is a user-defined object that is associated with a database. When you define a DB alias, you provide parameters that are used to communicate with the associated database. These parameters include the type and version of the database management system (DBMS) and any required connection specifications. DB Aliases are defined when the Optim™ solution is configured. You must be authorized to define a DB alias.
A DB alias name serves as a high-level qualifier that identifies a specific database connection that is needed to run requested functions. For example, in an access definition, you must qualify the name of a table with a DB alias name. The DB alias supplies the parameters that are needed to connect to the database that hosts the table.
Optim solutions support several different database management systems. Since DB alias parameters are specific to a DBMS, the most common terms are used, where possible. Terms unique to database management systems are provided, when necessary. A DB Alias identifies a specific database and serves as a prefix in the fully qualified names of primary keys, database tables, and relationships. DB Aliases are essential elements in managing your databases. Keep in mind the following points:
Also, objects in the Optim Directory cannot have the same name as an alias.
This section describes the use of the DB Alias Editor to maintain DB aliases. Included are specifications for DB aliases, such as general parameters, connection specifications, and server details.