Server tab

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

Example of the DB Alias Editor Server tab, described as follows.

DBMS Qualifier

The qualifier for the package, plan, or procedure Optim uses to access the database that is 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 is located (see the General tab). The name is assigned to a network server and must be used for all DB Aliases that are associated with databases on that network server. You can specify a Network Server Name only for database management systems that allow multiple databases on a single server, such as 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. The content of the signature varies by DBMS. In some cases, the date and time the DBMS was installed is included in the signature. In other cases, the signature includes information that is unique to the DBMS. For PostgreSQL, for example, the server signature is generated using a combination of the database object identifier, the DBA object identifier, and the database encoding.



Feedback