SAP Knowledge Base Article - Preview

2989308 - sp_poolconfig reporting error Msg 5899, Level 16, State 1 when reconfiguring data cache - SAP ASE

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

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP ERP 6.0

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.