Re: How to load table without log

Posted in 1997

Michal Hajek — Thu, 23 Oct 1997 15:02:37 +0200 — source: Informix-list mailing list archive (1991-1998)

Adam Sorati wrote: > > Eng: online 7.23.UC1 > OS: AIX 2.4.1 > HW: 1x166Mhz CPU, 128MG RAM and 2x4.5GIG disk. > DB: 1.3 GIG > > Could someone please advise me of the best way to load > a table without using the logical log. I am getting a long > transaction error and the logical log is currently very large, > 360 MG for a 1.3 GIG DB. my solution for v.5xx: i would use "dbload" - I can do commits as often I want - for example after every 1000 rows... I do not need to stop transactions, logs are filled and backuped continuosly. Michal -- -------------------------------------------------------------- Michal Hajek mailto:hajek@nspuh.cz Sprava NIS http://www.nspuh.cz NsP Uherske Hradiste phone : voice +420 0632 529 204 Purkynova 365 fax +420 0632 551 014 686 68 Uherske Hradiste Czech Republic --------------------------------------------------------------