[Informix ER] Information about ATS and RIS files -- Posted by inturi on Thursday, September 11 2008
ATS files
1> One ATS file generated for each aborted transaction
2> If one of replicate in aborted transaction has ATS option enabled then ATS file will be dumped for the aborted txn
3> ATS file contains all the rows in the aborted txn
4> ATS file is created only when complete txn is aborted
5> Only replicated rows are dumped in this file
6> Local rows are not dumped. They are part of RIS file if RIS option is enabled. This is one of the key difference between ATS and RIS
7> Shows RIS file name if RIS file is also created.

RIS files
1> One RIS file is created per replicated transaction
2> Only aborted rows are dumped into RIS file
3> If txn is aborted then that information is shown in this file like :TXH Transaction aborted
4> Shows ATS file name if ATS file is also created for the transaction