SAP Knowledge Base Article - Preview

2025063 - DBCC checkstorage hits error 9952 'scan workspace is too small' for very large database - SAP ASE

Symptom

  • When running dbcc checkstorage on a very large database, with size in TeraBytes (TB) range
  • Having settings as suggested by sp_dbcc_evaluatedb and sp_plan_dbcc procedures
  • The dbcc check will still fail with error 9952:

dbcc checkstorage (Very_Large_DB_name)
go
...
Checking Very_Large_test_DB: Logical pagesize is 4096 bytes
...
Msg 9952, Level 17, State 1:
Server 'ASE', Line 1:
Workspace 'scan_work_space' is too small to permit the CHECKSTORAGE operation to proceed.
Use sp_dbcc_alterws and sp_dbcc_updateconfig to correct the problem.
DBCC CHECKSTORAGE for database 'testdb' encountered an error. Some results may notbe available.
Correct the problems reported and reexecute the CHECKSTORAGE command.


Read more...

Environment

SAP Adaptive Server Enterprise (SAP) 15.7 & 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

DBCC Checkstorage, Msg 9952 , message 9952 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , Bug Filed

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.