[Info-ingres] Installation and Server start time

[Paul Mason]

This works in imadb:

* \p\g
select date(gmt_timestamp(e.session_time)) from ima_server_sessions_extra
e, ima_server_sessions s
where
e.server = s.server
and e.session_id = s.session_id
and s.session_name = ' <Dead Process Detector>'
Executing . . .


┌─────────────────────────┐
│col1                     │
├─────────────────────────┤
│13-jun-2018 11:11:05     │
└─────────────────────────┘
(1 row)

Note that there's a space at the beginning of the session name.

On Thu, 21 Jun 2018 at 09:07 Martin Bowes <martin.bowes at ndph.ox.ac.uk>
wrote:

> Hi All,
>
>
>
> Is there some way I can ask the  server when it was started? When the
> installation was started?
>
>
>
> There certainly isn’t a dbmsinfo setting which provides that detail in
> 10.2.
>
>
>
> I’ve trawled through imadb and can’t see anything obvious to a bear with
> little brain.
>
>
>
> The only thing I can come up with is grep ‘Server.*Startup’
> $II_SYSTEM/ingres/files/errlog.log | tail -1
>
>
>
> And that sorta sucks.
>
>
>
> Any ideas?
>
>
>
> Martin Bowes
> _______________________________________________
> Info-ingres mailing list
> Info-ingres at lists.planetingres.org
> http://lists.planetingres.org/mailman/listinfo/info-ingres
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20180621/c079838e/attachment.html>