RE: How to clear transaction log

Run a database backup.

Douglas Kostelnik
Senior Database Administrator/Architect
[Email address protected]
AAA Auto Club South
(813)-289-1342

-----Original Message-----
From: Sakib R Saikia
[mailto:db2udbdba-ezmlmshield-x45692765.[Email address protected]
Sent: Thursday, March 30, 2006 2:09 AM
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

<html>
 <align=justify> 
_____________________________________________________________ 
The information transmitted is intended only for the person(s) or entity to which it is addressed and may contain confidential and or privileged material and should be treated as a confidential AAA Auto Club South communication. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer.
</html>

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