Reducing the Log Record Size

Use Sybase Control Center to delete log record entries by setting a date range window.

1. Clean up the client log data:
   1. Expand Domains > default > Packages.
   2. Select packageName then select the Client Log tab.
   3. Select Clean, then enter starting and ending dates.
      The LOGICAL_DEL flag is set to true for records within the range.

      Note: Allow time for clients to synchronize. Logically deleted records are retained until the client synchronizes and downloads the delete records that clean up the client database. The length of time to wait for synchronization to complete depends on the clients’ activities.
   4. Click OK to clean the client log data.
2. Clean the logically deleted records from Unwired Server:
   1. Select the General tab.
   2. Select Error Cleanup.
      This starts a cleanup task that asynchronously removes all logically deleted records from clients that have performed a synchronization after the time specified in the Clean operation.

      For example, if the Clean operation is performed at 1:00am on Feb 27, all clients that synchronize after that time have their records physically removed. As a result, it takes time to reduce the size of the log record table.

      Note: Clean up the client log data (step one) during periods of low client activity: when a single transaction processing a large log record table is active, client synchronization is blocked, degrading client responses and performance. As a best practice, once the log record table has been cleaned to a reasonable size, schedule the clean/error cleanup tasks on a daily basis.