bi******@in.ibm.com wrote:
Hi ,
During some bulk loading of data .. I am frequently encountering the
"Transaction Log Full " error . I am using the " import " command with
"commitcount" being 1000.
Even with such a low commitcount I get this error . As suggested I
have increased the LOGFILSIZ, LOGSECOND,LOGPRIMARY values. The
LOGRETAIN, and USEREXIT value is OFF.
Still I get this error.
Is n't there any method to empty the log file. As i hhave read .
frequent commit does the same. But I am not successful.
Maybe you have some triggers firing that cause additional data modifications
that need to be logged? Also, if you insert long records, say 4000 bytes
each, then 1000 inserts can already amount to 4 MB log space (unless
compression etc. comes into play). This is even more because log records
are written for page allocations (when the table grows).
--
Knut Stolze
DB2 Information Integration Development
IBM Germany