At startup, the
qdb utility tests the integrity of databases, according to the
-I
option specified. The actions performed depend 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 longer the time needed for startup.
For production environments, you must 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 by using the
qdbc command-line utility.