SAP Knowledge Base Article - Preview

2180888 - DBCC verify reporting dropleaks even after fixing with dropleaks database - SAP IQ

Symptom

DBCC verify reporting dropleaks even after fixing with dropleaks database


I. 03/17 16:53:00. 0000001228 Disconnect:  SA connHandle: 1000001226  SA connID: 18  IQ connID: 0000001228  User: dbo
I. 03/17 16:53:59. 0000000033 DBCC - 84708 leaked blocks
I. 03/17 16:53:59. 0000000033 DBCC Check Mode Report:   
I. 03/17 16:53:59. 0000000033 ** DBCC Status: Errors Detected  ******
I. 03/17 16:53:59. 0000000033  :   
I. 03/17 16:53:59. 0000000033 Index Summary:   
I. 03/17 16:53:59. 0000000033    Verified Index Count: 39299 
I. 03/17 16:53:59. 0000000033  :   
I. 03/17 16:53:59. 0000000033 Allocation Summary:   
I. 03/17 16:53:59. 0000000033    Blocks Total: 14095360 
I. 03/17 16:53:59. 0000000033    Blocks in Current Version: 4923357 
I. 03/17 16:53:59. 0000000033    Blocks in All Versions: 4923357 
I. 03/17 16:53:59. 0000000033    Blocks in Use: 5008065 
I. 03/17 16:53:59. 0000000033    % Blocks in Use: 34 
I. 03/17 16:53:59. 0000000033 ** Block Count Mismatch: -84708  ******
I. 03/17 16:53:59. 0000000033 ** Blocks Leaked: 84708  ******
I. 03/17 16:53:59. 0000000033  :   
I. 03/17 16:53:59. 0000000033 Allocation Statistics:   
I. 03/17 16:53:59. 0000000033    DB Extent Count: 12 
I. 03/17 16:53:59. 0000000033    Marked Logical Blocks: 16214048 
I. 03/17 16:53:59. 0000000033    Marked Physical Blocks: 4923357 
I. 03/17 16:53:59. 0000000033    Marked Pages: 1013378 
I. 03/17 16:53:59. 0000000033    Blocks in Freelist: 13912384 
I. 03/17 16:53:59. 0000000033    Imaginary Blocks: 8904319 
I. 03/17 16:53:59. 0000000033    Highest PBN in Use: 22082208


Read more...

Environment

SAP IQ 16.x

Product

SAP IQ 16.0

Keywords

CR711476 dropleaks verify , 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.