Re: How to load table without log

Posted in 1997

Taras Kopach — Thu, 23 Oct 1997 12:06:46 +0200 — source: Informix-list mailing list archive (1991-1998)

--------------58A02882C5EBF4F237640489 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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. > > The database is using log bufferring, and I only are required to > load one or two tables. > > Thank you for your help > Adam > adams@sgen.com..au You have to turn off transaction logging on this database and after loading turn it back. You can perform this using the ontape utility: ontape -N database_name -- turn off logging <looad your tables> ontape -s -L 0 -B database_name --turn on logging and perform the level0 archive This operations can also be completed using the onbar utility . Good luck , Taras. --------------58A02882C5EBF4F237640489 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit <HTML>   Adam Sorati wrote: <BLOCKQUOTE TYPE=CITE>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. The database is using log bufferring, and I only are required to load one or two tables. Thank you for your help Adam adams@sgen.com..au</BLOCKQUOTE>   You have to turn off transaction logging on this database and after loading turn it back. You can perform this using the ontape utility: ontape -N database_name  -- turn off logging <looad your tables> ontape -s -L 0 -B database_name --turn on logging and perform the level 0  archive This operations can also be completed using  the onbar utility .           Good luck ,                            Taras.</HTML> --------------58A02882C5EBF4F237640489--