Adaptive Server stores the information about execution class assignments in the system tables sysattributes and sysprocesses, and supports several system procedures for determining what assignments have been made.
Use sp_showcontrolinfo to display information about the execution objects bound to execution classes, the Adaptive Server engines in an engine group, and session-level attribute bindings. If you do not specify parameters, sp_showcontrolinfo displays the complete set of bindings and the composition of all engine groups.
sp_showexeclass displays the attribute values of an execution class or all execution classes.
You can also use sp_showpsexe to see the attributes of all running processes.