NAME

sfsadmin query filelock - displays information about the locks held on a file

SYNOPSIS

sfsadmin query filelock -server servername filename

-server servername Specifies the name of the file server. The name must be registered with the DCE Directory Service. If the -server option is not specified, the default is the server defined by the environment variable ENCINA_SFS_SERVER. 

filename Specifies the name of the file for which lock information is requested. 

DESCRIPTION

The sfsadmin query filelock command displays detailed information about file- and record-level locks held by each OFD opened on the specified file. 

EXAMPLE

In the following example, several OFDs are accessing the file Inventory in shared mode. The output shows the number and type of locks held by each OFD. 

% sfsadmin query filelock Inventory

Lockers of file: Inventory
ofd id: 1
    transaction id:  18
    openTid:   14
    open lock mode:  shared access
    file locks:
        Lock 1:
            lock mode:   intention read lock
            consistency: transactional
            transaction id: 18
    record locks:
        lock 1:
            lock mode:   read lock
            consistency: transactional
            index:       primary
            transaction id: 18
            key value:
                     3030 3035                   0005
ofd id: 2
    transaction id: 0
    openTid: 39
    open lock mode:  shared access
    file locks:
        lock 1:
            lock mode:   read lock
            consistency: nontransactional
            transaction id: 39
    record locks:
 No locks
ofd id: 3
    transaction id: 0
    openTid: 57
    open lock mode:  shared access
    file locks:
        lock 1:
            lock mode:   intention read lock
            consistency: nontransactional
            transaction id: 57
    record locks:
        lock 1:
            lock mode:   read lock
            consistency: nontransactional
            index:       primary
            transaction id: 57
            key value:
                     3030 3034                   0004

OUTPUT

The following list explains the output of the sfsadmin query filelock command:

Ofd id is the identification number used by the server for the OFD. 

Transaction id refers to the identification number of the transaction associated with the OFD, if the OFD is transactional. If it is nontransactional, this identification number is zero. 

OpenTid is the identification number of the transaction that holds the open access mode lock (shared/exclusive). 

Open lock mode can be either shared or exclusive. A shared access mode allows more than one application to obtain access to a file at the same time. An exclusive access mode allows only one application to obtain access to a file at a time. 

For each file lock, the output lists the lock by number (beginning with 1), and provides the following information. If there are no file locks, the output indicates “no locks.”

Lock mode is the type of lock that the transaction holds - for example, read lock or write lock. 

Consistency refers to the type of consistency for the OFD. 

Transaction id refers to the identification number of the transaction against which the lock is held. 

For each record lock, the output lists the lock by number (beginning with 1), and provides the following information. If there are no record locks, the output indicates “no locks.”

Lock mode is the type of lock that the transaction holds - for example, read lock or write lock. 

Consistency refers to the type of consistency for the OFD. 

Index is the name of the index used to locate the record. The value for this field is either “primary” or the name of the secondary index. 

Transaction id refers to the identification number of the transaction against which the lock is held. 

Key value is the value that is locked, represented in raw hexadecimal and in ASCII. 

PRIVILEGE REQUIRED

Encina SFS query (Q) permission on the server

RELATED INFORMATION

sfsadmin query tranlock

sfsadmin terminate ofd

tkadmin abort transaction

tkadmin force transaction

tkadmin list transactions

  —  March 1997