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? The IDS timestamp is just a monotonically increasing number. It is simply incremented each time it is accessed to update a page or data structure timestamp. It is meaningless beyond giving sequence to events. Ignoring 32bit integer wrapping, a larger timestamp indicates a more recent event than a smaller one. Art S. Kagel