As data volumes and streams continue to grow, driven by everything from online commerce to social media feeds, efficient database management is becoming ever more challenging for IT. And when you consider the realities of shrinking IT budgets and reductions in human resources and technical skills, automation emerges as a compelling solution.
One enterprise customer we recently worked with had specific requirements for an automation solution for their IMS system that were focused on optimal CPU usage, functional capabilities, strategic advantages, and OpEx savings. These are common requirements that you might recognize.
For this customer, we broke the problem down into two main concerns – monitoring database exceptions and implementing conditional reorgs.
For monitoring database exceptions, without automation this was a time-consuming manual process requiring complex analysis by highly skilled staff. With automation, databases are monitored by policies, with exceptions triggering email notifications and providing detailed help to assist with problem resolution. And yes, our solution co-existed with the customer’s existing processes.
Implementing automation required some work up front to identiry what to monitor and how, by creating a monitor list and defining and assigning policies. It also involved identifying who will be notified if an exception is detected and the type of notification they should receive, along with identifying what will trigger the exception and assigning a notification list to the policy.
For conditional reorgs, their longstanding database maintenance window for online reorgs was staggered throughout a four week cycle. Reorg jobs were scheduled to execute during defined windows, with no time or resources to evaluate reorg criteria. The benefit of our solution is that automation determines whether a reorg is even necessary, with no manual intervention required. Reorg jobs continue to be submitted by their job scheduler but will only execute if needed, which of course saves time and resources.
Ultimately, our automation solution achieved all of the customer’s initial goals. CPU usage testing showed incremental performance improvements for individual reorg utility and proactive exception notification and conditional reorgs are now a reality for this customer. They concluded that the performance of the individual utilities together with the functionality and automation capabilities demonstrated process improvements and real business value.