Disabling Automatic Sweeping

Go Up to Sweep Interval and Automated Housekeeping

To disable automatic sweeping, set the sweep threshold to zero (0). Disabling automatic sweeping is useful if:

• Maximum throughput is important. Transactions are never delayed by sweeping.
• You want to schedule sweeping at specific times. You can manually sweep the database at any time. It is common to schedule sweeps at a time of least activity on the database server, to avoid competing for resources with clients.

To disable automatic sweeping with IBConsole, refer to Setting Database Properties.

Advance To:

• Performing an Immediate Database Sweep