Perform the following steps on the primary server:
- On the Edit menu, select Server, then Create Resource Hierarchy.
The Create Resource Wizard dialog will appear.
- Select Sybase ASE Database from the drop-down list and click Next.
- You will be prompted for the following information. When the Back button is active in any of the dialog boxes, you can go back to the previous dialog box. This is helpful should you encounter any error requiring you to correct the previously entered information. You may click Cancel at any time to cancel the entire creation process.
- Click Next. The Create Resource Wizard will then create your Sybase ASE resource hierarchy. SPS will validate the data entered. If SPS detects a problem, an error message will appear in the information box.
|Server||Select the SPS server where the Sybase ASE resource is to be created.|
Choose either intelligent or automatic. This determines how the Sybase ASE resource will be switched back to the primary server after it comes in-service (active) on the backup server following a failover. Intelligent switchback requires administrative intervention to switch the resource back to the primary server, while automatic switchback occurs as soon as the primary server is back on line and reestablishes SPS communication paths.
Note: The switchback strategy must match that of the dependent resources to be used by the Sybase ASE resource.
|Sybase Install Directory||This field is used to specify the installation location of the Sybase ASE product. You may type in another directory path. The valid characters allowed for the pathname are letters, digits and the following special characters: – _ . /|
|Sybase Instance Directory||This field is used to specify the directory path that contains the Sybase data directory. The data directory will typically contain the ASE-<version>/RUN_* files for the instance.|
|Sybase Instance||This field contains by default the name of the first Sybase instance found on the system, for which no SPS hierarchy exists. The drop down list shows other Sybase instances that may be available on your SPS server. This field is used to specify the Sybase ASE Database instance that will be placed under LifeKeeper protection. The specified instance must exist and must be running.|
|Sybase Username||This field is used to enter the user name for the Sybase System Administrator. By default the user name is sa. This System Administrator must have login and full privileges on any database on the Sybase Adaptive Server being protected.|
|Sybase Login Password||This field is used to specify the password for the Sybase System Administrator.|
|Sybase Backup Server||This field is used to specify the Sybase Backup server for the specified Adaptive Server instance. This Sybase Backup will be placed under SPS protection. The user may select ‘none’ if the Sybase Backup Server does not need to be included under SPS protection.|
|Sybase ASE Database Tag||This is a unique tag name for the new Sybase ASE database resource on the primary server. The default tag name consists of the word sybase followed by the name of the Adaptive Server instance. You may type in another unique tag name. The valid characters allowed for the tag are letters, digits, and the following special characters: – _ . /|
- You should see a message indicating that you have successfully created a Sybase ASE resource hierarchy, and you must extend that hierarchy to another server in your cluster to achieve failover protection. Click Next.