SAP Knowledge Base Article - Preview

2777278 - When re-configuring number of open databases with a large value using sp_configure, it raised error 5861

Symptom

  •  ASE server has enough available memory allocated.

1> sp_configure 'total%memory'
2> go
Msg 17411, Level 16, State 1:
Server 'ASEDR', Procedure 'sp_configure', Line 396:
Configuration option is not unique.

Parameter Name Default Memory Used Config Value Run Value Unit Type
--------------------- ----------- ------------- -------------- ------------ ---------------- ---------
total logical memory 159744 1108020 525546 554010 memory pages(2k) read-only
total physical memory 0 4499400 0 2249700 memory pages(2k) read-only

(1 row affected)
An additional 3391380 K bytes of memory is available for reconfiguration. This is the difference between 'max memory' and 'total logical memory'.
(return status = 1)
1>

 

  • sp_helpconfig estimates to be consumed 423004K of memory if configured at 700.

1> sp_helpconfig 'number of open databases', '700'
2> go

number of open databases sets the maximum number of databases that can be open at one time on ASE. The default run value is 12.

Minimum Value Maximum Value Default Value Current Value Memory Used Unit Type
--------------- --------------- --------------- --------------- ------------- ------ -------
6 2147483647 12 12 7602 number dynamic

Configuration parameter, 'number of open databases', will consume 423004K of memory if configured at 700.
Changing the value of 'number of open databases' to '700' increases the amount of memory ASE uses by 3423182 K.
(return status = 0)
1>

  • 1> sp_configure 'open databases', 700
    2> go
    Msg 5861, Level 16, State 2:
    Server 'ASEDR', Procedure 'sp_configure', Line 1345:
    The current 'max memory' value '2249700', is not sufficient to change the parameter 'number of open databases' to '700'. 'max memory' should be greater than 'total logical memory' '2265601' required
    for the configuration.
    (return status = 1)
    1>


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16 SP03 PL05

Keywords

CR#818945, CR 818945, 818945, error 5861, sp_configure , KBA , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.