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.
SAP Knowledge Base Article - Preview