<bikkaran@in.ibm.com> wrote in message
news:1143351909.835247.320350@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..