according to manual:

1. dbsrv11 -x tcpip\(PORT=2639\) -su sql -n arbiter -xa
"auth=abc;DBN=demo" -xf /Z/ARB/arbiterstate.txt -z -zr all

oki

2. dbsrv11 -n server1 -x tcpip\(PORT=2638\) -xf
/Z/S1/server1state.txt -su sql /Z/S1/demo.db -sn mirrordemo
-xp
"partner=(ENG=server2;LINKS=tcpip(PORT=2637;TIMEOU T=1));auth=abc;
arbiter=(ENG=arbiter;LINKS=tcpip(PORT=2639;TIMEOUT =1));mode=sync"
-z -zr all

oki

3. dbsrv11 -n server2 -x tcpip\(PORT=2637\) -xf
/Z/S2/server2state.txt -su sql /Z/S2/demo.db -sn mirrordemo
-xp
"partner=(ENG=server1;LINKS=tcpip(PORT=2638;TIMEOU T=1));auth=abc;
arbiter=(ENG=arbiter;LINKS=tcpip(PORT=2639;TIMEOUT =1));mode=sync"
-z -zr all

oki

4. connect dbisql -c
"UID=DBA;PWD=sql;ENG=mirrordemo;LINKS=tcpip"
oki, test table is created.

5. disconnect dbstop -y -c "UID=DBA;PWD=sql;ENG=mirrordemo"
oki

arbiter: Mirror server "server1" disconnected
server2: cyckling with following
----------
Using broadcast address of: 192.168.97.255:2638
Server not found (no reply received)
Looking for server with name server1
Using a second timeout counter of: 1
Sending broadcast to find server
Using broadcast address of: 82.143.197.127:2638
--------

6. no any msg about server2 took database ownership. attempt
to connect with dbisql -c
"UID=DBA;PWD=sql;ENG=mirrordemo;LINKS=tcpip"

message: [Sybase][ODBC Driver][SQL Anywhere]Database server
not found
Error code=-100
SQL state=08001

what is wrong here?

Your command lines and procedure look to be correct.

Questions:
1) What version and build are you using? I would suggest using the latest build
of 11.0.1.
2) Are the servers being started on the same machine or different machines?
3) If the servers are on different machines, are they on different subnets? If
so, the connection strings in the -xp command line options will need to change
to allow proper communication between the servers (you'll need to add the HOST
parameter to the TCPIP settings).

SQL Anywhere Developer Community:
http://www.sybase.com/developer/libr...ere-techcorner


SQL Anywhere Blog Center: http://www.sybase.com/sqlanyblogs




Alex wrote:

SQL Anywhere Network Server Version 11.0.1.2324

I'd suggest adding "-o fname" to the server 1 and 2 command lines to capture the
full console output and post the results.

SQL Anywhere Developer Community:
http://www.sybase.com/developer/libr...ere-techcorner


SQL Anywhere Blog Center: http://www.sybase.com/sqlanyblogs




Alex wrote: