Setting Up an Existing Database for Monitoring

You can use any SQL database provided that the existing version number of that database matches the version required by Unwired Platform.

Setting up the existing database requires some changes to the schema. Once setup, you can configure Unwired Platform to use this database.

  1. Use dbisql to run the SQL scripts that set up the monitoring schema. This utility is located in <UnwiredPlatform_InstallDir>\Servers\SQLAnywhereXX\BINXX.
    • 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.
    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 Configuring Monitoring Performance Properties in Sybase Control Center online help.
  4. Configure monitoring behavior accordingly.
Parent topic: Data Tier Administration Overview