Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - Database Administration » Starting and Connecting to Your Database » The database server » Database options

 

-xp database option

Provides information to an operational server that allows it to connect to its partner and to the arbiter when database mirroring is being used. The -xp database option must be specified after the database-file, and applies only to that database.

Syntax
dbsrv11 [ server-options ] database-file
-xp partner=( partner-conn );
auth=auth-str;
[ ;arbiter=( arbiter-conn ) ]
[ ;mode=[ sync | async | page ]
[ ;autofailover=[ YES | NO ] ]
[ ;pagetimeout=n ]
[ ;preferred=[ YES | NO ] ...
Applies to

All operating systems, except Windows Mobile, network server only.

Remarks

When you specify -xp, you must also specify the location of the database mirroring state information file with the -xf option.

if the connection parameters specified in the -xp option are invalid, and there are multiple databases running on the server, then the mirrored database fails to start and does not attempt to reconnect. If the mirrored database is the only database running on the database server, then the database server does not start.

partner-conn   Specifies the connection string for the partner server. A user ID and password are not required. It is recommended that you specify a timeout to reduce failover time.

auth-str   Specifies the authentication string used by the arbiter.

arbiter-conn   Specifies the connection string for the arbiter server. A user ID and password are not required. It is recommended that you specify a timeout to reduce failover time.

mode   Specifies the synchronization mode used for database mirroring: synchronous (sync), asynchronous (async), or asyncfullpage (page).

autofailover   Specifies whether the mirror server automatically takes over as the primary server when the original primary server goes down. This option does not apply to synchronous mode.

Note

It is recommended that if you are using asynchronous or asyncfullpage mode, that you set the -xp autofailover option to yes. Then, if the primary server goes down, the mirror server automatically takes over as the primary server.

pagetimeout   Specifies how often, in seconds, transaction log pages are sent to the mirror server, whether or not they are full. This option applies only when using asyncfullpage mode.

preferred   Specifies whether the server is the preferred server in the mirroring system. The preferred server assumes the role of primary server whenever possible. See Specifying a preferred database server.

See also
Example

The following command specifies parameters for the partner server named server2 and the arbiter server named arbsrv.

dbsrv11 -n server1 mydata.db -sn mydata 
-xp "partner=(ENG=server2;LINKS=tcpip(TIMEOUT=1));
AUTH=abc;arbiter=(ENG=arbsrv;LINKS=tcpip(TIMEOUT=1))"