Getting information about execution classes

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.