Invoking a Database Sweep Using the Services API

From InterBase
Jump to: navigation, search

You can invoke a database sweep with the cluster identifier isc_action_svc_repair. Sweeping attempts to scan the database for outdated record versions and mark them as free space. The following table lists arguments to isc_action_svc_repair to sweep a database:

Services API database sweep arguments
Argument Purpose Argument length Argument value

isc_spb_dbname

Path of the primary file of the database, from the server’s point of view

2 bytes + string

String

isc_spb_options

The following value is a bitmask of isc_spb_rpr_xxxx options below

4 bytes

Bitmask

isc_spb_rpr_sweep_db

Request database sweep to mark outdated records as free space; corresponds to gfix -sweep

Bit