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 for Me (Login required).

Search for additional results

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