DB2 Transaction log is full. How to flush / clear it?

Posted by Mestika on Stack Overflow See other posts from Stack Overflow or by Mestika
Published on 2010-04-08T11:32:13Z Indexed on 2010/04/09 0:23 UTC
Read the original article Hit count: 407

Filed under:
|
|
|
|

Hi, I’m working on a experiment regarding to a course I’m taking about tuning DB2. I’m using the EC2 from Amazon (aws) to conduct the experiment.

My problem is, however, that I have to test a non-compression against row-compression in DB2 and to do that I’ve created a bsh file that run those experiments. But when I reach to my compression part I get the error ”Transaction log is full”; and no matter how low I set the inserts for it is complaining about my transaction log.

I’ve scouted Google for a day now trying to find some way to flush / clear the log or just get rit of it, i don’t need it. I’ve tried to increase the size but nothing has helped.

Please, I hope someone has an answer to solve this frustrating problem

Thanks - Mestika

© Stack Overflow or respective owner

Related posts about db2

Related posts about transaction-log