Database Integrity Utilities
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
|