FW: Physical Log Size

Posted in 2004

Murray Wood (IList) — Fri, 5 Mar 2004 13:17:02 +1300 — source: Usenet: comp.databases.informix

html??? The Clown doesnt like it. Informix version? Exact Message? Size of the table in Mb? How many logical logs and size? LTXHWM in $ONCONFIG? -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]On Behalf Of Phillips, Rob Sent: Friday, 5 March 2004 10:05 a.m. To: informix-list@iiug.org Subject: Physical Log Size I am trying to update the structure on a table that has approx 1.8million records and I get an error that my log size is too small. Is there any formula to determine how large I need to make the log to accommodate this change and is there any correlation between the physical log size and the number and size of the logical logs? Currently physical log size is 50000 sending to informix-list