RE: Physical Log Size (Error Updating Table Structure)

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

It looks like you have some flexibility to change the logging mode of the database, at least temporarily. In that case, one option to try would be to change the logging mode to no logging and try, then set the logging mode to what you want. Another option is to set the table type to raw and try, then change the table type to standard "ALTER TABLE tablename TYPE (STANDARD)". Raw tables do not log. Hal Maner M Systems International, Inc. www.msystemsintl.com "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

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