Re: Instance startup time
Hi,
query the table sysshmvals from sysmaster database.
This should help.
Dani
"Rulesh Felix Rebello" <rrebello@fsl.org.jm> wrote in message news:<bm1k1u$kl3$1@terabinaries.xmission.com>...
> Place the following lines in a file and execute the file ....u'll get the
> Day, Date, Month Year and Time when the Informix engine was last brought
> up...
>
>
> grep MSGPATH $INFORMIXDIR/etc/$ONCONFIG|grep -Ev "#.*MSGPATH" |read garb
> logfile
> logfile=`echo $logfile|cut -d"#" -f1`
> N=`grep -n ALARMPROG $logfile|cut -d":" -f1|tail -1`
> N=$(($N-5))
> tail +$N $logfile|head -5
>
>
>
> regards...
> __________________________________________________
> Rulesh Felix Rebello
> Informix DBA
> Off # 1-(876)-927-1125 X 3831
> Cell # 1-(876)-853-5702
>
>
>
>
>
> -----Original Message-----
> From: owner-informix-list@iiug.org
> [mailto:owner-informix-list@iiug.org]On Behalf Of R'diger M'hl
> Sent: Wednesday, October 08, 2003 8:31 AM
> To: informix-list@iiug.org
> Subject: Instance startup time
>
>
> 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
>
> sending to informix-list