Tuesday, March 17, 2020
Tip of the Day: Check Indexes with Enhanced AUTOCHK Command
Product.......: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.........: 10.5.2.20312 or higher
Sections......: Commands
Keywords......: AUTOCHK, Index, Check, Integrity
Did you know database indexes may now be checked with the AUTOCHK command?
The AUTOCHK command was enhanced to check all database indexes, or to check
a specific index by name. The database must be connected in order to check
indexes.
AUTOCHK INDEX
Specifies to have all the indexes checked.
AUTOCHK INDEX indexname
Specifies an index to check, which is displayed with the LIST INDEX command.
The process reviews each index (file 3) and walks through every pointer to
the data file (file 2). An error is reported if:
. The pointer from the index does not point to a valid location in the 2 file
. The pointer from the index points to a valid location in the 2 file, but
the row that lives there has been deleted
. The row count from walking the entire index does not match the row count
for the table as stored in file 1
Four additional error messages were added for routines to capture and act
accordingly.
1609 - Index rows counted: <value1>, expected count: <value2>
1610 - The index points to an invalid row location
1611 - The index points to a row that has been deleted
1612 - The index cannot be examined
Very Best R:egards,
Razzak.
https://www.rbase.com
http://www.facebook.com/rbase/
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/202003171349.02HDn2pc006174%40atl4mhob22.registeredsite.com.
