Chapter 14: Configuring Adaptive Server for Failover on SGI IRIX

Defining the Adaptive Server resources for the primary node

Select Define a Resource

Field	Sample value	Description
Resource Type	SYBASE_DB	The type of resource to define. The FailSafe system includes predefined resource types, or you can define your own. See your SGI documentation for information.
Resource	pri_ase	Name of the resource to define.

Click Next. Complete the following fields with the appropriate values.

Field	Sample value	Description
HA_PWD	psswrd	To enter a NULL password, use single quotes
SYBASE1	/usr/sybase	The local Adaptive Server’s $SYBASE value
SYBASE2	/usr/sybase	The remote Adaptive Server’s $SYBASE value
SYBUSER	sybase	The IRIX user name who owns $SYBASE. The value is used by IRIX FailSafe to log in and start Adaptive Server.
MONITOR_INTERVAL	5	How often you ping Adaptive Server using isql. Each ping creates a new isql session, then terminates it.
SYBASE_ASE	ASE-12_5	The subdirectory within $SYBASE where the Adaptive Server exists.
SYBASE_OCS	OCS-12_5	The subdirectory within $SYBASE where the Open Client Server binaries exist; specifically, isql.
HOST1	MONEY1	The local hostname(1) value.
HOST2	PERSONNEL1	The remote hostname(1) value.
RECOVERY_TIMEOUT	90	The number of seconds that you are willing to wait for Adaptive Server to run through recovery on all its databases. This can take some time, depending on the size of the transaction logs and how many databases are being rolled forward. If you exceed the limit specified, IRIX FailSafe issues an error.
SHUTDOWN_TIMEOUT	30	The number of seconds you are willing to wait before timing out.
HA_LOGIN	sa	A user with ha_role assigned who has the ability to monitor Adaptive Server and shut it down.
SYBSERVER1	MONEY1	The local Adaptive Server’s DSQUERY value.
SYBSERVER2	PERSONNEL1	The remote Adaptive Server’s DSQUERY value.

Select Add/Remove Dependencies for a Resource Definition. Enter values for the following fields:

Field	Sub field	Sample value	Description
Resource Type		SYBASE_DB	Select a value from the pull-down list.
Resource		pri_ase	The list of values is displayed for the Resource Type.
List of Dependencies		N/A	Information line
	Dependency Type	file system	Similar to a Resource Type.
	Dependency Name	/vol1	Similar to a Resource. The list of values is limited based on the Dependency Type.

From the command line, enter:

cluster_mgr –f pri_ase_resource_def