Rollback the uncommitted transaction holding the oldest log.
Now this transaction really ought to be rolling itself back.
To find out if it is in rollback, confirm there is rollback activity going
on when the txn log fills up:
db2 reset monitor all # initialise monitor counters
db2 update monitor switched using bufferpool on
db2 get snapshot for database on dbalias | egrep "Log pages read" # will be
> 0 if app is in rollback

Also search for "Appl id holding the oldest transaction"
The (per partition) monitor element at V8:
=> db2 "select appl_id_oldest_xact from table (snapshot_database ('', -1))
as dbsnap"
then force the application. This last is the fun bit, we DBAs have to get
our job satisfaction from somewhere.

Regards
Alex Levy
Sustainable Software Ltd.
-----Original Message-----
From: Sakib R Saikia
[mailto:db2udbdba-ezmlmshield-x45692765.[Email address protected]
Sent: 30 March 2006 08:09
To: LazyDBA Discussion
Subject: How to clear transaction log


I am unable to perform any operations, and I get the message that
transaction log is full whenever I try to perform an delete/insert. Can
you please suggest how to clear the transaction log.

Thanks & Regards

Sakib R Saikia

Application Development and Web Services
IBM India

DLF Silokhera, Sector 30, NH 8, Gurgaon-122001 Email:
sakib.r.[Email address protected]
______________________________________________________________________
Camp: C/o BTVL, Desk No. B-58, A-236, Okhla Industrial Area 1, Ph: +91 11
41706000 X 3916


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



-----------------------------------------------
Scanned by 186k-NetCleanse, spam and virus protection



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