Skip to Content
Author's profile photo Javier Ernesto Barthe

ASE CE Cluster Startup with XML file

1. Some global checks

Log in with Sybase User to Unix and check this enviromental variables:

  • SYBASE_JRE6=/sybase/shared/JRE-6_0_SR1_64BIT
  • SYBASE_UA=/sybase/UAF-2_5

Then check the sybcluster utility:sybcluster -v

  • Sybase sybcluster Command Line Utility/15.5/Cluster Edition/S/jdk1.4.2/ase155ce/400/Mon Nov 23 09:12:16 PST 2009

2. Startup Agents and create clusterStartup the unified agente for each node that its going to be part of the cluster:

  • sybase@db1(/sybase/UAF-2_5/bin)$. &
  • sybase@db2(/sybase/UAF-2_5/bin)$. &

sybase@db1(/sybase/ASE-15_0/bin)$. sybcluster -Uuafadmin -P -C dbcluster -F “db1,db2″
> create cluster dbcluster file /sybase/dbcluster.xml
The cluster dbcluster was successfully created.

Dbcluster.xml Details

<?xml version=”1.0″ encoding=”UTF-8″?>
<cluster name=”dbcluster” max_instances=”2″ version=”6″ status=”0″>
<traceflags />
<devices page_size=”2″ units=”k”>
<device type=”quorum” name=”quorum” path=”/sybase/devices/rquorum” />
<device type=”master” name=”master” path=”/sybase/devices/rmaster” size=”150″ units=”m”>
<database name=”master” size=”100″ units=”m” />
<device type=”sybsystemprocs” name=”sysprocsdev” path=”/sybase/devices/rsybprocs” size=”250″ units=”m”>
<database name=”sybsystemprocs” size=”250″ units=”m” />
<device type=”system” name=”systemdbdev” path=”/sybase/devices/rsybsystemdb” size=”80″ units=”m”>
<database name=”sybsystemdb” size=”80″ units=”m” />
<device name=”localsystempdb1″ path=”/sybase/devices/rlocalsystempdb1″ size=”950″ units=”m” />

<device name=”localsystempdb2″ path=”/sybase/devices/rlocalsystempdb2″ size=”950″ units=”m” />
<installation mode=”private” />
<nodes primary_protocol=”udp” secondary_protocol=”udp” first_port=”15100″>
<config_path value=”/sybase/dbcluster.cfg” />
<addl_run_params value=”” />
<sybase_home value=”/sybase” />
<ase_home value=”/sybase/ASE-15_0″ />
<env_shell_path value=”/sybase/” type=”sh” />
<node name=”db1″ public_address=”db1″ primary_address=”interlinkA1″ secondary_address=”interlinkB1″ uaf_port=”9999″>
<instance id=”1″ name=”db1″>
<interface port=”4100″ transport=”tcp” />
<primary_spec port_start=”15100″ />
<secondary_spec port_start=”15121″ />
<database device=”localsystempdb1″ type=”stdb” name=”dbcluster_tdb_1″ size=”950″ units=”m” />
<logfile path=”/sybase/ASE-15_0/install/db1.log” />
<config_path value=”/sybase/dbcluster.cfg” />
<sybase_home value=”/sybase” />
<ase_home value=”/sybase/ASE-15_0″ />
<env_shell_path value=”/sybase/” type=”sh” />
<node name=”db2″ public_address=”db2″ primary_address=”interlinkA2″ secondary_address=”interlinkB2″ uaf_port=”9999″>
<instance id=”2″ name=”db2″>
<interface port=”4101″ transport=”tcp” />
<primary_spec port_start=”15110″ />
<secondary_spec port_start=”15131″ />
<database device=”localsystempdb2″ type=”stdb” name=”dbcluster_tdb_2″ size=”950″ units=”m” />
<logfile path=”/sybase/ASE-15_0/install/db2.log” />
<config_path value=”/sybase/dbcluster.cfg” />
<sybase_home value=”/sybase” />
<ase_home value=”/sybase/ASE-15_0″ />
<env_shell_path value=”/sybase/” type=”sh” />

Javier E. Barthe

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.