Personal tools
You are here: Home Forums DB2 can we delete the transaction logs
Navigation
Log in


Forgot your password?
 
Document Actions

can we delete the transaction logs

Up to DB2

can we delete the transaction logs

Posted by abcd at January 11. 2010

Hi my db has setup circular logging ,




and i am planning to delete the transaction logs is this a best practice ?? as my SQLOGDIR has occupied alomost 15GB space with transaction logs .




so what is the best practice to reduce the occupied size of the transaction logs ?? what is the best approach in this case ?? can any body suggest me






Regards


kanak


Re: can we delete the transaction logs

Posted by perallis at January 14. 2010

You can't delete transactions log. When you are using circular logging the DB2 reuses the number of logs defined on LOGPRIMARY and LOGSECOND.


Powered by Ploneboard
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls