Re: Creating Logical logs

Posted in 1997

Matias — Tue, 23 Dec 1997 18:12:15 +0000 — source: Informix-list mailing list archive (1991-1998)

PRAVEEN MOHANAN wrote: > > Hi users, > > Thanks for the solution. I created a database with log, and > could load the schema of another db. I know only few things of the DBA > stuff. But can anyone please tell me > > 1.how to know how many logical logs are there & what are their > sizes. > 2. How to increase the size of a log. > > 3. I received an error of long transaction when trying to load about > 150,000 rows. .... As far as my understanding of TX-logging goes, you should actually NOT log a big lump of a LOAD. You might as well DROP the indexes, too. Just my 5 Pesetas, ;-) MCM. -- Matthias C. Munzel http://www.iponet.es/~munzel Isla de La Palma mailto:munzel@iponet.es (MIME)