Administration Tools - oolistwait

Printer-friendly version
Displays information about transactions waiting on any lockable Objectivity/DB object, which can be a federated database, a database, or a container.
oolistwait
[-transaction id | ([-host hostName] [-user userId])]
[-notitle]
[-help]
[bootFilePath]
Options
-transaction id
Checks the status of the specified transaction.
-host hostName
Lists the status of all waiting transactions started on the specified host, subject to filtering based on other options. This option defaults to all nodes.
-user userId
Lists the status of all waiting transactions started by the specified user, subject to filtering based on other options. This option defaults to all users.
-notitle
Suppresses the copyright notice and program title banner. Useful when invoking the tool from another tool or product.
-help
Prints the tool syntax and definition to the screen.
bootFilePath
Path to a boot file specifying the lock server to be queried. You can omit this argument if you set the OO_FD_BOOT environment variable to the correct path.
Discussion
This tool queries the specified lock server to check for waiting transactions started by a specified user or host. You can also use this tool to find out whether a specified transaction is waiting for a lockable object, and if so, which transactions currently hold the lock on that object. The displayed transactions may be waiting for resources in any of the federated databases or autonomous partitions serviced by the specified lock server.
The following table summarizes how to use the various options to view different types of transaction information.
To View
Use This Option
All waiting transactions
(no options)
Waiting transactions started on a specific host system
host
Waiting transactions started by a specific user
user
Waiting transactions started by a specific user on a specific host system
host and user
A specific transaction’s status, and any transactions that are using resources that it needs
transaction
Locks reported for objects of type M are internally used locks of short duration that manage access to page maps in containers. They are sometimes called latches.

Date: 
Tuesday, October 30, 2012
Product: 
Objectivity/DB
Version: 
10.2.1
10.2
10.1.4
10.1.2
9.4.1