SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-19-2008, 07:02 PM
| ||||
| ||||
 RE: Instance startup time 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  wner-informix-list@iiug.org]On Behalf Of Rüdiger MählSent: 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      |
|
04-19-2008, 07:03 PM
| ||||
| ||||
| 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 wner-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 |
Linear Mode
