SMC_NAME_LOCK_RESULT_SUMMARY  SMC_NAME_LOCK_STATUS_CNT

Chapter 2: Data Items and Statistical Types

SMC_NAME_LOCK_STATUS

Description

Reports the current status of a lock. The lock status values are:

Version compatibility

11.0 and later

Data item type

Key

Server level

No

Result data items that require this key

SMC_NAME_BLOCKING_SPID

SMC_NAME_DEMAND_LOCK

SMC_NAME_LOCK_STATUS_CNT

SMC_NAME_LOCKS_BEING_BLOCKED_CNT

SMC_NAME_TIME_WAITED_ON_LOCK

Result data items for which this key is optional

None

Statistic types and datatypes

VALUE_ SAMPLE

VALUE_ SESSION

RATE_ SAMPLE

RATE_ SESSION

AVG_ SAMPLE

AVG_ SESSION

ENUMS

Enum

SMC_LOCK_STATUS




Copyright © 2001. Sybase Inc. All rights reserved. SMC_NAME_LOCK_STATUS_CNT

View this book as PDF