Server Tab

The Server tab displays the DBMS qualifier, network server name, and DBMS server signature that enables Optim to access the database.

db alias editor server tab, explained below

DBMS Qualifier

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

Network Server Name

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).

DBMS Server Signature

When you install a DBMS on a specific server, the installation process records a server signature to identify the DBMS and indicate the date and time the DBMS was installed.