Birendra,
Take a backup of the transaction log files, and free that.
Regards
saiprasad
"Chen Wei-Cheng "
<db2udbdba-ezmlmshield-x76874624.[Email address protected]
12/22/2004 11:53 PM
To: "LazyDBA Discussion" <[Email address protected]
cc:
Subject: Re: Transaction Log Full
use import & set commitcount:
for ex: import from xxx.del of del commitcount 2000 insert into xxx.table
Birendra Kumar Kabi Satpathy <db2udbdba-ezmlmshield-x18723865.[Email
address protected] wrote:
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
-----------------------------------------------------------------------------------------------------
如果你能告訴我你心目中的英雄是誰？我就能告訴你，你的一生會有什麼結果。－－巴菲特
另一種投資 - 富爸爸門徒的願望，故事與實體
---------------------------------
Do You Yahoo!?
登記免費的 @yahoo.com 中文電子郵件 @ Yahoo! Mail.
Get your free @yahoo.com address at Yahoo! Mail.
---------------------------------------------------------------------
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