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
________________________________________________________________________

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