Data Tier

Setting up a database is only required when you are not installing a new consolidated database (CDB) or monitoring database in your production environment.

There are three scenarios that Unwired Platform supports:

Use only what is installed with the Unwired Platform installer – This is the simplest and recommended scenario; no additional setup is required. You can begin using the databases immediately.
Use an existing SQL Anywhere installation, but create new database files based on Sybase specifications – This requires that you use a combination of dbinit to initialize the new CDB correctly, and batch scripts that setup the schema for the monitoring database.
Use an existing SQL Anywhere installation, but use existing database instance – Can be the most risky implementation and of the three is the least recommended option. You must still use the batch scripts to setup the monitoring database schemas; for the CDB, you must use RTRIM to avoid getting incorrectly formatted data on the device. See the SQL Anywhere documentation about using the RTRIM function.

Deploying the CDB
Take care when deploying the consolidated database (CDB) in a production environment. The CDB must be installed and configured in such a way as to avoid any adverse impacts on performance. Depending on whether you are using the installed CDB, using an existing one, or initializing a new database file separate from the installer, perform the corresponding task accordingly.
Deploying the Monitoring Database
You can use the installed database or an existing database as the monitoring database. Irrespective of which type of database you deploy, you want to set it up in a way that avoids unduly impacting runtime performance of the system.

Parent topic: Component Deployment