SAP Knowledge Base Article - Preview

2932504 - The sp_monitorconfig is not reporting the correct information for Max Used and Num Active for number of remote logins - SAP ASE

Symptom

  • The Max Used and Num Active has high value of "number of remote logins" configured.
  • Sometimes the Max Used and Num Active by pass the default value of "number of remote logins". For example:

Parameter "number of remote logins" is DEFAULT (20).

1> sp_monitorconfig "number of remote logins"
2> go
Usage information at date and time: May 12 2020  3:11AM.

Name                                Num_free    Num_active  Pct_act Max_Used    Reuse_cnt   Instance_Name
----------------------------------- ----------- ----------- ------- ----------- ----------- ------------------------------
number of remote logins                       0          60 100.00           60           0 NULL


Read more...

Environment

SAP Adaptive Server Enterprise 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

remote login, number of remote login, sp_monitorconfig, Max Used,  Num Active, wrong value, CR 821809 , 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 ONE Support launchpad (Login required).

Search for additional results

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