A sybcluster sample session that assumes a shared configuration, an interfaces file for server lookup, and support for Java in the database.
sybcluster -U uafadmin -P -F hpcblade2:9009,hpcblade1:9009,hpcblade3:9009,hpcblade4:9009 > create cluster Enter the name of the cluster: mycluster Cluster mycluster - Enter the maximum number of instances: [ 4 ] How many agents will participate in this cluster: [ 4 ] 4 Verifying the supplied agent specifications... 1) hpcblade1.sybase.com 9009 2.5.0 Linux 2) hpcblade2.sybase.com 9009 2.5.0 Linux 3) hpcblade3.sybase.com 9009 2.5.0 Linux 4) hpcblade4.sybase.com 9009 2.5.0 Linux Enter the number representing the cluster node 1: [ 4 ] 1 2) hpcblade2.sybase.com 9009 2.5.0 Linux 3) hpcblade3.sybase.com 9009 2.5.0 Linux 4) hpcblade4.sybase.com 9009 2.5.0 Linux Enter the number representing the cluster node 2: [ 4 ] 2 3) hpcblade3.sybase.com 9009 2.5.0 Linux 4) hpcblade4.sybase.com 9009 2.5.0 Linux Enter the number representing the cluster node 3: [ 4 ] 3 4) hpcblade4.sybase.com 9009 2.5.0 Linux Enter the number representing the cluster node 4: [ 4 ] 4 Will this cluster be configured using private SYBASE installations? (Y/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: /hpcblade_cfs/q/pd16218942/d3.dbs Enter any traceflags: -------------------- Page Size -------------------- Enter the page size in kilobytes: [ 2 ] 8 --------------- 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: /hpcblade_cfs/q/pd16218942/d4.dbs Enter the size the Master Device (MB): [ 120 ] 500 Enter the size the Master Database (MB): [ 52 ] 100 ------------ Sybase System Procedure Device -------- Sybase system procedures (sybsystemprocs) are stored on a device. Enter the System Procedure Device path: /hpcblade_cfs/q/pd16218942/d5.dbs Enter System Procedure Device size (MB): [ 152 ] 200 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: /hpcblade_cfs/q/pd16218942/d6.dbs Enter the System Database Device size (MB): [ 24 ] 100 Enter the System Database size (MB): [ 24 ] 100 --------------- 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 Server (Y/N): [ N ] y Enter the full path to the PCI device: /hpcblade_cfs/q/pd16218942/pci.dbs Enter the size the PCI Device (MB): [ 96 ] Enter the size the PCI Database (MB): [ 96 ] -------------------------------------------------------- Does this cluster have a secondary network: [ Y ] n Enter the port number from which this range will be applied: [ 15100 ] 17005 -------------------------------------------------------- Enter the SYBASE home directory: [ /remote/quasr5/adong/aries/release/lamce_s1 ] Enter the environment shell script path: [ /remote/quasr5/adong/aries/release/lamce_s1/SYBASE.sh ] Enter the ASE home directory: [ /remote/quasr5/adong/aries/release/lamce_s1/ASE-15_0 ] Enter path to the dataserver configuration file: [ /remote/quasr5/adong/aries/release/lamce_s1/mycluster.cfg ] -------------------------------------------------------- You will now be asked for the instance information on a node by node basis. -- Cluster: mycluster - Node: hpcblade1.sybase.com - Agent: hpcblade1.sybase.com:9009 -- Enter the name of the cluster instance: instance1 Enter the interface file query port number for instance instance1: 10665 Enter the primary protocol address for instance1: [ hpcblade1.sybase.com ] --------------- Local System Temporary Database --------- The Local System Temporary Database Device contains a database for each instance in the cluster. Enter the LST device name: LST Enter the LST device path: /hpcblade_cfs/q/pd16218942/d7.dbs Enter LST device size (MB): 200 Enter the LST database name: [ mycluster_tdb_1 ] Enter the LST database size (MB): [ 200 ] 50 Do you want to add another instance to this node? (Y or N): [ N ] -- Cluster: mycluster - Node: hpcblade2.sybase.com - Agent: hpcblade2.sybase.com:9009 -- Enter the name of the cluster instance: instance2 Enter the interface file query port number for instance instance2: 15465 Enter the primary protocol address for instance2: [ hpcblade2.sybase.com ] --------------- Local System Temporary Database --------- The Local System Temporary Database Device contains a database for each instance in the cluster. Enter the LST device name: [ LST ] Enter the LST database name: [ mycluster_tdb_2 ] Enter the LST database size (MB): [ 150 ] 50 Do you want to add another instance to this node? (Y or N): [ N ] -- Cluster: mycluster - Node: hpcblade3.sybase.com - Agent: hpcblade3.sybase.com:9009 -- Enter the name of the cluster instance: instance3 Enter the interface file query port number for instance instance3: 16730 Enter the primary protocol address for instance3: [ hpcblade3.sybase.com ] --------------- Local System Temporary Database --------- The Local System Temporary Database Device contains a database for each instance in the cluster. Enter the LST device name: [ LST ] Enter the LST database name: [ mycluster_tdb_3 ] Enter the LST database size (MB): [ 100 ] 50 Do you want to add another instance to this node? (Y or N): [ N ] -- Cluster: mycluster - Node: hpcblade4.sybase.com - Agent: hpcblade4.sybase.com:9009 -- Enter the name of the cluster instance: instance4 Enter the interface file query port number for instance instance4: 15220 Enter the primary protocol address for instance4: [ hpcblade4.sybase.com ] --------------- Local System Temporary Database --------- The Local System Temporary Database Device contains a database for each instance in the cluster. Enter the LST device name: [ LST ] Enter the LST database name: [ mycluster_tdb_4 ] Enter the LST database size (MB): [ 50 ] Would you like to save this configuration information in a file? [ Y ] Enter the name of the file to save the cluster creation information: [ /hpcblade_cfs/q/s16218942/mycluster.xml ] -------------------------------------------------------- Create the cluster now? [ Y ] --------------------------------------------------------