RE: Timestamp of last archive

#1 (**permalink**) 04-19-2008, 10:15 PM

Good idea.

Exact SQL to retrieve the time stamp of the last LO archive is:

SELECT stamp0 FROM sysmaster:sysdbstab WHERE dbsnum = 1

It gives exactly the same data as 'archive' page
of the 'oncheck -pr' output

------------------------------------------
Alexey Sonkin

> From: David Williams [mailto:djw@smooth1.fsnet.co.uk]
>
> "TBP" <TBP@Nospam.Nothere.Co.Uk> wrote in message
> news:c6nq4r$1bcm$1@sp15en20.hursley.ibm.com...
> > Rüdiger Mähl wrote:
> > > Hi folks,
> > >
> > > is there any way to get the timestamp of the last
> > > archive from any [system] table?
> > >
> > > I know about oncheck -pr.
> > >
> > > TIA,
> > >
> > > Rüdiger
> > Not sure about a system table, but onstat -g arc will show the last (2 I
> > think) archive details.
>
> Look at $INFORMIXDIR/etc/sysmaster.sql.
>
> select unique l2date(level0) from sysdbstab gets the date
>
> since l2date does value/86400 and there are 86400 days in a day this must
> be
> a number of seconds
> value so value mod 86400 would be the number of seconds from I guess the
> start of the day???

sending to informix-list

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