Validating a Database (Performing Database Maintenance)

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:

• Displaying Limbo Transaction Information