SAP Knowledge Base Article - Preview

2024061 - A login bound to an execution class does not use the expected class - ASE

Symptom

  • A Login is bound to low priority EC3.

sp_bindexeclass tuser1, LG, 'all', EC3
go

(return status = 0)

  • Display of binding assignment agrees with the command entered.

 sp_showcontrolinf
 go

 type     object_name            scope      exec_class
         threadpool           spid     attribute
         attribute_value                instanceid
 -------- ---------------------- ---------- --------------------
         -------------------- -------- ------------------
         ------------------------------ --------------------
 LG       tuser1                 all        EC3
         NULL                 NULL     NULL
         NULL                                 NULL

  • The runtime view indicates the login 'tuser1' is using the 'isql' application but is using the medium priority EC2 execution class instead of EC3 as planned.

isql -Utuser1 -Pxxxx 

 sp_showpsexe 36
 go

 spid   appl_name                                                   
         login_name                                                 
         exec_class                                                 
         current_priority   
         task_affinity                                               
 ------ ------------------------------------------------------------
         ------------------------------------------------------------
         ------------------------------------------------------------
         --------------------
         ------------------------------------------------------------

     36 isql                                                        
         tuser1                                                      
         EC2                                                         
         MEDIUM              
         syb_default_pool


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) All Versions

Product

SAP Adaptive Server Enterprise all versions

Keywords

scope , 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 ONE Support launchpad (Login required).

Search for additional results

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