Instance startup time

#1 (**permalink**) 04-19-2008, 08:02 PM

Hi folks,

I know, I can find the uptime of an Informix instance
in every onstat, but the date and time of the instance
startup?

Has anyone a nifty solution for that?

TIA,

Rüdiger

#2 (**permalink**) 04-19-2008, 08:02 PM

Try onstat -g ntt, and use the open time of the poll or listener threads?

On my system it's a few seconds before On-Line Mode appears in the message
log.

--
Phil@oninit.com

#3 (**permalink**) 04-19-2008, 08:04 PM

"Rüdiger Mähl" <ruediger.maehl@web.de> wrote:

> Hi folks,
>
> I know, I can find the uptime of an Informix instance
> in every onstat, but the date and time of the instance
> startup?

Someone sent me the following solution by personal e-mail:

select dbinfo('UTC_TO_DATETIME',sh_boottime) from sysshmvals;

Which is working for at least 7.31 and 9.30.

Thanks a lot,

Rüdiger

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode