Re: Handing ATS/RIS files on CDR

Dhanesh K Veedu wrote: > Informix Gurus, > > May be the second time i'm sending this.... > > I just would like to know, as a DBA, what do you do with the ATS/RIS files. > Are they just informational files??... just discard it or.... Look at them. There may be errors or simple warnings. Example, with timestamp conflict resolution, it might be a warning like (updating a row that is'nt there, so we'll convert it to an insert). Or it might be an a valid SQL error (lock timeout expired). Its important information that can help you identify potential problems. I recommend getting them. Make a simple cron job to test for existence, then email you if they are there. (move them into another dir, so you don't get spammed!) > > > Is there any specific way to implement different time zones, if the ER > servers are located at different time zones... like say PDT and EDT ( using > CLU ) Use timestamp conflict resolution. All times are evaluated via GMT. See page 7-16 in Guide to ER for 9.20. ray > > > Thanks in advance, > > Dhanesh > ________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com