verifydb Examples
This command cleans up all databases for which you are the DBA, removing all unrequired disk files, and logging all verifydb operations performed:
verifydb -mrun -sdba -opurge
This command runs in report mode, looking for expired tables in the database teach_examp:
verifydb -mreport -sdbname "teach_examp" -oexpired_purge
This command runs verifydb as the user fredk against all the databases for which fredk is the DBA, deleting temporary and expired tables:
verifydb -mrun -sdba -opurge -ufredk
This command drops references to the table new_benefits in the database new_employee:
verifydb -mrun -sdbname "new_employee" -odrop_table "new_benefits"
This command runs consistency checks on the DBMS catalogs for the iidbdb database. The command is run in report mode.
verifydb -mreport -sdbname "iidbdb" -odbms_catalogs
This command runs consistency checks on the DBMS catalogs for all databases that you own, with output going to the alternate log file checkdbs.log. The command is run in report mode.
verifydb -mreport -sdba -odbms_catalogs -lfcheckdbs.log
Last modified date: 01/30/2023