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 for Me (Login required).

Search for additional results

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