SAP Knowledge Base Article - Preview

2400202 - DBCC have reported inconsistent HG or WD index verify errors but actually there's no issue - SAP IQ 16.SP11

Symptom

Under heavy load, IQ DBCC may report inconsistent HG or WD index verify error

 

sp_iqcheckdb Passed in 16.0 Sp08 and Sp09 .

         I. 10/20 04:30:23. 0000004358 ** DBCC Status: Errors Detected  ******
         I. 10/20 04:30:23. 0000004358 ** Inconsistent Index Count: 2  ******
         I. 10/20 04:30:23. 0000004358 ** Block Count Mismatch: -10  ******
         I. 10/20 04:30:23. 0000004358 ** Blocks Leaked: 10  ******
         I. 10/20 04:30:23. 0000004358 ** 1st Unowned PBN: 330735793  ******
         I. 10/20 04:30:23. 0000004358 ** Inconsistent Index: DBA.bench.WD_K500Mc  ******
         I. 10/20 04:30:23. 0000004358 ** Inconsistent Index: DBA.bench.WD_K500Mv  ******
         I. 10/20 04:30:23. 0000004358 ** Extra Index RIDs: 2369249438  ******
         I. 10/20 04:30:23. 0000004358 ** HG Extra Groups: 2400  ******
         I. 10/20 04:30:23. 0000004358 ** HG Extra Keys: 2400  ******
         I. 10/20 04:30:23. 0000004358 ** B-Tree Entry Count Errors: 2  ******

  Test runs fail in 16.0 Sp10 and Sp11 (mainline) but Passed in 16.0 Sp08 and Sp09 .


Read more...

Environment

SAP Sybase IQ16 SP11

Product

SAP IQ 16.0

Keywords

CR791281, 791281, CR#791281,  , 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.