Re: Onbar

Info Temp wrote: > > Mark D. Stock wrote: > > > The problem with using onstat is that it will always return all logs as > > full. You would get better results by using the SMI tables. Something > > like: > > > > SELECT COUNT(*) > > FROM sysmaster:syslogs > > WHERE uniqid >= ( > > SELECT MIN(tx_loguniq) > > FROM sysmaster:systrans > > WHERE tx_loguniq > 0 > > ) > > AND used = size> > > > This is just off the top of my head because I'm not at the orifice to > > test it. But it might give you a starting point. > > Mark, > > What is the subquery supposed to do for me here? I looked in sysmaster:syslogs and there are 12 rows, same number as > I get out of onstat -l. Of those 12 rows, 10 were used=size. Adding the subquery to sysmaster:systrans gives no rows > found. The subquery includes only used logs. That is, logs that have not been backed up, as all logs appear to be used after you have cycled through them once. Make sure your LTAPEDEV is not set to /dev/null, otherwise your logs will automatically be marked as backed up. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |What year 2000 bug? year 2000 bug? |/// / ////| | |year 2000 bug? year 2000 bug? year |// / /////| | |2000 bug? year 2000 bug? year 1900 |/ ////////| +----------------------+-----------------------------------+-----------+