Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Informix Topics / March 2008

Tip: Looking for answers? Try searching our database.

how long instance has been up

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Floyd Wellershaus - 27 Mar 2008 23:21 GMT
Hi,
Does anyone know which table in sysmaster or some other easy way to get the number of seconds an instance has been up ?
The onstat commands give you the answer in number of days plus hours etc...
I'd like to find a table where that data exists, and then I can do a datetime function on it to determine the number of seconds, so that I can get that value into a script easily.

Thanks,
Floyd


Floyd Wellershaus - 28 Mar 2008 11:06 GMT
Freeekin Awesome Art !!!

----- Original Message -----
Subject: Re: how long instance has been up
Date: Thu, March 27, 2008 18:59
From: "Art S. Kagel (Oninit)" <art@oninit.com>
> > Hi,
> > Does anyone know which table in sysmaster or some other easy way to
[quoted text clipped - 82 lines]
> > Informix-list@iiug.org
> > http://www.iiug.org/mailman/listinfo/informix-list
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.