sessions.connected in IDS 11.5, what is it?
Trying to diagnose Web-server issues, so I'm creating a history of IDS 11.5 session data to track Web-server host, user, and connection times. The SMI tables provide the syssessions table with the connected value. I cannot run a date function on it. The Admin Ref manual says only that it is "Time that user connected to the database server" . I cannot find any other explanations. I had hoped I could get a datetime year to second so I could calculate duration of connections from the Web-server hosts. Any ideas? Thanks, Laurie
connected is a UNIX epoch, you can convert it to datetime with a dbinfo function: > select dbinfo('utc_to_datetime', connected) from syssessions; (expression) 2011-01-13 14:25:33 2011-01-13 10:24:57 -or- if you just want to know how much time has elapsed, you can convert the result to an interval: > select (sh_curtime - connected) units second::interval hour(4) to second from syssessions, sysshmvals; (expression) 0:01:34 4:06:09 Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, 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 Thu, Jan 13, 2011 at 2:20 PM, LAURIE S. LITTLEDIKE < laurie.littledike@usurf.usu.edu> wrote: > Trying to diagnose Web-server issues, so I'm creating a history of IDS 11.5 > session data to track Web-server host, user, and connection times. The SMI > tables provide the syssessions table with the connected value. I cannot run > a > date function on it. The Admin Ref manual says only that it is "Time that > user > connected to the database server" . I cannot find any other explanations. I > had hoped I could get a datetime year to second so I could calculate > duration > of connections from the Web-server hosts. > > Any ideas? > > Thanks, > > Laurie > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636c5b45f91aa1f0499bf5f9d
Thanks, so much, Art. I appreciate your expertise. Laurie From Art Kagel: connected is a UNIX epoch, you can convert it to datetime with a dbinfo function: > select dbinfo('utc_to_datetime', connected) from syssessions; (expression) 2011-01-13 14:25:33 2011-01-13 10:24:57 -or- if you just want to know how much time has elapsed, you can convert the result to an interval: > select (sh_curtime - connected) units second::interval hour(4) to second from syssessions, sysshmvals; (expression) 0:01:34 4:06:09 Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, 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 Thu, Jan 13, 2011 at 2:20 PM, LAURIE S. LITTLEDIKE < laurie.littledike@usurf.usu.edu> wrote: > Trying to diagnose Web-server issues, so I'm creating a history of IDS 11.5 > session data to track Web-server host, user, and connection times. The SMI > tables provide the syssessions table with the connected value. I cannot run > a > date function on it. The Admin Ref manual says only that it is "Time that > user > connected to the database server" . I cannot find any other explanations. I > had hoped I could get a datetime year to second so I could calculate > duration > of connections from the Web-server hosts. > > Any ideas? > > Thanks, > > Laurie > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >