is it possible to define such a trigger on a table that once the table
is X megabyte, or the has over 10000 records, the table is purged?

thanks a lot

>> is it possible to define such a trigger on a table that once the table is X megabyte, or the has over 10000 records [sic:rows are not records], the table is purged? <<

CREATE TRIGGER Flush_at_10K_Rows
AS ..
IF (SELECT COUNT(*) FROM Foobar) >= 10000
THEN DELETE FROM Foobar
END IF;

I cannot think of a good way to look at the physical file size, which
different from the row count.

> I cannot think of a good way to look at the physical file size, which
> different from the row count.

Perhaps you could do something with the sysibmadm.snaptab view.