The TLOG-STATUS command displays the status of the transaction logger from any process.
Format
|
TLOG-STATUS |
Description
TLOG-STATUS produces a report that looks like this:
|
============== TRANSACTION LOGGING STATUS ============= Current Number of UNPROCESSED QUEUE ENTRIES: 0 Current GLOBAL TRANSACTION NUMBER: 6747 Frames in use by TRANSACTION LOGGING: 7 "UPDATE LOGGING" is: ACTIVE =============== "TRANSACTION PROCESSOR" ================ Transaction Processor STATUS: ACTIVE on Process 1 SESSION TRANSACTION *-- ENQUEUED AT --* NUMBER NUMBER DATE TIME -------------- -------------- ----------- ---------- "LATEST" 2 END: 6747 MM/DD/YY 16:35:00 BEGIN: 3157 MM/DD/YY 17:19:39 "PREVIOUS" 1 END: 3156 MM/DD/YY 17:17:40 BEGIN: 1 MM/DD/YY 13:20:18 ========================================================= |
|
Category |
Message |
|
TRANSACTION LOGGING STATUS |
Displays the status of update logging. |
|
TRANSACTION PROCESSOR |
Displays the status of transaction logging. Can be ACTIVE on Process n, SUSPENDED on Process n, or INACTIVE. |
|
UPDATE LOGGING |
Can be ACTIVE or INACTIVE. |
|
LATEST |
Current transaction logging session. If transaction logging is currently inactive, LATEST is the most recently dequeued session. |
|
PREVIOUS |
Transaction logging session dequeued just previous to the current session. If transaction logging is currently inactive, PREVIOUS is the session dequeued before the latest session. |
The last transaction number of the PREVIOUS session and the first transaction number of the LATEST session should be sequential, signifying that entries have not been lost between transaction logging sessions.
|
NOTE |
Session Number output will be preceded with the letter C if the session is a clearing session. |