Re: Alter Fragment - LTX

Sadagopan, Sathish, CFCTR wrote: > > Hi, > I did an 'Alter fragment table xyz init in same_dbspace' > to compress the table.After the statement ran for some time I got the -458 > error , Long Transaction Aborted. > I have continuous logging running to a tapedevice.The logs were getting > backed up and freed as the statement ran. > The Last Checkpoint kept advancing to current logical log or the one before > current logical log . > Then how can it hit a long transaction in this case ? Because the transaction started in log #n, you have m logfiles and you used >m/2 logfiles through the ALTER FRAGMENT and other transactions while the ALTER was still running. You need to add more log files. I would recommend doubling the number you currently have if you have the disk space to spare. Art S. Kagel