RE: Altering a Large Table

Have you tried altering the table to raw first? That should avoid the long TX. You'll have to set it back to standard and run a backup afterward, of course. --EEM From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Laurie Gustin Sent: Tuesday, June 08, 2010 4:12 PM To: informix-list@iiug.org Subject: Altering a Large Table IDS 10.0 FC8 I'm wondering if there is a trick to altering a large table without running into a large transaction.  I'm trying to add a char(2) field to the end of an existing table - it has 23 cols and about 12 million rows. The total table size is about 2.5 GB,  there is 4GB of logical logs. I'm running the following alter command in dbaccess;     alter table address add add_source char(2); Is there a trick to doing an in-place alter? Thanks Laurie Laurie Gustin IT Programmer Analyst Department of Public Safety lgustin@utah.gov 801-965-4410