Chapter 14: Configuring Adaptive Server for Failover on SGI IRIX

Defining the Adaptive Server resources for the secondary node

Select Define a Resource and fill in the following fields:

Field	Sample value	Description
Resource Type	SYBASE_DB	The type of resource to define. The FailSafe system includes pre-defined resource types, or you can define your own. See your SGI documentation for information.
Resource	sec_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 we ping Adaptive Server using isql. Each ping creates a new isql session, then terminates it at the end.
SYBASE_ASE	ASE-12_5	The subdirectory within $SYBASE where the Adaptive Server binaries exist.
SYBASE_OCS	OCS-12_5	The subdirectory within $SYBASE where the Open Client Server binaries exist; specifically, isql.
HOST1	PERSONNEL1	The local hostname(1) value.
HOST2	MONEY1	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 we time out.
HA_LOGIN	sa	A user with ha_role assigned who has the capability to monitor Adaptive Server and shut it down.
SYBSERVER1	PERSONNEL1	The local Adaptive Server’s DSQUERY value.
SYBSERVER2	MONEY1	The remote Adaptive Server’s DSQUERY value.

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

Field	Sub field	Sample value	Description
Resource Type		SYBASE_DB	Select a value from the pull-down list
Resource		sec_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	/vol2	Similar to a Resource; the list of values is limited based on the Dependency Type.

From the command line, enter the following:

cluster_mgr –f sec_ase_resource_def