Data Tier Administration

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

If you need to change the password for the DBA user, see either Changing DBA Passwords for SQLAnywhere Databases in a Single Node Installation or Changing DBA Passwords for SQLAnywhere Databases in a Cluster Deployment in Security .

• 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 Thread Count and User 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
  Sybase recommends that you always use the default database log path location for Unwired Platform databases. However, the database log path can be changed.
• Cache Database and Timezones
  All nodes in a cluster must run with the same timezone setting.
• 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.
• 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.
• Data Tier Connection Pooling
  
• 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.