Verifying client connections

You can perform a sanity test to confirm that your Open Switch is running and can accept client connections.

  1. Open a command window.

  2. Use one of these commands to source the environment variables:

    source SYBASE.csh
    

    or

    . ./SYBASE.sh
    
  3. Use isql to log in to the OpenSwitch server:

    isql -Usa -P -S<OS_server_name>
    

    where <OS_server_name> is the name of the OpenSwitch server.

  4. Execute the following command:

    1> select @@servername
    2> go
    

    The name of the Primary Cache server should display.

  5. Use isql to log in to the OpenSwitch server as an Administrator:

    isql -Usa -Psa -S<OS_server_name>
    

    where <OS_server_name> is the name of the OpenSwitch server.

  6. At the command prompt, enter:

    1> rp_set TEXTSIZE
    2> go
    

    You should see:

    parameter value-------TEXTSIZE 1048576(1 row affected)
    (return status = 0)
    
  7. Use isql to log in to OpenSwitch as a client:

    isql -Uusername -Ppassword -S<OS_server_name>
    

    where:

  8. At the prompt, issue the select @@version command to see the version information of the Adaptive Server to which OpenSwitch is connected. For example:

    1> select @@version
    2> go
    
    Adaptive Server Enterprise/15.0/EBF 13444
    ESD #2/P/Sun_svr4/OS 5.8/ase150/2193/64-bit
    /FBO/Wed May 17 22:39:59 2006