Three choices:
1) NOT LOGGED INITIALLY - if you are comfortable with it
2) Chunk your input
3) Why do you logfiles fill up?
DB2 does automated log file maagement if you let it. Not my area of
expertiese, but I'm sure someone in this group knows that side.

Cheers
Serge

TD wrote:
> So Serge, if we are dealing with a couple of million records to update then
> how do you get around log file full conditions etc ?
>
>
>>MERGE doesn't have built-in commit capabilities if that's what you're
>>asking for.


--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab