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
  • A Linux platform

    sybcluster -Uuafadmin -P -F "blade1:9999, blade2:9999, blade3:9999"
    > create cluster
    Please enter the name of the cluster: mycluster
    Cluster mycluster - Please enter the maximum number of instances: [ 4 ] 
    How many agents will participate in this cluster: [ 3 ] 
    Verifying the supplied agent specifications...
           1) blade1 9999 2.5.0 Linux
           2) blade2 9999 2.5.0 Linux
           3) blade3 9999 2.5.0 Linux
    Enter the number representing the cluster node 1: [ 1 ]
    ------------------------------------------------------
    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: /dev/raw/raw11
    Please enter any traceflags: 
    
    --------------- 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 the master device: /dev/raw/raw12
    Enter the size the Master Device (MB): [ 80 ] 
    Enter the size the Master Database (MB): [ 60 ] 
    Please enter the page size in kilobytes: [ 2 ] 
    
    ------------ Sybase System Procedure Device --------
    Sybase system procedures (sybsystemprocs) are stored on a device.
    Enter the System Procedure Device path: /dev/raw/raw13
    Enter System Procedure Device size (MB): [ 160 ] 
    Enter the System Procedure Database size (MB): [ 152 ] 
    
    -------------- System Database Device ------------------
    The system database (sybsystemdb) stores information about distributed transactions.
    Enter the System Database Device path: /dev/raw/raw14
    Enter the System Database Device size (MB): [ 12 ] 
    Enter the System Database size (MB): [ 12 ] 
    
    -----------------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 PCI Database Device path: /dev/raw/raw20
    Enter the PCI Database Device size (MB): [ 24 ]
    Enter the PCI Database size (MB): [ 24 ]
    --------------------------------------------------------
    Does this cluster have a primary network: [ Y ] 
    Does this cluster have a secondary network: [ Y ]
    --------------------------------------------------------
    Please enter the SYBASE home directory: /remote/var/sybase
    Please enter the environment shell script path: [/remote/var/sybase/SYBASE.sh ] 
    Please enter the ASE home directory: [ /remote/var/sybase/ASE-15_0 ] 
    Enter path to the dataserver config file: [ /remote/var/sybase/mycluster.cfg ] 
    --------------------------------------------------------
    You will now be asked for the instance information on a node by node basis.
    Enter the name of the node: blade1
    -- Cluster: mycluster - Node: blade1 - Agent: blade1:9999 --
    
    Enter the name of the cluster instance: ase1
    Enter the interface file query port number for instance ase1: 19786
    Enter the primary protocol address for ase1: 10.0.1.1
    Enter the secondary protocol address for ase1: 10.0.1.2
    
    --------------- Local System Temporary Database ---------
    The Local System Temporary Database Device contains a database for each instance in the cluster.
    Enter the LST device name: mycluster1_tempdb
    Enter the LST device path: /dev/raw/raw15
    Enter LST device size (MB): 40
    Enter the LST database name: [ mycluster_tdb_1 ] 
    Enter the LST database size (MB): 40
    --------------------------------------------------------
    Do you want to add another instance? (Y or N): [ N ] Y
    Enter the name of the node: blade2
    -- Cluster: mycluster - Node: blade2 - Agent: blade2:9999 --
    
    Enter the name of the cluster instance: ase2
    Enter the interface file query port number for instance ase2: 19786
    Enter the primary protocol address for ase2: 10.0.2.1
    Enter the secondary protocol address for ase2: 10.0.2.2
    
    --------------- Local System Temporary Database ---------
    The Local System Temporary Database Device contains a database for each instance in the cluster.
    Enter the LST device name: [ mycluster2_tempdb ] 
    Enter the LST device path: [ /dev/raw/raw16]
    Enter LST device size (MB): 40
    EEnter the LST database name: [mycluster_tdb_2
    Enter the LST database size (MB): 40
    ------------------------------------------------------------
    Do you want to add another instance? (Y or N): [ N ] Y
    Enter the name of the node: blade3
    
    -- Cluster: mycluster - Node: blade3 - Agent: blade3:9999 --
    
    Enter the name of the cluster instance: ase3
    Enter the interface file query port number for instance ase2: 19786
    Enter the primary protocol address for ase3: 10.0.3.1
    Enter the secondary protocol address for ase3: 10.0.3.2
    
    --------------- Local System Temporary Database ---------
    The Local System Temporary Database Device contains a database for each instance in the cluster.
    Enter the LST device name: [ mycluster3_tempdb ] 
    Enter the LST device path: [ /dev/raw/raw17]
    Enter LST device size (MB): 40
    EEnter the LST database name: [mycluster_tdb_3
    Enter the LST database size (MB): 40
    Do you want to add another instance? (Y or N): [ N ] N
    
    Would you like to save this configuration information in a file? [ Y ] y
    Enter the name of the file to save the cluster creation information: 
    [ /remote/var/sybase/mycluster.xml ]
    --------------------------------------------------------
    Create the cluster now? [ Y ] y
    ...
    Would you like to check whether this device supports IO fencing capability? [Y/N] n
    Please enter the interfaces directory: [ /remote/var/sybase ] 
sybcluster -Uuafadmin -P -F "blade1:9999, blade2:9999, blade3:9999"
> create cluster
Please enter the name of the cluster: mycluster
Cluster mycluster - Please enter the maximum number of instances: [ 4 ] 
How many agents will participate in this cluster: [ 3 ] 
Verifying the supplied agent specifications...
       1) blade1 9999 2.5.0 Linux
       2) blade2 9999 2.5.0 Linux
       3) blade3 9999 2.5.0 Linux
Enter the number representing the cluster node 1: [ 1 ]
------------------------------------------------------
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: /dev/raw/raw11
Please enter any traceflags: 

--------------- 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 the master device: /dev/raw/raw12
Enter the size the Master Device (MB): [ 80 ] 
Enter the size the Master Database (MB): [ 60 ] 
Please enter the page size in kilobytes: [ 2 ] 

------------ Sybase System Procedure Device --------
Sybase system procedures (sybsystemprocs) are stored on a device.
Enter the System Procedure Device path: /dev/raw/raw13
Enter System Procedure Device size (MB): [ 160 ] 
Enter the System Procedure Database size (MB): [ 152 ] 

-------------- System Database Device ------------------
The system database (sybsystemdb) stores information about distributed transactions.
Enter the System Database Device path: /dev/raw/raw14
Enter the System Database Device size (MB): [ 12 ] 
Enter the System Database size (MB): [ 12 ] 

-----------------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 PCI Database Device path: /dev/raw/raw20
Enter the PCI Database Device size (MB): [ 24 ]
Enter the PCI Database size (MB): [ 24 ]
--------------------------------------------------------
Does this cluster have a primary network: [ Y ] 
Does this cluster have a secondary network: [ Y ]
--------------------------------------------------------
Please enter the SYBASE home directory: /remote/var/sybase
Please enter the environment shell script path: [/remote/var/sybase/SYBASE.sh ] 
Please enter the ASE home directory: [ /remote/var/sybase/ASE-15_0 ] 
Enter path to the dataserver config file: [ /remote/var/sybase/mycluster.cfg ] 
--------------------------------------------------------
You will now be asked for the instance information on a node by node basis.
Enter the name of the node: blade1
-- Cluster: mycluster - Node: blade1 - Agent: blade1:9999 --

Enter the name of the cluster instance: ase1
Enter the interface file query port number for instance ase1: 19786
Enter the primary protocol address for ase1: 10.0.1.1
Enter the secondary protocol address for ase1: 10.0.1.2

--------------- Local System Temporary Database ---------
The Local System Temporary Database Device contains a database for each instance in the cluster.
Enter the LST device name: mycluster1_tempdb
Enter the LST device path: /dev/raw/raw15
Enter LST device size (MB): 40
Enter the LST database name: [ mycluster_tdb_1 ] 
Enter the LST database size (MB): 40
--------------------------------------------------------
Do you want to add another instance? (Y or N): [ N ] Y
Enter the name of the node: blade2
-- Cluster: mycluster - Node: blade2 - Agent: blade2:9999 --

Enter the name of the cluster instance: ase2
Enter the interface file query port number for instance ase2: 19786
Enter the primary protocol address for ase2: 10.0.2.1
Enter the secondary protocol address for ase2: 10.0.2.2

--------------- Local System Temporary Database ---------
The Local System Temporary Database Device contains a database for each instance in the cluster.
Enter the LST device name: [ mycluster2_tempdb ] 
Enter the LST device path: [ /dev/raw/raw16]
Enter LST device size (MB): 40
EEnter the LST database name: [mycluster_tdb_2
Enter the LST database size (MB): 40
------------------------------------------------------------
Do you want to add another instance? (Y or N): [ N ] Y
Enter the name of the node: blade3

-- Cluster: mycluster - Node: blade3 - Agent: blade3:9999 --

Enter the name of the cluster instance: ase3
Enter the interface file query port number for instance ase2: 19786
Enter the primary protocol address for ase3: 10.0.3.1
Enter the secondary protocol address for ase3: 10.0.3.2

--------------- Local System Temporary Database ---------
The Local System Temporary Database Device contains a database for each instance in the cluster.
Enter the LST device name: [ mycluster3_tempdb ] 
Enter the LST device path: [ /dev/raw/raw17]
Enter LST device size (MB): 40
EEnter the LST database name: [mycluster_tdb_3
Enter the LST database size (MB): 40
Do you want to add another instance? (Y or N): [ N ] N

Would you like to save this configuration information in a file? [ Y ] y
Enter the name of the file to save the cluster creation information: 
[ /remote/var/sybase/mycluster.xml ]
--------------------------------------------------------
Create the cluster now? [ Y ] y
...
Would you like to check whether this device supports IO fencing capability? [Y/N] n
Please enter the interfaces directory: [ /remote/var/sybase ] 


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