Setting execution class attributes

Implement and manage execution hierarchy for client applications, logins, service tasks, and stored procedures using the categories of system procedures listed in Table 4-2.

Table 4-2: System procedures for managing execution object precedence

Category

Description

System procedures

User-defined execution class

Create and drop a user-defined class with custom attributes or change the attributes of an existing class.

  • sp_addexeclass

  • sp_dropexeclass

Execution class binding

Bind and unbind predefined or user-defined classes to client applications, service tasks, and logins.

  • sp_bindexeclass

  • sp_unbindexeclass

For the session only (“on the fly”)

Set and clear attributes of an active session only.

  • sp_setpsexe

  • sp_clearpsexe

Engines

Add engines to and drop engines from engine groups; create and drop engine groups.

  • sp_addengine

  • sp_dropengine

Reporting

Report on engine group assignments, application bindings, and execution class attributes.

  • sp_showcontrolinfo

  • sp_showexeclass

  • sp_showpsexe

See the Reference Manual: Procedures.