Verifying that servers are running

  1. To find out whether Adaptive Server is currently running, try to log in to the server, using isql:

    isql -Usa -P -Sserver_name
    

    If the server is running, you see the isql prompt:

       1>
    

    You can also use the showserver command to determine whether any Adaptive Server processes are running. For example:

    $SYBASE/$SYBASE_ASE/install/showserver
    
  2. To verify that you are at the new version level, connect to Adaptive Server via isql and run the following commands:

    1> select @@version 
    2> go
    

    Look for “12.5” in the version string.

    1> sp_configure "upgrade version" 
    2> go
    

    sp_configure should return the Run Value “12500”.