Product Documentation

SQL Operations Guide

Previous Topic

Next Topic

fc_get_lockstats()

Returns FairCom DB SQL current lock statistics.

Result Set Fields (2)

Description VARCHAR(64)

Value BIGINT

Example

>call fc_get_lockstats();


DESCRIPTION VALUE

----------- -----

count of lock attempts 249

subcount of hdr lock attempts 2

count of locks denied 0

count of locks blocked 0

subcount of header blocks 0

count of dead locks 0

count of locks freed 249

count of blocks released 0

current count of locks held 0

current count of blocked requests 0

cumulative lock wait time^ 0

cumulative lock wait count 0

maximum elapsed lock wait time^ 0

net locks over unlocks 0

max net locks over unlocks 1


15 records returned

TOCIndex