RE: Altering a table and Long Transactions
OR add more logican logs ....
Wayne E. Martin
Informix Database Administrator
Kmart Corp.
-----Original Message-----
From: Gadget [mailto:a.colapicchioni@odio.gli.spammers.acsys.it]
Sent: Wednesday, September 20, 2000 9:30 AM
To: informix-list@iiug.org
Subject: Altering a table and Long Transactions
Excuse me for my ugly English and thanks in advance.
When I try to add a column in a table containing 80.000 records, my Informix
Universal 9.2 server tells:
"450: Long transaction aborted"
My database logging mode is unbuffered, the logical log configuration is :
LOGFILES 6
LOGSIZE 1500
I think that the only way to solve my problem is:
create a new table containing old table structure plus my new fields
SELECT old table INTO new table
DROP old table
RENAME the newly created table.
Unfortunately, the old table has integral constraints that I have to drop
and create in the new table.
Right?
Anyone have an alternative and quickest solution?
Best Regards
-----------------------------------------------------
Andrea Colapicchioni
Advanced Computer Systems
Space Division
via L.Belli, 23
00044 Frascati
Rome (Italy)
e-mail a.colapicchioni@acsys.it
-----------------------------------------------------