Run a database cleaner script daily on M-Business Server.

This script locks database tables; users will experience a delay in their synchronizations and wireless requests until the script completes. For this reason, run the script at a time of low utilization, such as 3:00 a.m. local time. If you are not familiar with the Windows Scheduled Task functionality, see the Microsoft help for Scheduled Tasks.

To run a database cleaner script

1. Open a command line window.

   Windows: Choose Start » Programs » Command Prompt.

   UNIX: Open a UNIX shell window .

2. Change to the <M-Business_Home>/conf directory.

3. Enter:

   agdbDefrag

   This command runs the agdbDefrag script (agdbDefrag.bat in Windows, agdbDefrag in UNIX), which cleans the SSLSESSION.

   Tip

   You can defragment the entire database, if it is feasible to have the M-Business Sync and Admin servers offline for a short time. For more information, see the SQL Anywhere User's Guide.