Sample Session

Look her for a sybcluster sample session.

This sample session assumes:
  • A shared configuration
  • An interfaces file for server lookup
  • Support for Java in the database
  • An HP-UX platform

This is a sample session for an HP-UX platform. After starting sybcluster, enter:

> create cluster
Enter the name of the cluster: newc2
Cluster newc2 - Enter the maximum number of instances:  [ 4 ] 2
How many agents will participate in this cluster:  [ 4 ] 2Verifying the supplied agent specifications...
	1) hpia207.sybase.com 9999 2.5.0 HP-UX
	2) hpia208.sybase.com 9999 2.5.0 HP-UXEnter the number representing the cluster node 1:  [ 2 ] 1	2) hpia208.sybase.com 9999 2.5.0 HP-UX
Enter the number representing the cluster node 2:  [ 2 ] 2Will this cluster be configured using private SYBASE installations?(Y/N) : 
	[N ] N------------------ Quorum Device  ---------------------The quorum device is used to manage a cluster.  It contains information shared between instances and nodes.Enter the full path to the quorum disk: /dev/rdsk/c5t5d0s3
Enter any traceflags: 15500,3425,423--------------- Master Database Device  ----------------The master database device controls the operation of the Adaptive Server and stores information about all user databases and their associated database devices.Enter the full path to the master device: /dev/rdsk/c5t5d0s4
Enter the size the Master Device (MB):  [ 80 ] 500
Enter the size the Master Database (MB):  [ 60 ] 200
Enter the page size in kilobytes:  [ 2 ] 8------------ Sybase System Procedure Device --------Sybase system procedures (sybsystemprocs) are stored on a device.
Enter the System Procedure Device path: /dev/rdsk/c5t5d0s5
Enter System Procedure Device size (MB):  [ 152 ] 250
Enter the System Procedure Database size (MB):  [ 152 ] 200-------------- System Database Device ------------------The system database (sybsystemdb) stores information about distributed transactions.Enter the System Database Device path: /dev/rdsk/c5t5d0s6
Enter the System Database Device size (MB):  [ 12 ] 50
Enter the System Database size (MB):  [ 12 ] 30--------------- PCI Device  ----------------Pluggable Component Interface (PCI) provides support for Java in database by loading off-the-shelf JVMs from any vendor. If you want to use JVM, create a device for it.Enable PCI in Adaptive Servier (Y/N):  [ N ] No--------------------------------------------------------Does this cluster have a secondary network:  [ Y ] N
Enter the port number from which this range will be applied:  [ 15100 ] 13605--------------------------------------------------------Enter the SYBASE home directory:  [ /remote/quasr5/adong/ase1503ce/
hpia_pyxisc3 ] /remote/quasr5/adong/ase1503ce/hpia_pyxisc3Enter the environment shell script path:  [ /remote/quasr5/adong/ase1503ce/hpia_pyxisc3/SYBASE.sh ] /remote/quasr5/adong/ase1503ce/hpia_pyxisc3/SYBASE.shEnter the ASE home directory:  [ /remote/quasr5/adong/ase1503ce/hpia_pyxisc3/ASE-15_0 ] /remote/quasr5/adong/ase1503ce/hpia_pyxisc3/ASE-15_0Enter path to the dataserver config file:  [ /remote/quasr5/adong/ase1503ce/hpia_pyxisc3/newc2.cfg ] /remote/hpia207_tst2/sdcquasr/s16004848/config_files/newc2.cfg--------------------------------------------------------
You will now be asked for the instance information on a node by node basis.-- Cluster: newc2 - Node: hpia207.sybase.com - Agent: hpia207.sybase.com:9999 --Enter the name of the cluster instance: ins1_newc2
Enter the interface file query port number for instance ins1_newc2: 13600
Enter the primary protocol address for ins1_newc2:  [ hpia207.sybase.com ] hpia207--------------- Local System Temporary Database ---------The Local System Temporary Database Device contains a database for each instance in the cluster.
Enter the LST device name: LST1
Enter the LST device path: /dev/rdsk/c5t5d0s7
Enter LST device size (MB): 100
Enter the LST database name:  [ newc2_tdb_1 ] ins1_newc2tdb
Enter the LST database size (MB):  [ 100 ] 50-- Cluster: newc2 - Node: hpia208.sybase.com - Agent: hpia208.sybase.com:9999 --Enter the name of the cluster instance: ins2_newc2
Enter the interface file query port number for instance ins2_newc2: 9575
Enter the primary protocol address for ins2_newc2:  [ hpia208.sybase.com ] hpia208--------------- Local System Temporary Database ---------The Local System Temporary Database Device contains a database for each instance in the cluster.
Enter the LST device name:  [ LST1 ] LST1
Enter the LST database name:  [ newc2_tdb_2 ] ins2_newc2tdb
Enter the LST database size (MB):  [ 50 ] 50
Would you like to save this configuration information in a file?  [ Y ] yes
Enter the name of the file to save the cluster creation information:  
[ /remote/hpia207_tst2/sdcquasr/s16004848/newc2.xml ] /remote/hpia207_tst2/sdcquasr/s16004848/newc2.xml--------------------------------------------------------Create the cluster now?  [ Y ] yesINFO  - Creating the Cluster Agent plugin on host address hpia207.sybase.com using agent: hpia207.sybase.com:9999INFO  - Creating the Cluster Agent plugin on host address hpia208.sybase.com using agent: hpia208.sybase.com:9999LDAP server "fireball:8001" shall be used for storing server entries.Would you like to check whether this device supports IO fencing capability (Y/N)?  [ Y ] N
INFO  - Cluster "newc2" creation in progress

...

INFO - The cluster is now configured. Shutting down this first instance. The cluster newc2 was successfully created.
To verify the cluster, connect to the cluster and display the cluster configuration information. Enter:
> connect
newc2>
newc2> show cluster config
** Cluster configuration for "newc2" **
	Installation Mode  "shared"
	LDAP Server  "fireball:8001"
	Trace Flags:
		15500
		3425
		423
	Maximum Instances "2"
	Quorum "/dev/rdsk/c5t5d0s3"
	Master Device "/dev/rdsk/c5t5d0s4"
		logfile ins1_newc2 
/remote/quasr5/adong/ase1503ce/hpia_pyxisc3/ASE-15_0/install/ins1_newc2.log
		run_parameters ins1_newc2 
		logfile ins2_newc2 
/remote/quasr5/adong/ase1503ce/hpia_pyxisc3/ASE-15_0/install/ins2_newc2.log
		run_parameters ins2_newc2 
	Primary Interconnect "udp"
		Server[1] ins1_newc2 hpia207 13605 13614
		Server[2] ins2_newc2 hpia208 13615 13624
To start the cluster, enter:
newc2> start cluster
To verify that the cluster is running, enter:
newc3> show cluster status
INFO  - Listening for the cluster heartbeat. This may take a minute. Please wait... (newc2::AseProbe:434)	Id     Name            Node         State  Heartbeat	--  ----------  ------------------  -----  ---------	1  ins1_newc2  hpia207.sybase.com    Up      Yes 
	2  ins2_newc2  hpia208.sybase.com    Up      Yes 
	--  ----------  ------------------  -----  ------


Created June 23, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com