[Info-ingres] Installation and Server start time

[Martin Bowes]

Thanks Paul,

That second version isn’t as jaw dropping as the first.

It occurs that this information should be available in dbmsinfo. I should raise a request for that.

Marty

From: Paul Mason [mailto:latepaul at gmail.com]
Sent: 21 June 2018 09:44
To: Martin Bowes
Cc: info-ingres at lists.planetingres.org
Subject: Re: [Info-ingres] Installation and Server start time

or this:

\p\g
select min(date(gmt_timestamp(session_time))) from ima_server_sessions_extra
where session_time != 0
Executing . . .


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



On Thu, 21 Jun 2018 at 09:39 Paul Mason <latepaul at gmail.com<mailto:latepaul at gmail.com>> wrote:
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<mailto: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<mailto: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/a1aa5d42/attachment.html>