Validating a Database (Performing Database Maintenance)

From InterBase
Jump to: navigation, search

Go Up to Performing Database Maintenance


Use the Options property of TIBValidationService component to invoke a database validation. Set any of the following options of type TValidateOption to <True> to perform the appropriate validation:

TIBValidationService options
Option Meaning

LimboTransactions

Returns limbo transaction information, including:

  • Transaction ID
  • Host site
  • Remote site
  • Remote database path
  • Transaction state
  • Suggested transaction action
  • Transaction action
  • Multiple database information

CheckDB

Request a read-only validation of the database without correcting any problems

IgnoreChecksum

Ignore all checksum errors when validating or sweeping

KillShadows

Remove references to unavailable shadow files

MendDB

Mark corrupted records as unavailable so that subsequent operations skip them

SweepDB

Request database sweep to mark outdated records as free space

ValidateDB

Locate and release pages that are allocated but unassigned to any data structures

ValidateFull

Check record and page structures, releasing unassigned record fragments; use with ValidateDB

To set these options in code, use the Options property:

Options := [CheckDB, IgnoreChecksum, KillShadows];
Note: Not all combinations of validation options work together. For example, you could not simultaneously mend and validate the database at the same time. Conversely, some options are intended to be used with other options, such as IgnoreChecksum with SweepDB or ValidateDB, or ValidateFull with ValidateDB.

To use the LimboTransactions option, see the following section.

Advance To: