Product Documentation

Database Administrator's Guide

Previous Topic

Next Topic

Transaction Statistics -vat

Use ctstat -vat to view the transaction statistics. Sample output is shown below.

  • loglow is the server's lowest-numbered active log.
  • curlog is the server's current log.
  • lstent is the offset in the current log where the last entry was written (which may still be in the in-memory log buffer).
  • lstpnt is the last byte position written to the log file on disk.
  • lstsuc is the offset of the last SUCTRAN or CLSTRAN entry in the log.
  • tranno is the next available transaction number.
  • tfil is the next available transaction file number.

lowlog

curlog

lstent

lstpnt

lstsuc

tranno

tfil

1

4

2702686

2702092

2697872

51806

17298

TOCIndex