At startup, qdb tests the integrity of databases, according to the
-I option specified. It will execute 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 command PRAGMA database_list;.
- full — validate the database integrity. This is equivalent to running the command PRAGMA integrity_check;.
Note:
The more verification qdb performs at startup, the greater the time needed for startup. For production environments, you will 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. See qdbc for more information.