Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
syssqltrace time columns
143 views
Skip to first unread message
Sean Baker
Apr 9, 2014, 5:45:06 PM4/9/14
to inform...@iiug.org
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.
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.
Sean Baker
Apr 9, 2014, 6:55:28 PM4/9/14
to inform...@iiug.org
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:art....@gmail.com]
Sent: Wednesday, April 09, 2014 3:14 PM
To: Sean Baker
Cc: inform...@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.
Thanks for the help!
Sean.
---------------
From: Art Kagel [mailto:art....@gmail.com]
Sent: Wednesday, April 09, 2014 3:14 PM
To: Sean Baker
Cc: inform...@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.
0 new messages