The server message store is a relational database on the server that temporarily stores messages until they are transmitted to a client message store, web service or JMS system. Messages are exchanged between clients via the server message store.
A server message store is a MobiLink consolidated database, and so can be any RDBMS that MobiLink supports (SQL Anywhere, Adaptive Server Enterprise, Microsoft SQL Server, Oracle, or DB2). You can create a new database for this purpose, or use an existing database.
To set up a database to use as a MobiLink consolidated database (and hence a server message store), you run a setup script. 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 on upgrading your database, see Upgrading to SQL Anywhere 10.
The easiest way to create and maintain your server message store is in Sybase Central. From the QAnywhere plug-in task pane, choose Work With a Server Message Store.
To create a SQL Anywhere database called qanytest.db, type the following at a command prompt:
dbinit -s qanytest.db
Run the MobiLink setup script on the database:
This database is ready to use as a server message store.