SMC_NAME_LOCK_TYPE

Description

Reports the type of lock used by Adaptive Server. Adaptive Server protects tables or data pages being used by active transactions by locking them. Adaptive Server uses the following lock types:

Exclusive table
Shared table
Exclusive intent
Shared intent
Exclusive page
Shared page
Update Page

Version compatibility

11.0 and later

Data item type

Key

Server level

Result data items that require this key

None

Result data items for which this key is optional

SMC_NAME_BLOCKING_SPID

SMC_NAME_DEMAND_LOCK

SMC_NAME_LOCK_CNT

SMC_NAME_LOCKS_BEING_BLOCKED_CNT

SMC_NAME_TIME_WAITED_ON_LOCK

Statistic types and datatypes

VALUE_ SAMPLE	VALUE_ SESSION	RATE_ SAMPLE	RATE_ SESSION	AVG_ SAMPLE	AVG_ SESSION
ENUMS

Enum

SMC_LOCK_TYPE