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

All operating systems, network server only.

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.

• Separately licensed components
• Configuring read-only access to a database running on the mirror server
• -xa dbsrv12 server option
• -xf dbsrv12 server option
• -xp dbsrv12 database option
• START DATABASE statement
• Introduction to database mirroring
• Server Enumeration utility (dblocate)
• ReadOnly database property

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"

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.