Sample sybcluster Session

Look here for a sybcluster sample session.

This sample session assumes:
  • A shared configuration
  • An interfaces file for server lookup
  • 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 ] 
    --------------------------------------------------------