← Back to branch summary

~stewart/drizzle/rename-embedded-innodb-to-haildb

« back to all changes in this revision

Viewing changes to plugin/transaction_log/tests/r/transaction_log_data_type.result

  • Committer: Stewart Smith
  • Date: 2010-09-30 05:47:49 UTC
  • mfrom: (1787.3.15 drizzle)
  • Revision ID: stewart@flamingspork.com-20100930054749-s1szrpe6wm2z8532
merge trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/transaction_log/tests/r/transaction_log_data_type.result
267
267
# check transaction_log
268
268
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
269
269
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
270
 
transaction.log 653     6       6       1       8       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
270
transaction.log 653     6       6       1       6       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
271
271
 
272
272
Check transaction_log_entries
273
273
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
287
287
150     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
288
288
323     4       1       START_TIMESTAMP END_TIMESTAMP   1       0
289
289
437     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
290
 
550     8       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
290
550     6       1       START_TIMESTAMP END_TIMESTAMP   1       0
291
291
Check transaction log contents
292
292
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
293
293
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
294
294
transaction_context {
295
295
  server_id: 1
296
 
  transaction_id: 8
 
296
  transaction_id: 6
297
297
  START_TIMESTAMP
298
298
  END_TIMESTAMP
299
299
}
335
335
# check transaction_log
336
336
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
337
337
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
338
 
transaction.log 653     6       6       1       8       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
338
transaction.log 653     6       6       1       6       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
339
339
 
340
340
Check transaction_log_entries
341
341
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
355
355
150     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
356
356
323     4       1       START_TIMESTAMP END_TIMESTAMP   1       0
357
357
437     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
358
 
550     8       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
358
550     6       1       START_TIMESTAMP END_TIMESTAMP   1       0
359
359
Check transaction log contents
360
360
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
361
361
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
362
362
transaction_context {
363
363
  server_id: 1
364
 
  transaction_id: 8
 
364
  transaction_id: 6
365
365
  START_TIMESTAMP
366
366
  END_TIMESTAMP
367
367
}
403
403
# check transaction_log
404
404
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
405
405
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
406
 
transaction.log 653     6       6       1       8       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
406
transaction.log 653     6       6       1       6       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
407
407
 
408
408
Check transaction_log_entries
409
409
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
423
423
150     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
424
424
323     4       1       START_TIMESTAMP END_TIMESTAMP   1       0
425
425
437     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
426
 
550     8       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
426
550     6       1       START_TIMESTAMP END_TIMESTAMP   1       0
427
427
Check transaction log contents
428
428
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
429
429
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
430
430
transaction_context {
431
431
  server_id: 1
432
 
  transaction_id: 8
 
432
  transaction_id: 6
433
433
  START_TIMESTAMP
434
434
  END_TIMESTAMP
435
435
}
470
470
# check transaction_log
471
471
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
472
472
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
473
 
transaction.log 805     7       7       1       11      START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
473
transaction.log 805     7       7       1       7       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
474
474
 
475
475
Check transaction_log_entries
476
476
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
491
491
150     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
492
492
323     4       1       START_TIMESTAMP END_TIMESTAMP   1       0
493
493
437     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
494
 
550     8       1       START_TIMESTAMP END_TIMESTAMP   1       0
495
 
653     11      1       START_TIMESTAMP END_TIMESTAMP   1       0
 
494
550     6       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
495
653     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
496
496
Check transaction log contents
497
497
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
498
498
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
499
499
transaction_context {
500
500
  server_id: 1
501
 
  transaction_id: 11
 
501
  transaction_id: 7
502
502
  START_TIMESTAMP
503
503
  END_TIMESTAMP
504
504
}
758
758
# check transaction_log
759
759
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
760
760
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
761
 
transaction.log 616     5       5       1       6       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
761
transaction.log 616     5       5       1       5       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
762
762
 
763
763
Check transaction_log_entries
764
764
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
776
776
75      2       1       START_TIMESTAMP END_TIMESTAMP   1       0
777
777
248     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
778
778
371     4       1       START_TIMESTAMP END_TIMESTAMP   1       0
779
 
493     6       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
779
493     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
780
780
Check transaction log contents
781
781
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
782
782
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
783
783
transaction_context {
784
784
  server_id: 1
785
 
  transaction_id: 6
 
785
  transaction_id: 5
786
786
  START_TIMESTAMP
787
787
  END_TIMESTAMP
788
788
}
823
823
# check transaction_log
824
824
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
825
825
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
826
 
transaction.log 719     6       6       1       7       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
826
transaction.log 719     6       6       1       6       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
827
827
 
828
828
Check transaction_log_entries
829
829
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
842
842
75      2       1       START_TIMESTAMP END_TIMESTAMP   1       0
843
843
248     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
844
844
371     4       1       START_TIMESTAMP END_TIMESTAMP   1       0
845
 
493     6       1       START_TIMESTAMP END_TIMESTAMP   1       0
846
 
616     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
845
493     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
846
616     6       1       START_TIMESTAMP END_TIMESTAMP   1       0
847
847
Check transaction log contents
848
848
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
849
849
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
850
850
transaction_context {
851
851
  server_id: 1
852
 
  transaction_id: 7
 
852
  transaction_id: 6
853
853
  START_TIMESTAMP
854
854
  END_TIMESTAMP
855
855
}
891
891
# check transaction_log
892
892
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
893
893
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
894
 
transaction.log 719     6       6       1       7       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
894
transaction.log 719     6       6       1       6       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
895
895
 
896
896
Check transaction_log_entries
897
897
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
910
910
75      2       1       START_TIMESTAMP END_TIMESTAMP   1       0
911
911
248     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
912
912
371     4       1       START_TIMESTAMP END_TIMESTAMP   1       0
913
 
493     6       1       START_TIMESTAMP END_TIMESTAMP   1       0
914
 
616     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
913
493     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
914
616     6       1       START_TIMESTAMP END_TIMESTAMP   1       0
915
915
Check transaction log contents
916
916
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
917
917
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
918
918
transaction_context {
919
919
  server_id: 1
920
 
  transaction_id: 7
 
920
  transaction_id: 6
921
921
  START_TIMESTAMP
922
922
  END_TIMESTAMP
923
923
}
959
959
# check transaction_log
960
960
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
961
961
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
962
 
transaction.log 719     6       6       1       7       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
962
transaction.log 719     6       6       1       6       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
963
963
 
964
964
Check transaction_log_entries
965
965
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
978
978
75      2       1       START_TIMESTAMP END_TIMESTAMP   1       0
979
979
248     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
980
980
371     4       1       START_TIMESTAMP END_TIMESTAMP   1       0
981
 
493     6       1       START_TIMESTAMP END_TIMESTAMP   1       0
982
 
616     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
981
493     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
982
616     6       1       START_TIMESTAMP END_TIMESTAMP   1       0
983
983
Check transaction log contents
984
984
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
985
985
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
986
986
transaction_context {
987
987
  server_id: 1
988
 
  transaction_id: 7
 
988
  transaction_id: 6
989
989
  START_TIMESTAMP
990
990
  END_TIMESTAMP
991
991
}
1285
1285
# check transaction_log
1286
1286
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
1287
1287
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
1288
 
transaction.log 576     5       5       1       7       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
1288
transaction.log 576     5       5       1       5       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
1289
1289
 
1290
1290
Check transaction_log_entries
1291
1291
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1303
1303
75      2       1       START_TIMESTAMP END_TIMESTAMP   1       0
1304
1304
254     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
1305
1305
364     4       1       START_TIMESTAMP END_TIMESTAMP   1       0
1306
 
473     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
1306
473     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
1307
1307
Check transaction log contents
1308
1308
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
1309
1309
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
1310
1310
transaction_context {
1311
1311
  server_id: 1
1312
 
  transaction_id: 7
 
1312
  transaction_id: 5
1313
1313
  START_TIMESTAMP
1314
1314
  END_TIMESTAMP
1315
1315
}
1351
1351
# check transaction_log
1352
1352
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
1353
1353
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
1354
 
transaction.log 576     5       5       1       7       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
1354
transaction.log 576     5       5       1       5       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
1355
1355
 
1356
1356
Check transaction_log_entries
1357
1357
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1369
1369
75      2       1       START_TIMESTAMP END_TIMESTAMP   1       0
1370
1370
254     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
1371
1371
364     4       1       START_TIMESTAMP END_TIMESTAMP   1       0
1372
 
473     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
1372
473     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
1373
1373
Check transaction log contents
1374
1374
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
1375
1375
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
1376
1376
transaction_context {
1377
1377
  server_id: 1
1378
 
  transaction_id: 7
 
1378
  transaction_id: 5
1379
1379
  START_TIMESTAMP
1380
1380
  END_TIMESTAMP
1381
1381
}
1417
1417
# check transaction_log
1418
1418
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
1419
1419
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
1420
 
transaction.log 576     5       5       1       7       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
1420
transaction.log 576     5       5       1       5       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
1421
1421
 
1422
1422
Check transaction_log_entries
1423
1423
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1435
1435
75      2       1       START_TIMESTAMP END_TIMESTAMP   1       0
1436
1436
254     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
1437
1437
364     4       1       START_TIMESTAMP END_TIMESTAMP   1       0
1438
 
473     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
1438
473     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
1439
1439
Check transaction log contents
1440
1440
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
1441
1441
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
1442
1442
transaction_context {
1443
1443
  server_id: 1
1444
 
  transaction_id: 7
 
1444
  transaction_id: 5
1445
1445
  START_TIMESTAMP
1446
1446
  END_TIMESTAMP
1447
1447
}
1482
1482
# check transaction_log
1483
1483
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
1484
1484
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
1485
 
transaction.log 685     6       6       1       10      START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
1485
transaction.log 685     6       6       1       6       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
1486
1486
 
1487
1487
Check transaction_log_entries
1488
1488
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1501
1501
75      2       1       START_TIMESTAMP END_TIMESTAMP   1       0
1502
1502
254     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
1503
1503
364     4       1       START_TIMESTAMP END_TIMESTAMP   1       0
1504
 
473     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
1505
 
576     10      1       START_TIMESTAMP END_TIMESTAMP   1       0
 
1504
473     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
1505
576     6       1       START_TIMESTAMP END_TIMESTAMP   1       0
1506
1506
Check transaction log contents
1507
1507
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
1508
1508
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
1509
1509
transaction_context {
1510
1510
  server_id: 1
1511
 
  transaction_id: 10
 
1511
  transaction_id: 6
1512
1512
  START_TIMESTAMP
1513
1513
  END_TIMESTAMP
1514
1514
}
1550
1550
# check transaction_log
1551
1551
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
1552
1552
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
1553
 
transaction.log 685     6       6       1       10      START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
1553
transaction.log 685     6       6       1       6       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
1554
1554
 
1555
1555
Check transaction_log_entries
1556
1556
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1569
1569
75      2       1       START_TIMESTAMP END_TIMESTAMP   1       0
1570
1570
254     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
1571
1571
364     4       1       START_TIMESTAMP END_TIMESTAMP   1       0
1572
 
473     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
1573
 
576     10      1       START_TIMESTAMP END_TIMESTAMP   1       0
 
1572
473     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
1573
576     6       1       START_TIMESTAMP END_TIMESTAMP   1       0
1574
1574
Check transaction log contents
1575
1575
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
1576
1576
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
1577
1577
transaction_context {
1578
1578
  server_id: 1
1579
 
  transaction_id: 10
 
1579
  transaction_id: 6
1580
1580
  START_TIMESTAMP
1581
1581
  END_TIMESTAMP
1582
1582
}
1617
1617
# check transaction_log
1618
1618
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
1619
1619
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
1620
 
transaction.log 792     7       7       1       12      START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
1620
transaction.log 792     7       7       1       7       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
1621
1621
 
1622
1622
Check transaction_log_entries
1623
1623
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1637
1637
75      2       1       START_TIMESTAMP END_TIMESTAMP   1       0
1638
1638
254     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
1639
1639
364     4       1       START_TIMESTAMP END_TIMESTAMP   1       0
1640
 
473     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
1641
 
576     10      1       START_TIMESTAMP END_TIMESTAMP   1       0
1642
 
685     12      1       START_TIMESTAMP END_TIMESTAMP   1       0
 
1640
473     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
1641
576     6       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
1642
685     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
1643
1643
Check transaction log contents
1644
1644
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
1645
1645
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
1646
1646
transaction_context {
1647
1647
  server_id: 1
1648
 
  transaction_id: 12
 
1648
  transaction_id: 7
1649
1649
  START_TIMESTAMP
1650
1650
  END_TIMESTAMP
1651
1651
}
1945
1945
# check transaction_log
1946
1946
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
1947
1947
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
1948
 
transaction.log 576     5       5       1       7       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
1948
transaction.log 576     5       5       1       5       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
1949
1949
 
1950
1950
Check transaction_log_entries
1951
1951
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1963
1963
75      2       1       START_TIMESTAMP END_TIMESTAMP   1       0
1964
1964
254     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
1965
1965
364     4       1       START_TIMESTAMP END_TIMESTAMP   1       0
1966
 
473     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
1966
473     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
1967
1967
Check transaction log contents
1968
1968
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
1969
1969
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
1970
1970
transaction_context {
1971
1971
  server_id: 1
1972
 
  transaction_id: 7
 
1972
  transaction_id: 5
1973
1973
  START_TIMESTAMP
1974
1974
  END_TIMESTAMP
1975
1975
}
2011
2011
# check transaction_log
2012
2012
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
2013
2013
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
2014
 
transaction.log 576     5       5       1       7       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
2014
transaction.log 576     5       5       1       5       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
2015
2015
 
2016
2016
Check transaction_log_entries
2017
2017
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2029
2029
75      2       1       START_TIMESTAMP END_TIMESTAMP   1       0
2030
2030
254     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
2031
2031
364     4       1       START_TIMESTAMP END_TIMESTAMP   1       0
2032
 
473     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
2032
473     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
2033
2033
Check transaction log contents
2034
2034
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
2035
2035
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
2036
2036
transaction_context {
2037
2037
  server_id: 1
2038
 
  transaction_id: 7
 
2038
  transaction_id: 5
2039
2039
  START_TIMESTAMP
2040
2040
  END_TIMESTAMP
2041
2041
}
2271
2271
# check transaction_log
2272
2272
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
2273
2273
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
2274
 
transaction.log 592     5       5       1       6       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
2274
transaction.log 592     5       5       1       5       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
2275
2275
 
2276
2276
Check transaction_log_entries
2277
2277
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2289
2289
75      2       1       START_TIMESTAMP END_TIMESTAMP   1       0
2290
2290
273     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
2291
2291
376     4       1       START_TIMESTAMP END_TIMESTAMP   1       0
2292
 
489     6       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
2292
489     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
2293
2293
Check transaction log contents
2294
2294
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
2295
2295
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
2296
2296
transaction_context {
2297
2297
  server_id: 1
2298
 
  transaction_id: 6
 
2298
  transaction_id: 5
2299
2299
  START_TIMESTAMP
2300
2300
  END_TIMESTAMP
2301
2301
}
2336
2336
# check transaction_log
2337
2337
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
2338
2338
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
2339
 
transaction.log 702     6       6       1       7       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
2339
transaction.log 702     6       6       1       6       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
2340
2340
 
2341
2341
Check transaction_log_entries
2342
2342
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2355
2355
75      2       1       START_TIMESTAMP END_TIMESTAMP   1       0
2356
2356
273     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
2357
2357
376     4       1       START_TIMESTAMP END_TIMESTAMP   1       0
2358
 
489     6       1       START_TIMESTAMP END_TIMESTAMP   1       0
2359
 
592     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
2358
489     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
2359
592     6       1       START_TIMESTAMP END_TIMESTAMP   1       0
2360
2360
Check transaction log contents
2361
2361
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
2362
2362
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
2363
2363
transaction_context {
2364
2364
  server_id: 1
2365
 
  transaction_id: 7
 
2365
  transaction_id: 6
2366
2366
  START_TIMESTAMP
2367
2367
  END_TIMESTAMP
2368
2368
}
2598
2598
# check transaction_log
2599
2599
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
2600
2600
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
2601
 
transaction.log 598     5       5       1       6       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
2601
transaction.log 598     5       5       1       5       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
2602
2602
 
2603
2603
Check transaction_log_entries
2604
2604
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2616
2616
75      2       1       START_TIMESTAMP END_TIMESTAMP   1       0
2617
2617
287     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
2618
2618
391     4       1       START_TIMESTAMP END_TIMESTAMP   1       0
2619
 
495     6       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
2619
495     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
2620
2620
Check transaction log contents
2621
2621
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
2622
2622
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
2623
2623
transaction_context {
2624
2624
  server_id: 1
2625
 
  transaction_id: 6
 
2625
  transaction_id: 5
2626
2626
  START_TIMESTAMP
2627
2627
  END_TIMESTAMP
2628
2628
}
2922
2922
# check transaction_log
2923
2923
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
2924
2924
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
2925
 
transaction.log 587     5       5       1       7       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
2925
transaction.log 587     5       5       1       5       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
2926
2926
 
2927
2927
Check transaction_log_entries
2928
2928
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2940
2940
75      2       1       START_TIMESTAMP END_TIMESTAMP   1       0
2941
2941
248     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
2942
2942
361     4       1       START_TIMESTAMP END_TIMESTAMP   1       0
2943
 
474     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
2943
474     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
2944
2944
Check transaction log contents
2945
2945
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
2946
2946
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
2947
2947
transaction_context {
2948
2948
  server_id: 1
2949
 
  transaction_id: 7
 
2949
  transaction_id: 5
2950
2950
  START_TIMESTAMP
2951
2951
  END_TIMESTAMP
2952
2952
}
2987
2987
# check transaction_log
2988
2988
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
2989
2989
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
2990
 
transaction.log 700     6       6       1       8       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
2990
transaction.log 700     6       6       1       6       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
2991
2991
 
2992
2992
Check transaction_log_entries
2993
2993
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3006
3006
75      2       1       START_TIMESTAMP END_TIMESTAMP   1       0
3007
3007
248     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
3008
3008
361     4       1       START_TIMESTAMP END_TIMESTAMP   1       0
3009
 
474     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
3010
 
587     8       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
3009
474     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
3010
587     6       1       START_TIMESTAMP END_TIMESTAMP   1       0
3011
3011
Check transaction log contents
3012
3012
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
3013
3013
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
3014
3014
transaction_context {
3015
3015
  server_id: 1
3016
 
  transaction_id: 8
 
3016
  transaction_id: 6
3017
3017
  START_TIMESTAMP
3018
3018
  END_TIMESTAMP
3019
3019
}
3054
3054
# check transaction_log
3055
3055
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
3056
3056
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
3057
 
transaction.log 803     7       7       1       9       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
3057
transaction.log 803     7       7       1       7       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
3058
3058
 
3059
3059
Check transaction_log_entries
3060
3060
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3074
3074
75      2       1       START_TIMESTAMP END_TIMESTAMP   1       0
3075
3075
248     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
3076
3076
361     4       1       START_TIMESTAMP END_TIMESTAMP   1       0
3077
 
474     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
3078
 
587     8       1       START_TIMESTAMP END_TIMESTAMP   1       0
3079
 
700     9       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
3077
474     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
3078
587     6       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
3079
700     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
3080
3080
Check transaction log contents
3081
3081
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
3082
3082
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
3083
3083
transaction_context {
3084
3084
  server_id: 1
3085
 
  transaction_id: 9
 
3085
  transaction_id: 7
3086
3086
  START_TIMESTAMP
3087
3087
  END_TIMESTAMP
3088
3088
}
3124
3124
# check transaction_log
3125
3125
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
3126
3126
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
3127
 
transaction.log 803     7       7       1       9       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
3127
transaction.log 803     7       7       1       7       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
3128
3128
 
3129
3129
Check transaction_log_entries
3130
3130
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3144
3144
75      2       1       START_TIMESTAMP END_TIMESTAMP   1       0
3145
3145
248     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
3146
3146
361     4       1       START_TIMESTAMP END_TIMESTAMP   1       0
3147
 
474     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
3148
 
587     8       1       START_TIMESTAMP END_TIMESTAMP   1       0
3149
 
700     9       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
3147
474     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
3148
587     6       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
3149
700     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
3150
3150
Check transaction log contents
3151
3151
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
3152
3152
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
3153
3153
transaction_context {
3154
3154
  server_id: 1
3155
 
  transaction_id: 9
 
3155
  transaction_id: 7
3156
3156
  START_TIMESTAMP
3157
3157
  END_TIMESTAMP
3158
3158
}
3194
3194
# check transaction_log
3195
3195
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
3196
3196
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
3197
 
transaction.log 803     7       7       1       9       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
3197
transaction.log 803     7       7       1       7       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
3198
3198
 
3199
3199
Check transaction_log_entries
3200
3200
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3214
3214
75      2       1       START_TIMESTAMP END_TIMESTAMP   1       0
3215
3215
248     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
3216
3216
361     4       1       START_TIMESTAMP END_TIMESTAMP   1       0
3217
 
474     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
3218
 
587     8       1       START_TIMESTAMP END_TIMESTAMP   1       0
3219
 
700     9       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
3217
474     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
3218
587     6       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
3219
700     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
3220
3220
Check transaction log contents
3221
3221
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
3222
3222
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
3223
3223
transaction_context {
3224
3224
  server_id: 1
3225
 
  transaction_id: 9
 
3225
  transaction_id: 7
3226
3226
  START_TIMESTAMP
3227
3227
  END_TIMESTAMP
3228
3228
}
3522
3522
# check transaction_log
3523
3523
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
3524
3524
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
3525
 
transaction.log 614     5       5       1       7       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
3525
transaction.log 614     5       5       1       5       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
3526
3526
 
3527
3527
Check transaction_log_entries
3528
3528
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3540
3540
75      2       1       START_TIMESTAMP END_TIMESTAMP   1       0
3541
3541
248     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
3542
3542
370     4       1       START_TIMESTAMP END_TIMESTAMP   1       0
3543
 
492     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
3543
492     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
3544
3544
Check transaction log contents
3545
3545
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
3546
3546
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
3547
3547
transaction_context {
3548
3548
  server_id: 1
3549
 
  transaction_id: 7
 
3549
  transaction_id: 5
3550
3550
  START_TIMESTAMP
3551
3551
  END_TIMESTAMP
3552
3552
}
3587
3587
# check transaction_log
3588
3588
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
3589
3589
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
3590
 
transaction.log 736     6       6       1       8       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
3590
transaction.log 736     6       6       1       6       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
3591
3591
 
3592
3592
Check transaction_log_entries
3593
3593
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3606
3606
75      2       1       START_TIMESTAMP END_TIMESTAMP   1       0
3607
3607
248     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
3608
3608
370     4       1       START_TIMESTAMP END_TIMESTAMP   1       0
3609
 
492     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
3610
 
614     8       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
3609
492     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
3610
614     6       1       START_TIMESTAMP END_TIMESTAMP   1       0
3611
3611
Check transaction log contents
3612
3612
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
3613
3613
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
3614
3614
transaction_context {
3615
3615
  server_id: 1
3616
 
  transaction_id: 8
 
3616
  transaction_id: 6
3617
3617
  START_TIMESTAMP
3618
3618
  END_TIMESTAMP
3619
3619
}
3654
3654
# check transaction_log
3655
3655
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
3656
3656
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
3657
 
transaction.log 839     7       7       1       9       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
3657
transaction.log 839     7       7       1       7       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
3658
3658
 
3659
3659
Check transaction_log_entries
3660
3660
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3674
3674
75      2       1       START_TIMESTAMP END_TIMESTAMP   1       0
3675
3675
248     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
3676
3676
370     4       1       START_TIMESTAMP END_TIMESTAMP   1       0
3677
 
492     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
3678
 
614     8       1       START_TIMESTAMP END_TIMESTAMP   1       0
3679
 
736     9       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
3677
492     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
3678
614     6       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
3679
736     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
3680
3680
Check transaction log contents
3681
3681
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
3682
3682
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
3683
3683
transaction_context {
3684
3684
  server_id: 1
3685
 
  transaction_id: 9
 
3685
  transaction_id: 7
3686
3686
  START_TIMESTAMP
3687
3687
  END_TIMESTAMP
3688
3688
}
3724
3724
# check transaction_log
3725
3725
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
3726
3726
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
3727
 
transaction.log 839     7       7       1       9       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
3727
transaction.log 839     7       7       1       7       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
3728
3728
 
3729
3729
Check transaction_log_entries
3730
3730
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3744
3744
75      2       1       START_TIMESTAMP END_TIMESTAMP   1       0
3745
3745
248     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
3746
3746
370     4       1       START_TIMESTAMP END_TIMESTAMP   1       0
3747
 
492     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
3748
 
614     8       1       START_TIMESTAMP END_TIMESTAMP   1       0
3749
 
736     9       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
3747
492     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
3748
614     6       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
3749
736     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
3750
3750
Check transaction log contents
3751
3751
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
3752
3752
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
3753
3753
transaction_context {
3754
3754
  server_id: 1
3755
 
  transaction_id: 9
 
3755
  transaction_id: 7
3756
3756
  START_TIMESTAMP
3757
3757
  END_TIMESTAMP
3758
3758
}
3794
3794
# check transaction_log
3795
3795
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
3796
3796
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
3797
 
transaction.log 839     7       7       1       9       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
3797
transaction.log 839     7       7       1       7       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
3798
3798
 
3799
3799
Check transaction_log_entries
3800
3800
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3814
3814
75      2       1       START_TIMESTAMP END_TIMESTAMP   1       0
3815
3815
248     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
3816
3816
370     4       1       START_TIMESTAMP END_TIMESTAMP   1       0
3817
 
492     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
3818
 
614     8       1       START_TIMESTAMP END_TIMESTAMP   1       0
3819
 
736     9       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
3817
492     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
3818
614     6       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
3819
736     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
3820
3820
Check transaction log contents
3821
3821
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
3822
3822
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
3823
3823
transaction_context {
3824
3824
  server_id: 1
3825
 
  transaction_id: 9
 
3825
  transaction_id: 7
3826
3826
  START_TIMESTAMP
3827
3827
  END_TIMESTAMP
3828
3828
}
3864
3864
# check transaction_log
3865
3865
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
3866
3866
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
3867
 
transaction.log 839     7       7       1       9       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
3867
transaction.log 839     7       7       1       7       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
3868
3868
 
3869
3869
Check transaction_log_entries
3870
3870
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3884
3884
75      2       1       START_TIMESTAMP END_TIMESTAMP   1       0
3885
3885
248     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
3886
3886
370     4       1       START_TIMESTAMP END_TIMESTAMP   1       0
3887
 
492     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
3888
 
614     8       1       START_TIMESTAMP END_TIMESTAMP   1       0
3889
 
736     9       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
3887
492     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
3888
614     6       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
3889
736     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
3890
3890
Check transaction log contents
3891
3891
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
3892
3892
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
3893
3893
transaction_context {
3894
3894
  server_id: 1
3895
 
  transaction_id: 9
 
3895
  transaction_id: 7
3896
3896
  START_TIMESTAMP
3897
3897
  END_TIMESTAMP
3898
3898
}
4192
4192
# check transaction_log
4193
4193
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
4194
4194
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
4195
 
transaction.log 614     5       5       1       7       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
4195
transaction.log 614     5       5       1       5       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
4196
4196
 
4197
4197
Check transaction_log_entries
4198
4198
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4210
4210
75      2       1       START_TIMESTAMP END_TIMESTAMP   1       0
4211
4211
248     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
4212
4212
370     4       1       START_TIMESTAMP END_TIMESTAMP   1       0
4213
 
492     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
4213
492     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
4214
4214
Check transaction log contents
4215
4215
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
4216
4216
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
4217
4217
transaction_context {
4218
4218
  server_id: 1
4219
 
  transaction_id: 7
 
4219
  transaction_id: 5
4220
4220
  START_TIMESTAMP
4221
4221
  END_TIMESTAMP
4222
4222
}
4257
4257
# check transaction_log
4258
4258
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
4259
4259
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
4260
 
transaction.log 736     6       6       1       8       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
4260
transaction.log 736     6       6       1       6       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
4261
4261
 
4262
4262
Check transaction_log_entries
4263
4263
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4276
4276
75      2       1       START_TIMESTAMP END_TIMESTAMP   1       0
4277
4277
248     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
4278
4278
370     4       1       START_TIMESTAMP END_TIMESTAMP   1       0
4279
 
492     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
4280
 
614     8       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
4279
492     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
4280
614     6       1       START_TIMESTAMP END_TIMESTAMP   1       0
4281
4281
Check transaction log contents
4282
4282
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
4283
4283
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
4284
4284
transaction_context {
4285
4285
  server_id: 1
4286
 
  transaction_id: 8
 
4286
  transaction_id: 6
4287
4287
  START_TIMESTAMP
4288
4288
  END_TIMESTAMP
4289
4289
}
4324
4324
# check transaction_log
4325
4325
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
4326
4326
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
4327
 
transaction.log 839     7       7       1       9       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
4327
transaction.log 839     7       7       1       7       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
4328
4328
 
4329
4329
Check transaction_log_entries
4330
4330
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4344
4344
75      2       1       START_TIMESTAMP END_TIMESTAMP   1       0
4345
4345
248     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
4346
4346
370     4       1       START_TIMESTAMP END_TIMESTAMP   1       0
4347
 
492     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
4348
 
614     8       1       START_TIMESTAMP END_TIMESTAMP   1       0
4349
 
736     9       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
4347
492     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
4348
614     6       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
4349
736     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
4350
4350
Check transaction log contents
4351
4351
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
4352
4352
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
4353
4353
transaction_context {
4354
4354
  server_id: 1
4355
 
  transaction_id: 9
 
4355
  transaction_id: 7
4356
4356
  START_TIMESTAMP
4357
4357
  END_TIMESTAMP
4358
4358
}
4394
4394
# check transaction_log
4395
4395
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
4396
4396
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
4397
 
transaction.log 839     7       7       1       9       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
4397
transaction.log 839     7       7       1       7       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
4398
4398
 
4399
4399
Check transaction_log_entries
4400
4400
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4414
4414
75      2       1       START_TIMESTAMP END_TIMESTAMP   1       0
4415
4415
248     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
4416
4416
370     4       1       START_TIMESTAMP END_TIMESTAMP   1       0
4417
 
492     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
4418
 
614     8       1       START_TIMESTAMP END_TIMESTAMP   1       0
4419
 
736     9       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
4417
492     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
4418
614     6       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
4419
736     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
4420
4420
Check transaction log contents
4421
4421
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
4422
4422
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
4423
4423
transaction_context {
4424
4424
  server_id: 1
4425
 
  transaction_id: 9
 
4425
  transaction_id: 7
4426
4426
  START_TIMESTAMP
4427
4427
  END_TIMESTAMP
4428
4428
}
4464
4464
# check transaction_log
4465
4465
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
4466
4466
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
4467
 
transaction.log 839     7       7       1       9       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
4467
transaction.log 839     7       7       1       7       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
4468
4468
 
4469
4469
Check transaction_log_entries
4470
4470
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4484
4484
75      2       1       START_TIMESTAMP END_TIMESTAMP   1       0
4485
4485
248     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
4486
4486
370     4       1       START_TIMESTAMP END_TIMESTAMP   1       0
4487
 
492     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
4488
 
614     8       1       START_TIMESTAMP END_TIMESTAMP   1       0
4489
 
736     9       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
4487
492     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
4488
614     6       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
4489
736     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
4490
4490
Check transaction log contents
4491
4491
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
4492
4492
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
4493
4493
transaction_context {
4494
4494
  server_id: 1
4495
 
  transaction_id: 9
 
4495
  transaction_id: 7
4496
4496
  START_TIMESTAMP
4497
4497
  END_TIMESTAMP
4498
4498
}
4534
4534
# check transaction_log
4535
4535
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
4536
4536
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
4537
 
transaction.log 839     7       7       1       9       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
4537
transaction.log 839     7       7       1       7       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
4538
4538
 
4539
4539
Check transaction_log_entries
4540
4540
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4554
4554
75      2       1       START_TIMESTAMP END_TIMESTAMP   1       0
4555
4555
248     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
4556
4556
370     4       1       START_TIMESTAMP END_TIMESTAMP   1       0
4557
 
492     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
4558
 
614     8       1       START_TIMESTAMP END_TIMESTAMP   1       0
4559
 
736     9       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
4557
492     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
4558
614     6       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
4559
736     7       1       START_TIMESTAMP END_TIMESTAMP   1       0
4560
4560
Check transaction log contents
4561
4561
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
4562
4562
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
4563
4563
transaction_context {
4564
4564
  server_id: 1
4565
 
  transaction_id: 9
 
4565
  transaction_id: 7
4566
4566
  START_TIMESTAMP
4567
4567
  END_TIMESTAMP
4568
4568
}