The db2 logging process is an old strong process. You must take care of it because if all your active log data sets are not reusable because they are full, your db2 stops until it can offload them in archive logs. The performance of your recovery process is also strongly linked to your active log
Fast INSERT performance speeds the way to getting new data into DB2, for ETL, bulk ingest jobs, and even just day-to-day transactions. In this new blog entry, we look at several helpful tips for making INSERT run as quickly as possible.
Data integrity is an critical feature within every DBMS, and part of integrity is keeping data in a consistent state and recoverable. It all starts in the DB2 log. Martin Hubel describes the role of the log in recovery options gives some thoughts for log management.