If this is a one off case and if you are not really bothered about recovery try the following

alter table <tabname> activate not logged initially;
execute your insert statement
commit;

Hope this helps...

Rgds
Deepak

-----Original Message-----
From: Birendra Kumar Kabi Satpathy [mailto:db2udbdba-ezmlmshield-x18723865.[Email address protected]
Sent: Thu 12/23/2004 1:18 PM
To: LazyDBA Discussion
Cc:
Subject: Transaction Log Full




Hi All
I have 10,00,000 records to be inserted in a table(but not
through LOAD but we need a simple INSERT statement)
I'm Getting a TRANSACTION LOG FULL after running for some time..

MY CONFIGURATION SETTINGS ARE
=================================
LOGFILSIZE 20000(4kb)
PRIMARY LOG 5
SECONDARY LOG 5
APPHEAPSIZE 1024(4kb)
BUFFPAGE 250(4kb)
SORTHEAP 2000(4kb)

BUFFERPOOL 32K

TABLESPACE using this BUFFERPOOL

Plz respond if anybody has any permanent solution to this problem,
whatever the number of records may be..

Thanks
Birendra



---------------------------------------------------------------------------------------------
This message, including any attachments, contains confidential information intended for a specific individual and purpose, and is intended for the addressee only. Any unauthorized disclosure, use, dissemination, copying, or distribution of this message or any of its attachments or the information contained in this e-mail, or the taking of any action based on it, is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail and delete this message.


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





DISCLAIMER:
This message contains privileged and confidential information and is intended only for the individual named.If you are not the intended recipient you should not disseminate,distribute,store,print, copy or deliver this message.Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted,corrupted,lost,destroyed,arrive late or incomplete or contain viruses.The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version.

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