Whenever a new Sybase Server is created on the client, you will add the Sybase Server to the CommCell using the following steps:
-
From the CommCell Browser, navigate to Client Computers | <Client>.
-
Right-click Sybase, point to All Tasks, and then click New Sybase Server.
The Properties of Sybase Server dialog box appears.
-
In the General tab, enter the following details:
-
In the Server Name box, type the Sybase data server name.
-
In the Sybase ASE box, type the directory name where you installed Adaptive Server Enterprise (ASE) environment variable.
-
In the Sybase OCS box, type the Sybase Open Client Server (OCS )environment variable.
You can view this variable in sybase.env file residing in home directory.
-
In the Sybase Home box, type the path to the directory where the Sybase application files reside. Alternatively, click Browse to select the location.
-
In the Configuration File box, type the path to the configuration file. Alternatively, click Browse to select the location.
-
In the Shared Memory Directory box, type the location of the directory where you specify the shared memory file name. When you start an Adaptive Server, it creates a shared memory file that resides in the home directory. for example: /opt/sybase/ASE-15_0. Alternatively, click Browse to select the location.
-
Specify a value in the Block Size box.
-
Select the Enable Auto Discovery checkbox to enable auto discovery of instance.
-
In the Default Database Storage Policy box, select the storage policy.
-
In the Description box, enter the description about the Sybase server.
-
-
You must enter the following details as per credential manager:
-
If you select Unix server, do the following:
-
On the Accounts tab, enter the following details:
-
In the Sybase OS user name box, enter the OS user name.
-
Click SA User Credential, and then click Add new.
The Add Credential dialog box appears.
-
From the Account type list, select a database account.
-
From the Database type list, select Sybase.
-
In the Credential name box, enter a unique name to access the credential.
-
In the User Name box, enter a database user.
-
In the Password box, enter the password for the database user.
-
In the Description box, enter the description of the Sybase instance.
-
-
-
If you select Windows server, do the following:
-
On the Accounts tab, enter the following details:
-
In the Sybase OS user credential box, enter the OS user name.
-
Click SA User Credential, and then click Add new.
The Add Credential dialog box appears.
-
From the Account type list, select a database account.
-
From the Credential Vault list, select a credential vault to store, share, and update account credentials with shared resources in your environment.
-
In the Credential name box, enter a unique name to access the credential.
-
In the User Name box, enter a database user.
-
In the Password box, the password for the database user.
-
In the Description box, enter the description of the Sybase instance.
-
Click SA User Credential, and then click Add new.
The Add Credential dialog box appears.
-
From the Account type list, select a database account.
-
From the Database type list, select Sybase.
-
In the Credential name box, enter a unique name to access the credential.
-
In the User Name box, enter a database user.
-
In the Password box, the password for the database user.
-
In the Description box, enter the description of the Sybase instance.
-
-
-
-
Click OK.