SAP Knowledge Base Article - Preview

2817648 - Msg 5861 when running sp_configure with options that do not require memory - SAP ASE

Symptom

  • Error 5861 is seen when running sp_configure with options like "allow updates" that do not require more memory when static config parameters like "global cache partitions" is set to a non-default value and the amount of free memory remaining is relatively small.

1> sp_configure 'allow update', 1
2> go
Msg 5861, Level 16, State 2:
Procedure 'sp_configure', Line 1372:
The current 'max memory' value '263150', is not sufficient to change the parameter 'allow updates to system tables' to '1'. 'max memory' should be greater than 'total logical memory' '272022' required for the configuration.
(return status = 1)


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE)
  • SAP Adaptive Server Enterprise Cluster Edition (ASE CE)

Product

SAP Adaptive Server Enterprise 12.5 ; SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 15.7 Cluster Edition ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise 16.0 Cluster Edition ; Sybase Adaptive Server Enterprise 12.5 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5 ; Sybase Adaptive Server Enterprise Cluster Edition 15.0 ; Sybase Adaptive Server Enterprise Cluster Edition 15.5 ; Sybase Adaptive Server Enterprise Cluster Edition 15.7

Keywords

Sybase, ASEServer, SAPASE, dataserver , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.