SMC_NAME_LOCK_STATUS_CNT  SMC_NAME_LOCKS_BEING_BLOCKED_CNT

Chapter 2: Data Items and Statistical Types

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:

Version compatibility

11.0 and later

Data item type

Key

Server level

No

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




Copyright © 2005. Sybase Inc. All rights reserved. SMC_NAME_LOCKS_BEING_BLOCKED_CNT

View this book as PDF