InfoScale™ 9.0 Cluster Server Agent for Sybase Installation and Configuration Guide - AIX

Sample configuration for a Sybase service group on AIX systems

The following sample depicts a basic configuration with a Sybase service group configured with one NIC, one database instance configured with detail monitoring, and one backup instance.

   include "types.cf"
   include "SybaseTypes.cf"

   cluster vcscluster (
   UserNames = { admin = anoGniNkoJooMwoInl }
   Administrators = { admin }
   CounterInterval = 5
   )

   system system1 (
   )

   system system2 (
   )

   group Sybase_group (
   SystemList = { system1 = 0, system2 = 1 }
   AutoStartList = { system1, system2 }
   )

   DiskGroup dgres (
       DiskGroup = sybase
       )

   IP ipres (
       Device = en0
       Address = "16.9.1.9"
       NetMask = "255.255.0.0"
       )

   NIC nicres (
       Device = en0
       NetworkHosts = { "16.9.10.3", "16.9.10.4" }
       )

   Mount sybase_mastermount (
       MountPoint = "/sybdb"
       BlockDevice = "/dev/vx/dsk/sybase/sybdb"
       FSType = vxfs
       MountOpt = rw
       FsckOpt = "-n"
       )
   Mount sybase_mount (
       MountPoint = "/sybbin"
       BlockDevice = "/dev/vx/dsk/sybase/sybbin"
       FSType = vxfs
       MountOpt = rw
       FsckOpt = "-n"
       )

   Mount sybase_procsmount (
       MountPoint = "/sybprocsdb"
       BlockDevice = "/dev/vx/dsk/sybase/sybprocsdb"
       FSType = vxfs
       MountOpt = rw
       FsckOpt = "-n"
       )

   Mount sybase_usermount (
       MountPoint = "/sybuserdb"
       BlockDevice = "/dev/vx/dsk/sybase/sybuserdb"
       FSType = vxfs
       MountOpt = rw
       FsckOpt = "-n"
       )
 
   Sybase sybase_agent (
       Server = SYBASE_SERVER
       Owner = sybase
       Home @system1 = "/sybbin"
       Home @system2 = "/sybbin"
       Version @system1 = sybase15
       Version @system2 = sybase15
       SA = sa
       SApswd = GUJuPStSHsUUkSLsJ
       LevelTwoMonitorFreq = 1 
       User = sa
       UPword = GUJuPStSHsUUkSLsJ
       Db = vcsdb
       Table = vcstable
       Monscript = "/opt/VRTSagents/ha/bin/Sybase/SqlTest.pl"
       WaitForRecovery = 1
							Run_ServerFile = "/sybbin/RUN_SYBASE_SERVER"
       interfaces_File = "/newfs/interfaces"
							)

   SybaseBk sybase_bk_agent (
       Backupserver = SYBASE_SERVER_BS
       Owner = sybase
       Home @system1 = "/sybbin"
       Home @system2 = "/sybbin"
       Version @system1 = sybase15
       Version @system2 = sybase15
       Server = SYSTEM1
       SA = sa
       SApswd = GUJuPStSHsUUkSLsJ       
							Run_ServerFile = "/sybbin/RUN_SYBASE_SERVER_BS"
       interfaces_File = "/newfs/interfaces"
							)

   Volume sybaseBinVol (
       Volume = sybbin
       DiskGroup = sybase
       )

   Volume sybaseMasterVol (
       Volume = sybdb
       DiskGroup = sybase
       )

   Volume sybaseProcsVol (
       Volume = sybprocsdb
       DiskGroup = sybase
       )

   Volume sybaseUserVol (
       Volume = sybuserdb
       DiskGroup = sybase
       )

   ipres requires nicres
   sybaseBinVol requires dgres
   sybaseMasterVol requires dgres
   sybaseProcsVol requires dgres
   sybaseUserVol requires dgres
   sybase_agent requires ipres
   sybase_agent requires sybase_mastermount
   sybase_agent requires sybase_mount
   sybase_agent requires sybase_procsmount
   sybase_agent requires sybase_usermount
   sybase_bk_agent requires sybase_agent
   sybase_mastermount requires sybaseMasterVol
   sybase_mastermount requires sybase_mount
   sybase_mount requires sybaseBinVol
   sybase_procsmount requires sybaseProcsVol
   sybase_procsmount requires sybase_mount
   sybase_usermount requires sybaseUserVol
   sybase_usermount requires sybase_mount