Symptom
- 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>
- 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)
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.