Scheduling Cleanup Options

The Sybase Unwired Platform administrator or Sybase Unwired Platform domain administrator schedules domain-level data maintenance cleanup.

Set up an automatic schedule for database cleanup:

  1. In the left pane, select the cluster, then the domain.
  2. In the right pane, select the Scheduled Tasks tab.
  3. Select one of the cleanup options:
    Option Description
    Subscription Cleanup
    Removes subscriptions that are not active for the 'number of inactive days' in the schedule task configuration. Note, subscription is considered active as follows:
    • Replication – last synchronization request timestamp.
    • Messaging – last synchronization message timestamp.
    Note: If a casual user accesses the system infrequently, for example three to four times a year, the user falls outside the specified time frame and is removed from Sybase Unwired Platform. The user will then have to reinstall Sybase Unwired Platform and initiate a sync to re-activate subscription.
    Error History Cleanup Removes historical data on MBO data refresh and operation replay failures, which result from system or application failures. System failures may include network problems, credential issues, and back-end system failure. Application failures may include invalid values, and nonunique data.
    Note: Only error messages are removed.
    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 This cleanup task removes:
    • Logically deleted rows in the cache that are older than the oldest synchronization time on record in the system. Synchronization activity for all clients establish the oldest synchronization time.
    • Unused or stale partitions.
    • Expired DCN entries identified by the exp property in the DCN message.
  4. Click Properties, then in the Task Properties dialog, select the Schedule tab.
  5. Configure the required schedule:
    • Schedule repeat – select how often the schedule should run. Options are monthly, weekly, daily, hourly, and custom.
      • If you select monthly or weekly, specify:
        • Start date – select the date and time the automated upload should begin. Use the calendar picker and 24-hour time selector.
        • End date – select the date and time the automated upload should end.
      • If you select daily or hourly, specify:
        • Start date – select the date and time the automated upload should begin. Use the calendar picker and 24-hour time selector.
        • End date – select the date and time the automated upload should end.
        • Days of the week – select each day the automated upload schedule should run.
      • Select custom, to specify the interval granularity in seconds, minutes, or hours, as well as other date and time parameters.
  6. In the Task Properties dialog, select the Options tab, set the number of inactive days for which to purge.
    Note: This step is unnecessary for Synchronization Cache Cleanup.
  7. Click OK to save the schedule properties and purge options.
    Note: If a casual user accesses the system infrequently, for example three to four times a year, the user falls outside the purging time frame and is removed from Sybase Unwired Platform. The user will then have to reinstall Sybase Unwired Platform and initiate a sync.