2553130 - SYB: How to caculate the max number of mailboxes will ASE use internally? | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2553130 - SYB: How to caculate the max number of mailboxes will ASE use internally?

Symptom

  • How to calculate the max number of mailboxes will ASE use internally?
  • Why "Num_active" of sp_monitorconfig "number of mailboxes" is greater than the configure value in sp_configure "number of mailboxes"?
    1> sp_monitorconfig 'number of mailbox'
    2> go
    Name                      Num_free    Num_active  Pct_act Max_Used    Reuse_cnt   Instance_Name

    ------------------------- ----------- ----------- ------- ----------- ----------- --------------

    number of mailboxes                 0          51 100.00           51           0 NULL

    (1 row affected)

    1> sp_configure "number of mailboxes"
    2> go
     Parameter Name                                                                                                                                                           
             Default     Memory Used
             Config Value                                                                                                                                                     
             Run Value                                                                                                                                                        
             Unit                 Type
     ----------------------------------------------------------------
             ----------- -----------
             --------------------------------------------------------
             --------------------------------------------------------
             -------------------- --------------------
     number of mailboxes                                                                                                                                                      
                      30           4
                       30                                                                                                                                                     
                       30                                                                                                                                                     
             number               dynamic

    (1 row affected)
    (return status = 0)

     


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

mailboxes, worker processes, sp_monitorconfig , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

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.