Re: A little nervous about "one for all"

David E. Grove wrote: > Sorry-- this was supposed to go under "Stripe and Mirror Everything" thread. > >>Would it be good to use a variaton on an old trick by creating a >>(meaningless) table, and stuffing it with a few MBs of data. Then, if we >>ever inadvertently completely fill the whole dbspace (rootdbs), I could >>delete the table to make some breathing room. You don't even have to stuff it with data (which takes log space to delete). You just allocate a big initial extent. Yes, you can do it. With 9.40 in particular, there is much less reason to be concerned. You can add extra chunks even if the initial chunk is full - the chunk table can be extended onto other chunks. (I'm probably using the wrong terminology, to boot.) You could consider adding surplus logical logs - you could drop the extras later. The empty table is probably better, though. As long as you monitor your system and check on how full your big rootdbs is, and give warnings with ample time to spare, I probably wouldn't bother with the dummy table. But it won't do much harm either. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/