An Introduction to db2mon
The monitoring table functions are the best way to view Db2 monitoring statistics. Being able to use SQL to query the monitoring data is great but most of the metrics are cumulative since database activation. We created db2mon to perform deltas and produce reports.
As some of you may have noticed the developerWorks site that hosted the very useful and famous HADR wiki has been sunset. But, the good news is we migrated this over to a new location that can be found here ==> https://ibm.github.io/db2-hadr-wiki/.
In general, a change to the database cfg parm LOGFILSIZ requires the database to be bounced (DEACTIVATE/ACTIVATE) cleanly, meaning no inflight/open transactions (e.g. no indoubt transactions or async undo through DB2_ONLINERECOVERY).
In knowing that when there is any form of database recovery, such
Db2 for Linux, UNIX, and Windows Version 11.5 GA comes with the tech preview of a new feature called “Advanced Log Space Management” (ALSM). Although this new feature still has some limitations and isn’t ready yet for productive use, I’d like to show you how it works and its benefits.
Db2 11.5 is here and with it comes a bunch of new features and changed behaviors in the area of Availability & Recovery that should make your every day tasks easier. Check out the list that includes items like Advanced Log Space Management, Reduced Logging and better HADR Reads on Standby.