The Server tab displays the DBMS qualifier, network server name, and DBMS server signature that enables Optim to access the database.
The qualifier for the package, plan, or procedure Optim uses to access the database identified by this DB Alias. Each database management system uses a different term (qualifier) to identify this procedure:
DBMS | Qualifier |
---|---|
DB2® | Collection Name |
Oracle | Package Qualifier |
Sybase | Procedure Qualifier |
SQL Server | Procedure Qualifier |
Informix® | Procedure Qualifier |
The network server name identifies the server where the database identified by the Connection String resides (see General Tab). The name is assigned to a network server and must be used for all DB Aliases associated with databases residing on that network server. You can specify a Network Server Name only for database management systems that allow multiple databases on a single server (for example, Sybase ASE).