ltest, dumplock - Lock Status Display


ltest database
dumplock database

The programs ltest and dumplock allow one to see the current state of the locks on database. ltest displays a single screen full of information which is updated periodically. dumplock produces a more verbose snapshot.

The information ltest displays is explained below. On the first line is the version of Texis, the semaphore being used for this database, how many usable locks are available, and the current system time. The second line contains the number of connections to the database. Following that is a number of lines containing information about the servers connected to the database. The three columns are server id, process id and state. Ltest identifies itself in this list. Following the connection information is more detailed information for each table being locked. The more detailed information consists of the name of the table, and it's state.

The state consists of a list of letters, one for each lock associated with the table. Upper case letters signify granted locks, and lower case letters show locks that have not been granted. The meaning of each letter is as follows.

f A lock for which no type has been specified yet.
R A table read lock.
W A table write lock.
I An index read lock.
X An index write lock.

Ltest will recognize the following keys, and perform the specified action.

0-9 Sets the update interval to the number of seconds specified.
+ See the next column of servers
- See the previous column of servers
Control-L Refresh the screen
t Each press toggles to the next of 3 lock-time displays. The default is not to display lock times. Pressing t once displays the last table and index lock for each listed table, relative to now. Pressing t again displays those times in absolute (wall-clock) form. Pressing t again reverts to the default (no lock-time display). Added in version 4.02.1046213372 Feb 25 2003.
q Exit ltest

Ltest uses one connection to the database, so this should be taken into account when looking at the information.

Copyright © Thunderstone Software     Last updated: Dec 10 2018
Copyright © 2019 Thunderstone Software LLC. All rights reserved.