Create the following directories: c:\server1, c:\server2, and c:\arbiter.

Create a database named mirror_demo.db that contains data from the sample database and has a transaction log. You cannot start a database that doesn't have a transaction log in mirroring mode. Run the following command:

newdemo c:\server1\mirror_demo.db

Start the first database server. Run the following command:

dbsrv16 -n mirror_server1 -x "tcpip(PORT=6871)" -su sql "c:\server1\mirror_demo.db" -xp on

Connect to the database from Interactive SQL. Run the following command:

dbisql -c "UID=DBA;PWD=sql;SERVER=mirror_server1"

Define the partner servers and arbiter server for the database by using the CREATE MIRROR SERVER statement.

Execute the following statements to define mirror_server1 and mirror_server2 as partner servers in the database mirroring system:

CREATE MIRROR SERVER mirror_server1
AS PARTNER
connection_string='SERVER=mirror_server1;host=localhost:6871'
state_file='c:\\server1\\server1.state';

CREATE MIRROR SERVER mirror_server2
AS PARTNER
connection_string='SERVER=mirror_server2;host=localhost:6872'
state_file='c:\\server2\\server2.state';

Execute the following statements to define

The roles of primary and mirror are necessary for configuring the database servers in the system: the names that you give these servers are used as alternate server names when clients connect to the database servers. Either partner server can act as the primary or mirror server.

CREATE MIRROR SERVER mirror_demo_primary
AS PRIMARY
connection_string='SERVER=mirror_demo_primary;HOST=localhost:6871,localhost:6872';
CREATE MIRROR SERVER mirror_demo_mirror
AS MIRROR
connection_string='SERVER=mirror_demo_mirror;HOST=localhost:6871,localhost:6872';

Execute following SQL statement to define the arbiter server for the database mirroring system:

CREATE MIRROR SERVER demo_arbiter
AS ARBITER
connection_string ='SERVER=demo_arbiter;HOST=localhost:6870';

Set the authentication string for the database. Execute the following statement:

SET MIRROR OPTION authentication_string='abc';

Use the Backup utility (dbbackup) to copy the database file and transaction log in c:\server1 to c:\server2. Run the following command:

dbbackup -c "UID=DBA;PWD=sql;SERVER=mirror_server1;DBN=mirror_demo" c:\server2

Start the second partner server. Run the following command:

dbsrv16 -n mirror_server2 -x "tcpip(PORT=6872;DOBROAD=no)" -su sql "c:\server2\mirror_demo.db" -xp on

Start the arbiter server. Run the following command:

dbsrv16 -n demo_arbiter -su sql -x "tcpip(PORT=6870;DOBROAD=no)" -xf "c:\arbiter\arbiter.state" -xa "AUTH=abc;DBN=mirror_demo"

Start Interactive SQL and connect to the primary server using the alternate server name for the primary server. Run following command:

dbisql -c "UID=DBA;PWD=sql;SERVER=mirror_demo_primary;HOST=localhost:6871,localhost:6872"

Add data to the database. Execute the following statements:

CREATE TABLE test (col1 INTEGER, col2 CHAR(32));
INSERT INTO test VALUES(1, 'Hello from server1');
COMMIT;

(Optional) To determine the name of database server that you are connected to you, use the ServerName database server property. Execute the following statement:

SELECT PROPERTY( 'ServerName' );

Close all Interactive SQL windows.