Re: Transaction log

Re: Transaction log

 

  

hi

Plan for intermediate commits.

thiru


----- Original Message -----
From: "PremnathJ " <db2udbdba-ezmlmshield-x74310550.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Friday, July 11, 2003 5:20 PM
Subject: Transaction log


> Hi,
>
> When i run a bulk insert query in DB2 i get an error Transaction Log Full.
>
> How do i solve this problem. I even increased my transaction log size from
250 to 20000 and still get the same error.
>
> How do i truncate the transaction log?
>
> Thanks
>
> Regrds
> Prem
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>



DB2 & UDB email list listserv db2-l LazyDBA home page