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 SAP Mobile Platform.

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

  1. Use dbisql to run the SQL scripts that set up the monitoring schema. This utility is located in SMP_HOME\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 SMP_HOME\Servers\UnwiredServer\config.
  2. Create a new data source for the monitoring database in the default domain.
  3. In SAP Control Center, configure SAP Mobile Server to use this database instance. See Configuring Monitoring Performance Properties in SAP Control Center for SAP Mobile Platform.
  4. Configure monitoring behavior accordingly.
Parent topic: Data Tier Administration