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

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

SAP Adaptive Server Enterprise (SAP) 15.7 & 16.0

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