SAP Knowledge Base Article - Preview

3569236 - The dbcc checkstorage for very large database is not completing with COMPILING status - SAP ASE

Symptom

The dbcc checkstorage command for a very large database is not completing.
When checking the cmd field using sp_who, it shows as COMPILING.
Running dbcc stacktrace against the spid shows mem_freepages freeing memory for the procedure cache.

sp_who (extract):

  spid        kpid status       cmd
------ ----------- ------------ -----------
   123  1234567890 background   COMPILING

dbcc stacktrace:

Start dbcc stacktrace...
pc: 0x00000000016221bc upyield
pc: 0x000000000152f308 mem_freepages
pc: 0x0000000001ae17e4 free_mempage
pc: 0x0000000001ae1c3f free_memchunk
pc: 0x0000000001c50a80 s_chooselocks
pc: 0x0000000001c3f918 s_compile_stmt
pc: 0x0000000001c3a43f s_compile
...


Read more...

Environment

SAP Adaptive Server Enterprise 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

CR830358, CR#830358, 830358, COMPILING, mem_freepages, mempmctrl_free , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.