SAP Knowledge Base Article - Preview

2436199 - max_used 'number of open databases' cannot be increased on HA system - SAP ASE

Symptom

  • Config option 'number of open database' cannot be reconfigured dynamically on High Availability (HA) system
  • ASE cannot increase additional 6 DB tables
  • (1) Before increasing "number of open databases".
        (Note: ASE reserves 2 DBTABLEs for failover, so ASE can use up to 10 if "number of open databases" is 12.)
    1> sp_monitorconfig "number of open databases"
    2> go
    Usage information at date and time: Sep 11 2014  2:54PM.

    Name                      Num_free    Num_active  Pct_act Max_Used    Reuse_cnt   Instance_Name
    ------------------------- ----------- ----------- ------- ----------- ----------- ------------------------------
    number of open databases            2          10  83.33           10          13 NULL

    (1 row affected)

    (return status = 0)
  • (2) Increase "number of open databases" from 12 to 18.

    1> sp_configure "number of open databases", 18
    2> go
    Parameter Name                 Default              Memory Used Config Value         Run Value            Unit                 Type
    ------------------------------ -------------------- ----------- -------------------- -------------------- -------------------- --------------------
    number of open databases                12                 9522           18                   18         number               dynamic

    (1 row affected)
    Configuration option changed. ASE need not be rebooted since the option is dynamic.
    Changing the value of 'number of open databases' to '18' increases the amount of memory ASE uses by 3032 K.
    (return status = 0)
  • 1> sp_monitorconfig "number of open databases"
    2> go
    Usage information at date and time: Sep 11 2014  2:57PM.

    Name                      Num_free    Num_active  Pct_act Max_Used    Reuse_cnt   Instance_Name
    ------------------------- ----------- ----------- ------- ----------- ----------- ------------------------------
    number of open databases            8          10  55.56           10          21 NULL

    (1 row affected)
    (return status = 0)

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE)
  • Dataserver
  • Solaris on x86_64 64bit
  • Solaris on Sparc 64bit

Keywords

High Availability (HA), number of open databases, increase, max_used, num_active, additional, dbtables, CR770449, CR#770449, 770449 , 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.