Listing Active Transactions
This procedure allows you to list the transactions currently open on the database.
Note
You can only run this procedure when Transaction Logging is active. If necessary, use Configuration and Setup option 2 to start logging.
Procedure
Select option 2 on the Miscellaneous menu. A message is displayed describing the purpose of the procedure and prompting you to confirm that you wish to continue.
Enter y
at the confirmation prompt. If there are any
open transactions a report is displayed similar to the following:
***Active transactions at 09:30:09 on 31 JUL 1999. Page 1 of 1.*** PORT USER ID...LOCATION.................. TRANSACTION START *24 SYSMAN Room 5 16:46 02 APR 19 110 TYPING Room 12 17:56 02 APR 19
This report is refreshed every 10 seconds. The following report fields are listed:
-
PORT - The port from which the transaction was started.
-
USER ID - The identity of the user that started the transaction.
-
LOCATION - The location from which the transaction was started.
-
TRANSACTION START - The time and date that the transaction was started.