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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.