RE: Physical Log Size (Error Updating Table Structure)
How often are you performing a commit point? I would suggest that you
commit after every 500 updates.
-----Original Message-----
From: Neil Truby [mailto:neil.truby@ardenta.com]
Sent: Monday, March 08, 2004 12:51 PM
To: informix-list@iiug.org
Subject: Re: Physical Log Size (Error Updating Table Structure)
You need to add more logical logs, or split your update up into smaller
tranches.
"Phillips, Rob" <RPhillips@ce-a.com> wrote in message
news:c28ule$tr7$1@terabinaries.xmission.com...
>
> Version: IDS 7.31.UC8
> Size of table in MB: 240MB
> # Logical logs 20 Size 2000K
> Physical log size 50000k
> LTXHWM: 50
> LTXEHWM: 60
>
> I tried setting logging to unbuffered logging via ontape and updating
> the table but I got the same error: -458 Long transaction aborted.
>
> I am trying to update a field in the table from a Char(50) to a
> VarChar(250). Any help is appreciated.
>
> -----Original Message-----
> From: Murray Wood (IList) [mailto:ifxmaillist@quanta.co.nz]
> Sent: Thursday, March 04, 2004 7:17 PM
> To: informix-list@iiug.org
> Cc: Phillips, Rob
> Subject: FW: Physical Log Size
>
> 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
sending to informix-list