SAP Knowledge Base Article - Preview

2748384 - sp_configure: Incorrect Memory Used values with a '#' sign or as '#1' for large configuration settings - SAP ASE 16.0

Symptom

  • sp_configure shows incorrect 'Memory Used' values with a '#' sign or as '#1' for large configuration values of memory related parameters. 
  • For example:
     
    1> sp_configure 'max memory', 0, '2048G' 

    2> go
    Parameter Name                   Default                Memory Used                Config Value                 Run Value                Unit                             Type          
    -------------------------------- ---------------------- -------------------------- ---------------------------- ------------------------ -------------------------------- --------------
    max memory                            180224            #2147483648                  1073741824                   1073741824             memory pages(2k)                 dynamic
     
    1> sp_configure 'procedure cache',0,'3600G'

    2> go
    Parameter Name                   Default                Memory Used                Config Value                 Run Value                Unit                             Type          
    -------------------------------- ---------------------- -------------------------- ---------------------------- ------------------------ -------------------------------- --------------
    procedure cache size                   14000                            #1                  1887436800                   1887436800             memory pages(2k)                  dynamic


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

CR813224, CR#813224, 813224, syscurconfigs, memory_used, overflow , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.