Thanks for the input Ann.

Unfortunately, there is no slow period with this product, it's always going
full blast.

However, it appears that in my deletion sproc doing something like :

delete * from sometable where pk=:thepk;
select count(*) from sometable where pk=:thepk into :tempvariable;

This appears to reclaim the space, and doesn't have a huge impact on
performance, although testing isn't complete.


If this is the final solution, thanks to everyone on the list for assisting
me with this rather annoying problem.


Bill

-----Original Message-----
From: Ann W. Harrison [mailto:aharrison@...]
Sent: Friday, November 02, 2001 10:01 AM
To: ib-support@yahoogroups.com; 'ib-support@yahoogroups.com'
Subject: RE: [ib-support] Child Tables Problem Revisited


At 08:58 AM 11/2/2001 -0800, Bill Morrison wrote:

>Now, the tables I'm dealing with hold more than a million records, and the
>application is doing real time (more or less) data capture. Is there a
>different way to "touch" the deleted records so they go away?

If you run gbak during a slow period with garbage collection turned on
you should get your space back.


Regards,

Ann
www.ibphoenix.com
We have answers.


To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/