syssqltrace time columns

Sean Baker

2014-04-09 22:55:28 UTC

We were trying to correlate a start-time and finish-time with one of the other time columns (sql_totaltime, sql_maxtime, etc.). Weird that they wouldn't include the actual start time.

Thanks for the help!

Sean.

---------------

From: Art Kagel [mailto:***@gmail.com]
Sent: Wednesday, April 09, 2014 3:14 PM
To: Sean Baker
Cc: informix-***@iiug.org
Subject: Re: syssqltrace time columns

IB that sql_begintxtime is an internal timestamp which is just a monotonically increasing value that the server increments every time it processes certain internal steps. It is the same timestamp that is put on a page on disk when it is modified. There is no direct correlation between an internal Informix timestamp and clock time. The increments do not even represent a uniform passage of any increment of time.

Art

Art S. Kagel, Principal Consultant
ASK Database Management

Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.

On Wed, Apr 9, 2014 at 5:45 PM, Sean Baker <***@moneymailer.com> wrote:
Hi All,

We're running IDS 11.50.FC6 on RHEL 5.3.

We've enabled SQL tracing for some users to nail down some performance issues.

The syssqltrace table has a couple of time columns (sql_begintxtime and sql_finishtime). Sample values from a record are:

sql_finishtime 1397079633
sql_begintxtime 1913293618

Per the documentation, the sql_finishtime column is "Time this statement completed (Unix)". So 1397079633 = Wed, 09 Apr 2014 21:40:33 GMT.

But the documentation for sql_begintxtime says "Time this transaction started". It's not Unix format.

Does anyone know what time format this is? And how to convert it to a date/time?

Thanks,

Sean.