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
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.