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

execution class, login binding, scope definition, application name, client application, stored procedure owner, execution attributes, threadpool, spid, runtime view, binding assignment, execution priority, EC3, EC2, scope , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem