Re: Loading data in Table
On 20 mei, 17:20, Juan Pablo <in4mixp...@hotmail.com> wrote:
> Hi all:
>
> In my work I have Informix 10 + HDR and some tables with more than 40 millonres records.
> These tables have more than 50 extents by recreating what I need to resize the extents and reduce the number of extents.
>
> Recalling that I have Informix + HDR my question is as follows... With tools which should make the task of recreating this table:
> unload / loadonunload / onloaddbloadHPL expressHPL deluxeThanks
>
> _________________________________________________________________
> Ingresá ya a MSN en Concierto y disfrutá los recitales en vivo de tus artistas favoritos.http://msninconcert.msn.com/music/archive/es-la/archive.aspx
i would use hpl deluxe mode
since you have HDR you can not use express mode!!!!!
you can not use load this most likely will run out of locks and gives
a longtrx rollback; same for onload,
you could use dbload or write your own stuff.
Speeding it up...
if you can bounce the engine you could Maximize BUFFERS, set LOGBUF
big, maybe 4096 ...
set LRU MAX and mindirty to 99 ,
and use your own
checkpoints
using:
dbaccess sysmaster <<!
create procedure generatechkpt()define dirty decimal (4,3);
while (1=1)
select ( sum(lru_nmod) / sum ( lru_nfree + lru_nmod ))
into dirty
from syslrus ;
if (dirty < 0.75 ) then
system "sleep 1";
else
system "onmode -c";
end if
end while ;
end procedure;
execute procedure generatechkpt();!
that may speed up the thing.
If the data you need to reorg is more then half your database, you
could consider switching of HDR, use HPL express mode no conversion
and when all that is done, reset up HDR.
hmmm > These tables have more than 50 extents by recreating what I
need to resize the extents and reduce the number of extents.
i would start to worry if they are getting close to the limit which is
about 200 so when a table has more then 150 extents, i would
start planning for the above.
Superboer.
way fast=http://www.clipjes.nl/clip/nederlands/n/normaal_-
_oerend_hard.html