trafodion-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "yuan.liu" <yuan....@esgyn.cn>
Subject RE: Understand the tables related to DTM
Date Fri, 01 Feb 2019 05:21:15 GMT
Hi Sean, 

Thanks a lot for your answer.

Yuan

-----Original Message-----
From: Sean Broeder <sean.broeder@esgyn.com> 
Sent: Friday, February 01, 2019 11:39 AM
To: dev@trafodion.apache.org
Subject: RE: Understand the tables related to DTM

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 <yuan.liu@esgyn.cn>
Sent: Thursday, January 31, 2019 7:11 PM
To: dev@trafodion.apache.org
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

 

 

 



Mime
View raw message