Database Setup

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.

Initializing a New Consolidated Database
If you are experiencing incorrect string comparisons, you may need to initialize a new database to ensure that comparisons occur correctly. Incorrect string comparisons only occur when you either use a SQL Anywhere database that has not been installed and set up with the Unwired Platform installer.
Setting Up an Existing Database for Monitoring
You can use any SQL database provided that the existing version number of that existing database matches the version required by Unwired Platform.
Changing the Consolidated Database Server Thread Count and Pool Size
You can change the consolidated database (CDB) server thread count and maximum pool size as required. The procedure for this varies depending on the type of environment the CDB server is deployed to.

Parent topic: Environment Setup