Re: transaction begin time stamp

Another idea: you have the log the transaction began and the time that log filled from syslogfil (if it's not the current one, of course), and even the one before. If it's enough for your purposes you can get the syslogfil.filltime field for those two logs, and your tx began between those time stamps (and now it's supposed it contains real time ;) ). Hope it helps. Bill Dare wrote: > Does anyone know how to calculate the begin work timestamp of a > transaction? > > The value stored in systxptab.begstamp is not a unix time. The begstamp > column seems to be the same timestamp found in the online log recorded > with each checkpoint. Anyone know what this value represents? > > Bill > > > sending to informix-list > sending to informix-list