Hello,

When I tried to import a very big file to a table, I got the error of transaction log full. I have to split the file several times in order to load the data. Does anyone know how to resize DB2 V8.1 transaction log?

I'd appreciate your suggestion.
Christine

Here is a better idea:

Use COMMITCOUNT n on the IMPORT command.

This will perform a COMMIT after every n records are imported. I would recommend a value of 1000 for n.

Hi,

It was written a lot of this topic. One of them I have already answered this question. Plese visit the following link.

Please also search this forum. I have found some links.

Hope this helps,
Grofaty

Thank you guys. I managed to change the log file size, and that problem never happen again.