RE: Timestamp of last archive
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