can we delete the transaction logs
Up to DB2can we delete the transaction logs
Posted by abcd at January 11. 2010Hi 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. 2010You 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