Re: transaction begin time stamp

Posted in 2005

Jose Luis Matute — Wed, 13 Apr 2005 07:08:05 +0200 — source: Usenet: comp.databases.informix

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

↪ replying to Jose Luis Matute

scottishpoet — 13 Apr 2005 10:24:46 -0700 — source: Usenet: comp.databases.informix

>From onlog you can see what time the BEGIN was executed... 3792fc 44 BEGIN 5 52 0 04/13/2005 18:11:14 46 johnd 379328 40 UNIQID 5 0 3792fc 100060 103 379350 380 BLDCL 5 0 379328 400067 8 8 8 0 test1 3794cc 44 CHALLOC 5 0 379350 00004:0000003901 8 3794f8 48 PTEXTEND 5 0 3794cc 400067 7 00004:0000003901 <snip>

Glossary

checkpoint