Skip to Content
0
Former Member
Nov 24, 2009 at 03:46 PM

DB 2 import - transaction log full

96 Views

All,

Please help me to clarify this.

While performing the import, import monitor fails with transaction log full error and all the import stops.

I looked at db2diag.log file and could not find any error related to transaction log full. Log_dir has enough space. I had set it to max of 220 file and only 63 files used so far. No archiving enabled.

In notify log file, I saw "active log is full"

DB is db2 9.7 and OS is redhat linux 5

Any idea about this ?

Thanks!

Edited by: rkandy on Nov 25, 2009 3:53 PM