Hi Yuan, Trafodion does not have these tables TRAFODION._DTM_.MUTATION TRAFODION._DTM_.MUTATION_SHADOW TRAFODION._DTM_.SNAPSHOT They are part of a different product.
Trafodion does have these tables that you listed TRAFODION._DTM_.TDDL TRAFODION._DTM_.TLOG[n] TRAFODION._DTM_.TLOG[n]_CONTROL_POINT The TDDL file is used during transactional DDL processing and helps ensure the DDL operations obey the ACID principles. The TLOG[n] files contain final transaction state records for DTM[n]. These are important for recovery operations following a variety of failure scenarios. TLOG[n]_CONTROL_POINT table periodically records the sequence number of audit records written to TLOG[n] and is used to determine how long the data in TLOG[n] must be stored before it can be removed. Regards, Sean -----Original Message----- From: yuan.liu <[email protected]> Sent: Thursday, January 31, 2019 7:11 PM To: [email protected] Subject: Understand the tables related to DTM Hi Trafodioneers, We have some tables related to DTM. As listed below from HBase Shell. Can anyone help explain the meaning of these tables, for example, TDDL is for DDL operation? I didn't find any document about this part. Can anyone help, thanks a lot~ hbase(main):002:0> list 'TRAFODION._DTM_.*' TABLE TRAFODION._DTM_.MUTATION TRAFODION._DTM_.MUTATION_SHADOW TRAFODION._DTM_.SNAPSHOT TRAFODION._DTM_.TDDL TRAFODION._DTM_.TLOG0 TRAFODION._DTM_.TLOG0_CONTROL_POINT TRAFODION._DTM_.TLOG1 TRAFODION._DTM_.TLOG1_CONTROL_POINT TRAFODION._DTM_.TLOG2 TRAFODION._DTM_.TLOG2_CONTROL_POINT TRAFODION._DTM_.TLOG3 TRAFODION._DTM_.TLOG3_CONTROL_POINT TRAFODION._DTM_.TLOG4 TRAFODION._DTM_.TLOG4_CONTROL_POINT TRAFODION._DTM_.TLOG5 TRAFODION._DTM_.TLOG5_CONTROL_POINT TRAFODION._DTM_.TLOG6 TRAFODION._DTM_.TLOG6_CONTROL_POINT TRAFODION._DTM_.TLOG7 TRAFODION._DTM_.TLOG7_CONTROL_POINT 20 row(s) in 0.0310 seconds
