Example: Local Journaling - Teradata Vantage

The tables in this example are on the Block File System.

As an example, given the following CREATE TABLE requests:

CREATE TABLE cyk.test_1, NO FALLBACK, AFTER JOURNAL (
  x INTEGER, 
  y INTEGER
) PRIMARY INDEX(x);
    
CREATE TABLE cyk.test_2, NO FALLBACK, NOT LOCAL AFTER JOURNAL (
  x INTEGER, 
  y INTEGER
) PRIMARY INDEX(x);
    
CREATE TABLE cyk.test_3, NO FALLBACK, LOCAL AFTER JOURNAL (
  x INTEGER, 
  y INTEGER
) PRIMARY INDEX(x);

SHOW TABLE produces the following output:

CREATE TABLE cyk.test_1, NO FALLBACK, NO BEFORE JOURNAL, NOT LOCAL AFTER JOURNAL (
  x INTEGER, 
  y INTEGER
) PRIMARY INDEX(x);
    
CREATE TABLE cyk.test_2, NO FALLBACK, NO BEFORE JOURNAL, NOT LOCAL AFTER JOURNAL (
  x INTEGER, 
  y INTEGER
) PRIMARY INDEX(x);
    
CREATE TABLE cyk.test_3, NO FALLBACK, NO BEFORE JOURNAL, LOCAL AFTER JOURNAL (
  x INTEGER, 
  y INTEGER
) PRIMARY INDEX(x);