Hints and tips
During our exercises in this book, we also found some items that we would like to document here as important for your planning and implementation steps towards a Passive Autonomics and Active Autonomics strategy.
DB2 Stored Procedures
DB2 provides two Stored Procedures: ADMIN_UTL_MONITOR and ADMIN_UTL_EXECUTE. Using these stored procedures with the DB2 Administrative Task Scheduler, we were able to:
•Detect which objects had out-of-date statistics due to lack of RUNSTATS utility and then were able to alert (and recommend that RUNSTATS ...
Get Modernize Your IBM DB2 for IBM z/OS Maintenance with Utility Autonomics now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
