SEO

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.




--
DG

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
"I think not," said Descartes, and disappeared.

Sorry-- this was supposed to go under "Stripe and Mirror Everything" thread.

DG


> 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.
>
>
>
>
> --
> DG
>
> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
> "I think not," said Descartes, and disappeared.
>
>

"David E. Grove" <david_grove@correct.state.ak.us> wrote in message
news:10kerbu2g9jid09@corp.supernews.com...
> 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.

Annoyingly, it probably would.
From a job satisfaction point of view though it's quite a shaming thing to
do though, isn't it?!

As shaming as my having different colour xterm sessions, with production in
red, to protect me from myself, as I have the attention span of an A .. er,
a goldfish.

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/

Neil Truby wrote:

>As shaming as my having different colour xterm sessions, with production in
>red, to protect me from myself, as I have the attention span of an A .. er,
>a goldfish.
>
>
>
>
I have mine in dark blue with white writting. Microsoft have made it
"the new red".

--
Scott Burns
Mirrabooka Systems

Tel +61 7 3857 7899
Fax +61 7 3857 1368

On Wed, 15 Sep 2004 01:30:15 -0400, Neil Truby wrote:

> "David E. Grove" <david_grove@correct.state.ak.us> wrote in message
> news:10kerbu2g9jid09@corp.supernews.com...
>> 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.
>
> Annoyingly, it probably would.
> From a job satisfaction point of view though it's quite a shaming thing to
> do though, isn't it?!
>
> As shaming as my having different colour xterm sessions, with production in
> red, to protect me from myself, as I have the attention span of an A .. er,
> a goldfish.
Production windows open in black on white for me. I also have the attention
span of

Art S. Kagel

Yes, shameless, shameless :-)

But, I'd be even more ashamed if I didn't have a way out, if (when?) I mess
up.

But, based on Jonathan's comments, sounds like this is unnecessary.




"Neil Truby" <neil.truby@ardenta.com> wrote in message
news:2qq2b0F10frg7U1@uni-berlin.de...
> "David E. Grove" <david_grove@correct.state.ak.us> wrote in message
> news:10kerbu2g9jid09@corp.supernews.com...
> > 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.
>
> Annoyingly, it probably would.
> From a job satisfaction point of view though it's quite a shaming thing to
> do though, isn't it?!
>
> As shaming as my having different colour xterm sessions, with production
in
> red, to protect me from myself, as I have the attention span of an A ..
er,
> a goldfish.
>
>

"Scott Burns" <scott@mirrabooka.com> wrote in message
news:xJQ1d.1120$aA.40795@news.optus.net.au...
> Neil Truby wrote:
>
>>As shaming as my having different colour xterm sessions, with production
>>in
>>red, to protect me from myself, as I have the attention span of an A ..
>>er,
>>a goldfish.
>>
>>
>>
> I have mine in dark blue with white writting. Microsoft have made it "the
> new red".

LOL!