Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.