You can perform a sanity test to confirm that your Open Switch is running, and that it can accept client connections.
Confirming that OpenSwitch can accept client connections
Make sure the Adaptive Server you configured to use with OpenSwitch is running by executing the following, where server_name is the name of the Adaptive Server you configured to use with OpenSwitch:
1> isql.exe -Usa -P -Sserver_name 2> go
The connection goes through if Adaptive Server is up and running.
In your %SYBASE% location, enter the following from a command prompt:
.\SYBASE.bat
Log in as an Administrator, and connect to OpenSwitch using the following isql command:
1> rp_set TEXTSIZE 2> go
You should see:
parameter value ------------------------------------------------ TEXTSIZE 1048576 (1 row affected) (return status = 0)
Log in to OpenSwitch in isql using the following syntax:
isql -Uusername -Ppassword -Sservername
Where:
username – is the client username
password – is the client username
servername – is the name of the OpenSwitch server
At the prompt, issue the select @@version command to see the version information of the Adaptive Server that OpenSwitch is connected to. For example:
1> select @@version 2> go
Adaptive Server Enterprise/12.5.2/EBF 11799/P/Linux Intel/Enterprise Linux/ase1252/1831/32-bit/OPT/Fri Apr 9 02:53:50 2004
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
