Data Tier Administration

If you need to administer components that make up the data tier, review the tasks you can perform.

• Changing Database Ports for SQLAnywhere Databases
  By default, ports are configured when you install the data tier. You can change values for any SQLAnywhere database deployed as part of the data tier.
• Changing SQLAnywhere Database Server Startup Options
  Change the database server startup options (thread counts and user options) to control the performance of a SQLAnywhere database server.
• Using a Different Database Log Path
  SAP recommends that you always use the default database log path location for SAP Mobile Platform databases. However, the database log path can be changed.
• 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.
• Isolating the Monitoring and Domain Logging Databases from Cache and Messaging Databases
  Install a new data tier node and configure the connection details to it.
• Managing Connection Pools for SAP Mobile Server Connections
  Connection pools are used by SAP Mobile Server to improve performance between the server and internal databases, which include the cache database, domain log database, messaging database, monitor database and sample database. These values are synchronized among all servers in the cluster when the primary server values change.
• Rebuilding Platform Databases
  Platform databases need to be rebuilt regularly. Without regular maintenance, the database log can grow to be large (several gigabytes in size), and performance could degrade.
• Control Transaction Log Size
  Control the size of transaction logs to prevent the log files from growing indefinitely.