Mark A wrote:
> <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..
>
>
>

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