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
Recent releases of Db2 have introduced new SQL functionality that improves the functionality and productivity of application developers. But the DBA can also take advantage of some of the “new” Db2 SQL to improve their own productivity.
Trying to figure out the ins and outs of Db2 Log Space Management? Spent too much time trying to figure out what settings are best for your environment? Look no further than Db2's new Advanced Log Space Management.
How to automate Db2 for z/OS utility jobs from application programs? Have you considered DSNUTILU stored procedure as a part of DevOps? Learn more in this article.
Why have agile development and DevOps techniques been adopted for software development over long-standing techniques like the waterfall approach? It all comes down to improved collaboration resulting in faster development and therefore a quicker return on investment.