HOW TO clear inactive DB2 LUW transaction log files

How to clear inactive DB2 LUW transaction log files is a solution to a common problem. Before we discuss how to prune the inactive transaction logs we’ll need to establish which log files are inactive. It is important to identify which logs to delete. If you delete an active transaction log file, you will cause an outage on the database Note: Log files located in the transaction log path cannot be removed with 'db2 prune history xxxxxxx and delet' if database configuration 'LOGARCHMETH1' is set to 'LOGRETAIN'. Before you start any activity , speak to the owners and users of... Read more →