-sm dbsrv12 database option (deprecated)

Provides an alternate database server name that can be used to access the read-only mirror database. This option is deprecated. Use the CREATE MIRROR SERVER statement instead.

Syntax

dbsrv12 [ server-options ] database-file -sm alternate-server-name

The alternate-server-name is only active when the database server is acting as mirror for the database. By using the -sm and -sn command-line options, an application can always connect to the database on the primary or the mirror server, without knowing which physical server is acting as primary or mirror.

The -sm database option must be specified after the database-file, and applies only to that database.

Example

The following command starts the databases satest.db and sample.db on a database server named myserver. The -sn option instructs the database server to use mysampleprimary as an alternate server name when connecting to sample.db, while the -sm option instructs the database server to use mysamplemirror as an alternate server name to connect to sample.db, running on the mirror server.

dbsrv12 -n myserver satest.db sample.db -sn mysampleprimary 
-sm mysamplemirror -xp "partner=( Server=server2;LINKS=TCPIP( PORT=2637;TIMEOUT=1 ) );
auth=abc;arbiter=( Server=arbiter;LINKS=TCPIP( PORT=2639;TIMEOUT=1 ) );mode=sync" 
-xf "c:\arbiter\arbiter.state"

You can connect to sample.db while it is running on the primary server using any of the following connection parameters:

Server=myserver;DBN=sample
Server=mysampleprimary
Server=mysampleprimary;DBN=sample

You cannot connect to satest.db using Server=mysampleprimary.

You can connect to sample.db while it is running on the mirror server using any of the following connection parameters:

Server=myserver;DBN=sample
Server=mysamplemirror
Server=mysamplemirror;DBN=sample

You cannot connect to satest.db using Server=mysamplemirror.

Discuss this page in DocCommentXchange.

-sm dbsrv12 database option (deprecated)

Syntax

Applies to

Remarks

See also

Example