Setting up the server message store

When setting up the server message store, an archive message store is created. The archive message store is a set of tables that coexist with the server message store, and stores all messages waiting to be deleted. A regularly executed system process transports messages between the message stores by removing all messages in the server message store that have reached a final state and then inserting them into the archive message store. Messages remain in the archive message store until deleted by a server delete rule. Usage of the archive message store improves the performance of the server message store by minimizing the amount of messages that need to be filtered during synchronization. See Archive message store requests.

To set up a database to use as a server message store, you run a setup script. The consolidated database should be configured for case insensitive comparisons and string operations. If you use the Create Synchronization Model Wizard to create your consolidated database, the setup is done for you.

See Setting up a consolidated database.

For information about creating SQL Anywhere databases, see Initialization utility (dbinit).

If you are using a SQL Anywhere database that was created before version 10.0.0, it must be upgraded.

For information about upgrading your database, see Upgrading to SQL Anywhere 11.

Note

The easiest way to create and maintain your server message store is in Sybase Central. From the QAnywhere plug-in task pane, choose Server Message Store.

Example

To create a SQL Anywhere database called qanytest.db, run the following command:

dbinit -s qanytest.db

Run the MobiLink setup script on the database:

%SQLANY11%\MobiLink\setup\syncsa.sql

This database is ready to use as a server message store.