%SYS.Journal.Transactionpersistent class %SYS.Journal.Transaction
READONLY = 1 means that objects can be created, opened but not saved or deleted. Tables are projected to SQL as READONLY.
Returns the job number of successive processes with open transactions.
Returns the number of bytes from starting journal file offset to current journal file offset.
Returns the timestamp on the txstart record at journal file index and journal file offset.
Returns the virtual location of the TSTART of current transaction, in the form of JournalFileName,JournalFileOffset,JournalFileCount.
Note that the TSTART may be physically located in the next file after journal switches.
Query to get transaction metrics
SizeMin: limit transactions listed to those whose size exceeds this value.
JobNum: job number in pidtab
Pid: job process id
JournalBytes: number of bytes from starting journal file offset to current journal file offset.
JournalFile: full path name of starting journal file.
JournalRef: starting journal file refcount.
StartOffset: byte offset of TStart record in starting journal file.
StartTime: timestamp of the TStart record in $Horolog format