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.

1. Use dbisql to run the SQL scripts that set up the monitoring schema. This utility is located in <UnwiredPlatform_InstallDir>\Servers\SQLAnywhere11\BIN32.
   • For SQL Anywhere databases:
     • init-monitoring-tables-asa.sql – sets up the SQL Anywhere database with a general monitoring schema.
     • ASA_MONITORING_DDL.sql – sets up the SQL Anywhere database with a cache monitoring schema.
   • For ASE databases:
     • init-monitoring-tables-ase.sql – sets up the Adaptive Server database with a general monitoring schema.
     • ASE_MONITORING_DDL.sql – sets up the Adaptive Server database with a cache monitoring schema.
   By default, these scripts are installed in <UnwiredPlatform_InstallDir>\Servers\UnwiredServer\config.
2. Create a new data source for the monitoring database in the default domain.
3. In Sybase Control Center, configure Unwired Server to use this database instance. See Sybase Control Center > Monitor > Monitoring Unwired Platform > Monitoring Configuration > Configuring Monitoring Performance Properties
4. Configure monitoring behavior accordingly.