467,106 Members | 1,279 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,106 developers. It's quick & easy.

Transaction Log full.

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.

Please suggest some way to solve this problem.

Thanks
Bikash

Mar 26 '06 #1
  • viewed: 3642
Share:
3 Replies
<bi******@in.ibm.com> wrote in message
news:11**********************@z34g2000cwc.googlegr oups.com...
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.

Please suggest some way to solve this problem.

Thanks
Bikash


Make sure that the directory where your logs are located has enough free
space. You can also try lowering the commitcount..
Mar 26 '06 #2
Mark A wrote:
<bi******@in.ibm.com> wrote in message
news:11**********************@z34g2000cwc.googlegr oups.com...
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.

Please suggest some way to solve this problem.

Thanks
Bikash


Make sure that the directory where your logs are located has enough free
space. You can also try lowering the commitcount..


Disk space is not the issue unless DB2 is giving the wrong error code.
If the Log Is Full, the options are to increase the log space or commit
more frequently as indicated.

Bob
Mar 26 '06 #3
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
Apr 3 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by TZoner | last post: by
3 posts views Thread by Thiko | last post: by
3 posts views Thread by Bucfan1 | last post: by
2 posts views Thread by francois1@verismall.com | last post: by
4 posts views Thread by yashgt@gmail.com | last post: by
reply views Thread by flobroed@googlemail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.