sp_showcontrolinfo

Description

Displays information about engine group assignments, bound client applications, logins, and stored procedures.

Syntax

sp_showcontrolinfo [object_type, object_name, spid ]

Parameters

object_type

is AP for application, LG for login, PR for stored procedure, EG for engine group, or PS for process. If you do not specify an object_type or specify an object_type of null, sp_showcontrolinfo displays information about all types.

object_name

is the name of the application, login, stored procedure, or engine group. Do not specify an object_name if you specify PS as the object_type. If you do not specify an object_name (or specify an object_name of null), sp_showcontrolinfo displays information about all object names.

spid

is the Adaptive Server process ID. Specify an spid only if you specify PS as the object_type. If you do not specify an spid (or specify an spid of null), sp_showcontrolinfo displays information for all spids. Use sp_who to see spids.

Examples

Example 1

Shows all user-assigned execution class-to-object bindings:

sp_showcontrolinfo

Example 2

Displays the execution class of the isql application:

sp_showcontrolinfo 'AP', 'isql'

Example 3

Displays the execution class for all processes assigned to engine groups:

sp_showcontrolinfo 'PS'

Example 4

Displays the execution class for spid 7:

sp_showcontrolinfo 'PS', null, 7

Usage

• When used with no parameters, sp_showcontrolinfo displays information about all user-assigned engine group assignments, bound client applications, logins, and stored procedures. When used with the object_type parameter, sp_showcontrolinfo provides information on an individual basis about application, login, or stored procedure bindings to an execution class, engine group compositions, and session-level attribute bindings. See the Performance and Tuning Guide for more information.

• Unless object_type is PR, execute sp_showcontrolinfo from the master database. If object_type is PR, execute sp_showcontrolinfo from the database in which the procedure resides.

• If object_type is null, sp_showcontrolinfo displays execution class information for objects that match the other parameters.

• If object_name is null, sp_showcontrolinfo displays the binding information for all applications, logins, and stored procedures.

• If spid is null, sp_showcontrolinfo displays execution class information for objects that match the other parameters.

Permissions

Any user can execute sp_showcontrolinfo.

Auditing

Values in event and extrainfo columns from the sysaudits table are:

See also

System procedures sp_addexeclass, sp_bindexeclass, sp_clearpsexe, sp_dropengine, sp_dropexeclass, sp_showexeclass, sp_showpsexe, sp_unbindexeclass, sp_who

Utility isql

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF