Data Cache Maintenance Enhancements

Clean up accumulated data artifacts related to the consolidated database. Some cleanup options can be automated at the domain level, others are performed manually. The Administration API enables you to extend functionality.

Domain-Level Cleanup Options
Option	Description
Subscription Cleanup	Removes subscriptions that are no longer referenced by any active users. Replication-based synchronization – removes subscriptions not used since the last synchronization. Message-based synchronization – removes subscriptions if Unwired Server has not processed a message since the given date.
Online Cache Cleanup	Removes mobile business objects (MBOs) from cache groups that use the Online cache policy.
Error History Cleanup	Removes historical data on MBO data refresh and operation replay failures, which result from system or application failures.
Client Log Cleanup	Removes client log records that have already been synchronized to the device or are no longer associated with active users.
Synchronization Cache Cleanup	Removes, from the cache, logically deleted rows that are older than the oldest synchronization time on record in the system, and unused or stale partitions.

Note: You can manually perform clean up for these options at the package level: Online Cache, Synchronization Cache, Error History, and Client Log.

Cluster-Level Manual Cleanup Options
Option	Description
Devices	Removes devices not used since a given date. This cleanup purges device-associated items, such as subscriptions.
Device Users	Removes device users associated with a given security configuration, and any user-specific data not used since the specified number of days. If a security configuration is removed, it forces the cleanup of any users registered with that security configuration. The user-specific data is removed from the consolidated database.

Documented in:

System Administration – search for:
- Data Maintenance Cleanup
Sybase Control Center for Sybase Unwired Platform – search for:
- Scheduling Domain-Level Cleanup
- Purging Error Log History Manually
- Purging Online Cache Manually
- Purging Client Log Manually
- Purging RBS Package Subscriptions Manually
- Purging MBS Package Subscriptions Manually
- Purging Unused Devices
- Purging Unused Device Users
Reference: Administration APIs – search for:
- Retrieve Scheduled Purge Task Status
- Enable Scheduled Purge Tasks
- Get Purge Task Schedule
- Set Purge Task Schedule
- Purge Synchronization Cache
- Purge Client Log
- Purge Error History
- Purge Online Cache
- Purge Subscription
- Purge RBS and MBS Subscriptions
- Purge Synchronization Cache
- Purge Error History
- Purge Online Cache
- Purge Subscription
- Purge Unused Devices
- Purge Unused Users