Symptom
The total number of 'Num_free' and 'Num_active' from sp_monitorconfig 'max cis remote connection' is larger than the 'Config Value' from sp_configure 'max cis remote connection'.
1> sp_configure 'max cis remote connection'
2> go
Parameter Name Default Memory Used Config Value Run Value Unit Type
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- ----------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------- --------------------
max cis remote connections 0 80 1 1 number dynamic
(1 row affected)
(return status = 0)
1> sp_monitorconfig 'max cis remote connection'
2> go
Name Num_free Num_active Pct_act Max_Used Reuse_cnt Instance_Name
------------------------- ----------- ----------- ------- ----------- ----------- ------------------------------
max cis remote connection 0 3 100.00 3 0 NULL
(1 row affected)
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7
- SAP Adaptive Server Enterprise (ASE) 16.0
Product
Keywords
max cis remote connection, sp_configure, sp_monitorconfig , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.