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

Error 5861 is seen when running sp_configure with options like "allow update 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...

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

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

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