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.

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\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 Configuring Monitoring Performance Properties in Sybase Control Center online help.
  4. Configure monitoring behavior accordingly.
Parent topic: Deploying the Monitoring Database
Related tasks
Isolating the Monitoring Database
Changing the Default Monitoring Port