Re: Onbar

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. Thanks, carlos -- ------------------------------------------------------------------------------- Carlos Benjamin, Jr. (623) 869 - 2364 Programmer/Analyst/Consultant Currently Assigned to Central Arizona Project mailto:inf999@cap-az.com -------------------------------------------------------------------------------