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.
Ltest will recognize the following keys, and perform the specified action.
tonce displays the last table and index lock for each listed table, relative to now. Pressing
tagain displays those times in absolute (wall-clock) form. Pressing
tagain reverts to the default (no lock-time display). Added in version 4.02.1046213372 Feb 25 2003.
Ltest uses one connection to the database, so this should be taken into account when looking at the information.