Oninit cdi / Archive
Talk to an expert →

Timestamp of last archive

Posted in 2004

Topics: General Discussion

=?ISO-8859-1?Q?R=FCdiger_M=E4hl?= — — source: Usenet: comp.databases.informix

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

↪ replying to =?ISO-8859-1?Q?R=FCdiger_M=E4hl?=
TBP — — source: Usenet: comp.databases.informix

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.

↪ replying to TBP
David Williams — — source: Usenet: comp.databases.informix

"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???

Related threads