720
720
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
721
721
FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
724
724
Check transaction_log_entries
725
725
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
726
726
ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
730
731
Check transaction_log_transactions
731
732
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
732
733
ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
733
734
0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
734
735
75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
735
737
Check transaction log contents
736
738
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
737
739
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))