At startup, the qdb utility tests the integrity of databases,
according to the -I option specified. It executes statements based
on this option's setting, as follows:
- none — don't perform a database integrity check.
- basic — verify only that qdb can parse a
string.
- partial — validate the PRAGMA database list. This is
equivalent to running the PRAGMA database_list; command.
- full — validate the database integrity. This is equivalent to
running the PRAGMA integrity_check; command.
Note: The more verification qdb performs at startup, the greater the
time needed for startup. For production environments, you need to find the optimal
balance between the amount of verification required and the time needed to start
qdb.
You can execute SQL statements on your QDB databases from the command line using the
qdbc utility.