DB2 logs can fill by doing a series of updates without a commit....Other
applications may have updates at the same time, but the logs do not flush
until a commit.

Not saying this is always the case, but it is usually one of the first
things you look for.

The fact that you killed only 1 application leads me to believe this was
the case....Ask the user, if known, about the SQL that was being run, or
consult the output of the snapshot....Were they using a cursor to issue
multiple changes....versus opening a cursor, doing a singleton update and
closing the cursor....

Best of Luck,

John Askew
Alpharetta, Georgia




"David Wilson
\(Interactive
DBA\) " To
<db2udbdba-ezmlms "LazyDBA Discussion"
hield-x73897030.x <[Email address protected]
[Email Address Removed] cc
a.com>
Subject
05/23/2005 09:16 Excessive log usage
AM









Hi,
My DB2 8.1.5 AIX 5.1 database stopped because of a 'transaction log full'
event.
I determined from the db2diag.log that agentid id 980 was holding and so
did
a snapshot of that agent before forcing him off. Everything went OK.
I determined from the output of the snapshot that his UOW log usage was
2604
bytes.
If he is only using 2604 bytes how can he fill the transaction logs?
Is there any other way of telling who is using the log space?
Thanks,

Dave




**********************************************************************
The information contained in this e-mail may be confidential. It is
intended
only for the use of the named recipient. If you are not the named recipient
please delete this e-mail. If you have received this e-mail and are not the
named recipient, any disclosure, reproduction, distribution or other
dissemination or use of the information contained in this e-mail is
strictly
prohibited.
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.
Registered Office:
Camelot Group plc
Tolpits Lane
Watford
WD18 9RN
Tel : 01923 425000
Registered in England & Wales
No. 2822203
**********************************************************************



________________________________________________________________________
This e-mail has been scanned for all viruses by Star. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________


---------------------------------------------------------------------
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