db_check
Use this command to check the complete database structure on the basis of a data snapshot and clean up the data area.
The system checks the following:
-
Tables
-
Indexes
-
LOBs
-
History pages
Using the results of this check, the system removes unused pages and LOBs that are not referenced from the data area.
-
The database is in the ONLINE operational state.
-
You have the server permission AccessSQL or AccessUtility.
db_check data snapshot [ID <snapshot_id>]
db_check data snapshot: The system creates a data snapshot of the data area and carries out the database structure check on this snapshot. This snapshot is automatically deleted by the system after the database structure check is finished.
db_check data snapshot ID <snapshot_id>: The system carries out the database structure check on the identified data snapshot.
|
Option |
Description |
|---|---|
|
<snapshot_id> |
ID of the snapshot to be checked |
OK
<pages_used>
<blocks_released>
|
Value |
Description |
|---|---|
|
<pages_used> |
Number of pages used by the database system |
|
<blocks_released> |
Number of unused pages and LOBs that are not referenced from the data area and therefore removed by the system |
In the event of errors, see Reply Format.
Database Administration, Checking Database Structures