Re: transaction begin time stamp

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 > Hi, You can't extract times from it. It's an internal number, and has nothing to do with your wrist watch. It's used to know what order things happened in the engine and to check the consistency of the server pages. Hope it helps. sending to informix-list