Sample sysc_input_file

The following is the sysc_input_file used to create and configure the Adaptive Server resource group rg_MONEY and its resources as shown in Figure 10-1:

###########################################################################
##NOTE:                                                                  ##
##    1. This file will be executed by ksh to set environment of syscadm ##
##	 You will be responsible for executing anything in this file      ##
##       So, make sure THERE ARE NO DANGEROUS COMMANDS IN THIS FILE      ##
##	                                                                  ##
##    2. No spaces around = in the <Variable_name>=<value> pairs         ##
##	                                                                  ##
##    3. Comments should start with #, like ksh comments                 ##
##	                                                                  ##
##    4. Names ending with 1 correspond to primary, and 2 to secondary   ##
###########################################################################

###########################################################
##  Section1: Must specify right hand side values        ##
###########################################################
# Sybase home directory
SYBASE="/sybase"

# Valid HA Setups are "ACTIVE_PASSIVE" or "ASYMMETRIC" or "SYMMETRIC"
HA_SETUP="ACTIVE_PASSIVE"

# Comma separated list of nodes, Ex: "node1,node2"
Nodelist="node1,node2"

# ASE Dataserver name and Dataserver login file
Dataserver_name1="MONEY"
Dataserver_login_file1="/sybase/ASE-15_0/SC-3_0/etc/ase_login_file"

Dataserver_name2=
Dataserver_login_file2=

############################################################################
##  Section2: Must specify right hand side values, if required            ##
############################################################################

# if using Logical Hostname or Virtual/Floating IP address
LOGHOST_NAME_OR_FLOATING_IP1="loghost"
LOGHOST_NAME_OR_FLOATING_IP2=

# if using HAStorage resource
ServicePaths1="/global/node1_share"
ServicePaths2=

# if using HAStoragePlus resource
GlobalDevicePaths1=
FilesystemMountPoints1=

GlobalDevicePaths2=
FilesystemMountPoints2=

############################################################################
## Section3: May specify right hand side values to override defaults      ##
############################################################################

# bin of the cluster commands
CLUSTER_BIN="/usr/cluster/bin"

# ASE Resource Type and corresponding registration file
RT_NAME="SY.ase"
RT_FILE="$SYBASE/ASE-15_0/SC-3_0/etc/$RT_NAME"

# Resource Group names
RG_NAME1="rg_$Dtatserver_name1"
RG_NAME2="rg_$Dataserver_name2"

# ASE Resource names and space separated extended properties
ASE_RNAME1="ase_$Dataserver_name1"
ASE_RNAME2="ase_$Dataserver_name2"

OTHER_PROPERTIES1="RUN_server_file=/sybase/ASE-15_0/install/RUN_MONEY" 
OTHER_PROPERTIES2="RUN_server_file=  Callback_log=  Monitor_log="

# Logical Host Resource names
LOGHOST_RNAME1="lh_$Dataserver_name1"
LOGHOST_RNAME2="lh_$Dataserver_name2"

# HA Storage Resource names
HASTORAGE_RNAME1="has_$Dataserver_name1"
HASTORAGE_RNAME2="has_$Dataserver_name2"

# HA Storage Plus Resource names
HASTORAGE_PLUS_RNAME1="hasp_$Dataserver_name1"
HASTORAGE_PLUS_RNAME2="hasp_$Dataserver_name2"

The input file is divided into three sections.

For example, to edit the file for the Adaptive Server resource name, change this line:

ASE_RNAME="ase_$Dataserver_name"

To:

ASE_RNAME="MONEY_RNAME"
OTHER_PROPERTIES="RUN_server_file=/mypath/RUN_MONEY Debug_callback=TRUE"

Or, to specify the RUN_SERVER file and to set the Debug_callback flag, change the entry for OTHER_PROPERTIES, whose value is a space-separated list of <name>=<value> strings.

The syntax for syscadm is:

syscadm [-v] -c|r|u [primary|secondary|both] -f <sysc_input_file>
syscadm [-v] -r|u <rg1,rg2,...> [-t <ASE_resource_type>]

Where:

SUNW.HAStoragePlus resources are created with AffinityOn=True.

NoteFor the active-passive configuration, only primary should be used with the -c option to create the Adaptive Server resource group.