Symptom
- When running sp_poolconfig to resize a 128K memory pool within a data cache the following error is reported:
1> exec sp_poolconfig 'default data cache', '7G', '128K'
2> go
Msg 5899, Level 16, State 1:
Server '<server_name>', Procedure 'sp_do_poolconfig', Line 1192:
The value of the 'max memory' parameter (24157498) defined in the configuration file is not high enough to set the other parameter values specified in the configuration file.
(return status = 1)
- Pool config for "default data cache" configuration:
1> sp_poolconfig "default data cache"
2> go
Cache Name Status Type Config Value Run Value
------------------ -------- -------- -------------- ------------
default data cache Active Default 29696.00 Mb 29696.00 Mb
(1 row affected)
------------ ------------
Total 29696.0 Mb 29696.0 Mb
==========================================================================
Cache: default data cache, Status: Active, Type: Default
Config Size: 29696.00 Mb, Run Size: 29696.00 Mb
Config Replacement: strict LRU, Run Replacement: strict LRU
Config Partition: 16, Run Partition: 16
IO Size Wash Size Config Size Run Size APF Percent
-------- ------------- ------------ ------------ -----------
16 Kb 5242880 Kb 19456.00 Mb 19456.00 Mb 50
128 Kb 5242880 Kb 10240.00 Mb 10240.00 Mb 50
(return status = 0)
1>
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
- SAP NetWeaver (NW) - All versions
- SAP Adaptive Server Enterprise (ASE)
Product
Keywords
Msg 5899, sp_poolconfig, 'max memory', enough, configuration file, dynamic allocation on demand , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.
SAP Knowledge Base Article - Preview