<div dir="ltr">or this:<div><br></div><div><div>\p\g</div><div>select min(date(gmt_timestamp(session_time))) from ima_server_sessions_extra</div><div>where session_time != 0</div><div>Executing . . .</div><div><br></div><div><br></div><div>┌─────────────────────────┐</div><div>│col1 │</div><div>├─────────────────────────┤</div><div>│13-jun-2018 11:11:05 │</div><div>└─────────────────────────┘</div><div>(1 row)</div></div><div><br></div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr">On Thu, 21 Jun 2018 at 09:39 Paul Mason <<a href="mailto:latepaul@gmail.com">latepaul@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">This works in imadb:<div><br></div><div><div>* \p\g</div><div>select date(gmt_timestamp(e.session_time)) from ima_server_sessions_extra e, ima_server_sessions s</div><div>where</div><div>e.server = s.server</div><div>and e.session_id = s.session_id</div><div>and s.session_name = ' <Dead Process Detector>'</div><div>Executing . . .</div><div><br></div><div><br></div><div>┌─────────────────────────┐</div><div>│col1 │</div><div>├─────────────────────────┤</div><div>│13-jun-2018 11:11:05 │</div><div>└─────────────────────────┘</div><div>(1 row)</div></div><div><br></div><div>Note that there's a space at the beginning of the session name. </div></div><br><div class="gmail_quote"><div dir="ltr">On Thu, 21 Jun 2018 at 09:07 Martin Bowes <<a href="mailto:martin.bowes@ndph.ox.ac.uk" target="_blank">martin.bowes@ndph.ox.ac.uk</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-GB" link="blue" vlink="purple">
<div class="m_649401958255860713m_-2475400249929260817WordSection1">
<p class="MsoNormal">Hi All,<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Is there some way I can ask the server when it was started? When the installation was started?<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">There certainly isn’t a dbmsinfo setting which provides that detail in 10.2.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">I’ve trawled through imadb and can’t see anything obvious to a bear with little brain.
<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">The only thing I can come up with is grep ‘Server.*Startup’ $II_SYSTEM/ingres/files/errlog.log | tail -1<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">And that sorta sucks.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Any ideas?<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Martin Bowes<u></u><u></u></p>
</div>
</div>
_______________________________________________<br>
Info-ingres mailing list<br>
<a href="mailto:Info-ingres@lists.planetingres.org" target="_blank">Info-ingres@lists.planetingres.org</a><br>
<a href="http://lists.planetingres.org/mailman/listinfo/info-ingres" rel="noreferrer" target="_blank">http://lists.planetingres.org/mailman/listinfo/info-ingres</a><br>
</blockquote></div>
</blockquote></div>