Re: database reorg for large databases?
When using alter you may want to consider generating your own checkpoints
WARNING not tested just cooked it up because i lost the original....
so check it please....
dbaccess sysmaster <<!
create procedure mycheckpoint()
define dirty decimal (4,3);
let dirty = 0;
while (1=1)
select sum ( lru_nmod / ( lru_nfree + lru_nmod))
into dirty
from syslrus;
-- if buffer cache is more then 75 % dirty then checkpoint!!!!!
if ( dirty > 0.75 ) then
system "onmode -c";
else
system "sleep 5";
end if
end while
end procedure
!
before loading set LRU_MAX_DIRTY and LRU_MIN_DIRTY in your
onconfig to 99
bounce your engine
then execute the spl and start your loading/alter etc.
have cut load times in half doing this... checkpoint writes are MUCH
more efficient then lru writes when huge ammount of data is loaded/rewritten.
however this does not beat HPL in express mode; it comes close though....
and if alter etc do not forget to set and configure PDQ!!!
ahum when done before bounceing the engine do not forget to
create a checkpoint!!!!!!!!
See you
Superboer.
"Obnoxio The Chav" <obnoxio@serendipita.com> wrote in message news:<1110652728.b5b1b0fb7d8e3c37ac9ba5ef2b8f76ae@teranews>...
> Neil Truby said:
> > "Obnoxio The Chav" <obnoxio@serendipita.com> wrote in message
> > news:1110625934.b94f20f7f1c78aa594cba514b25ed174@teranews...
> >>
> >>
> >> Darren_Jacobs@carmax.com said:
> >>
> >> Option 4
> >> Table by table reorg using ALTER FRAGMENT.
> >
> > Isn't that what I said?
>
> Was it? I don't know -- I never pay any attention to anything you say.
>
> --
>
> Bye now,
> Obnoxio
>
> "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule"
> - Coluche
>
> "I'm trying to see things your way, but I can't get my head up my ass"
> - JCH
>
> "Ogni uomo mi guarda come se fossi una testa di cazzo"
> - Marco
>
> Travel broadens a person. You look as if you have been all over the world.
>
> I went to the airport to check in and they asked what I did because I
> looked like a terrorist. I said I was a comedian. They said, "Say
> something funny then." I told them I had just graduated from flying
> school.
>
> -- Ahmed Ahmed
>
> http://members.rogers.com/2remedy/images/smilies/banners/RTFM.gif
> sending to informix-list