Thanks, Lance -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Tuesday, March 17, 2020 9:49 AM To: [email protected] Subject: [RBASE-L] - Tip of the Day: Check Indexes with Enhanced AUTOCHK Command
CAUTION: This Email is sent from outside our organization. Please DO NOT Click on any links or open any attachments unless you recognize the sender. Please forward any Suspicious Email "as an attachment" to [email protected]<mailto:[email protected]> 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://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.rbase.com&data=02%7C01%7Clhannaw%40bronxleb.org%7C0752dd5515c14d94849f08d7ca79f560%7C4298a6c031114e0cb60c030ea7ab66ee%7C0%7C0%7C637200497489368528&sdata=cTCdtvckjEjgAVzuljtQeDMNG2afIyNN8qrzDI2ScBs%3D&reserved=0 https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.facebook.com%2Frbase%2F&data=02%7C01%7Clhannaw%40bronxleb.org%7C0752dd5515c14d94849f08d7ca79f560%7C4298a6c031114e0cb60c030ea7ab66ee%7C0%7C0%7C637200497489368528&sdata=SoDXDijirS7ZmaT%2FnI80w0F58gTbudFuwwm9IR7z6VY%3D&reserved=0 -- For group guidelines, visit https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.rbase.com%2Fsupport%2Fusersgroup_guidelines.php&data=02%7C01%7Clhannaw%40bronxleb.org%7C0752dd5515c14d94849f08d7ca79f560%7C4298a6c031114e0cb60c030ea7ab66ee%7C0%7C0%7C637200497489368528&sdata=VVojhvf%2BJN76Kqc5vfNPvOZ3egQ9pQpiX8%2FHPu%2FO3Ms%3D&reserved=0 --- 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://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fd%2Fmsgid%2Frbase-l%2F202003171349.02HDn2pc006174%2540atl4mhob22.registeredsite.com&data=02%7C01%7Clhannaw%40bronxleb.org%7C0752dd5515c14d94849f08d7ca79f560%7C4298a6c031114e0cb60c030ea7ab66ee%7C0%7C0%7C637200497489368528&sdata=q%2BSo4B7W1iSHDJJBA0AbOU9l%2FVwGjg%2BS%2BWnmjUDWuow%3D&reserved=0. CONFIDENTIALITY NOTICE: This communication and any attachments may contain confidential and/or privileged information for the use of the designated recipients named above. If you are not the intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify the sender immediately by email or telephone and destroy all copies of this communication and any attachments. -- 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/MN2PR11MB39010BFB1184F836D69D5BB7DFF60%40MN2PR11MB3901.namprd11.prod.outlook.com.
