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

• 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

SAP Adaptive Server Enterprise (ASE) All Versions

scope , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem