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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.