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.
If you experience long shutdown times with data services for the Unwired Platform data tier, you need to unload and reload data the dbunload utility. This rebuilds your database and maintains a healthy data tier performance.
To avoid this issue, Sybase recommends that you perform this action every four or five months.
- Stop all runtime services (data tier and server nodes), including the cache database, the cluster database, and the messaging database, and synchronization services.
- Perform a full off-line backup of each, by copying the database and transaction log files to a secure location. See Backing Up SQL Anywhere Databases.
- Rebuild each runtime database with the SQL Anywhere Unload (dbunload) utility.
The dbunload utility is available in the UnwiredPlatform_InstallDir\Servers\SQLAnywhere11\BIN32 directory.
- Validate the data before restarting the services.