Symptom
Sometimes sp_iqcheckdb 'verify database' can list the following error related to Extra/missing/Duplicate Index RIDs:
** Extra Index RIDs 57
If all inconsistent indexes in DBCC report were fixed and an error does not show anymore, than it has been fixed also. But, when all other errors listed in sp_iqcheckdb report have been fixed and DBCC 'verify database' does not show any other errors, but it becomes more difficult to figure out which object(s) row ID list has a mismatch.
** Extra Index RIDs
================================================== ==============================
DBCC Verify Mode Report
================================================== ==============================
** DBCC Status Errors Detected
================================================== ==============================
Index Summary
================================================== ==============================
Verified Index Count 8910 <------- No errors
================================================== ==============================
Allocation Summary
Verified Index xxxxxxxxxxxxxxxxxxxxx.ASIQ_IDX_T776_C4_FP
Verified Index xxxxxxxxxxxxxxxxxxxxx.adCreativeCode_HG
....................................
....................................
Verified Index xxxxxxxxx.ASIQ_IDX_T1361_C13_FP
Verified Index xxxxxxxxx.ASIQ_IDX_T1361_C17_FP
Verified Index xxxxxxxxx.ASIQ_IDX_T1361_C20_FP
Verified Index xxxxxxxxx.ASIQ_IDX_T1361_C24_FP
** Extra Index RIDs 57
FP Indexes Checked 5932
HNG Indexes Checked 103
LF Indexes Checked 963
HG Indexes Checked 1470
WD Index Count 44
DATE Indexes Checked 190
TIME Indexes Checked 10
DTTM Indexes Checked 198
================================================== ==============================
Container Statistics
================================================== ==============================
.......................
.......................
Read more...
Environment
- SAP IQ 15.x
- SAP IQ 16.0
Product
Keywords
Missing Index RIDs, Duplicate Index RIDs, row ID, RID, Extra Index RIDs , KBA , BC-SYB-IQ , Sybase IQ , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.