SAP Knowledge Base Article - Preview

3236329 - Error 10865 when adding memory to a cache - SAP ASE


When trying to add memory to default data cache:


1> sp_cacheconfig "default data cache", "20G"
2> go
Msg 10865, Level 17, State 2:
Server 'XXXXXXXXX', Procedure 'sp_cacheconfig', Line 2053:
Unable to add memory to the cache (default data cache) as it is too fragmented. Changes will take effect when the server is rebooted. To add memory in the same instance delete the cache and recreate the cache with the required memory.
(return status = 1)


Restart of server has not helped.



  • SAP Adaptive Server Enterprise 16.0 SP03


SAP Adaptive Server Enterprise 16.0


sp_cacheconfig 10865 Unable to add memory to the cache default data cache fragmented server rebooted delete the cache recreate the cache required memory shmall , 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.