Perry Shindle, a DB2 for z/OS Specialist working at PennDOT, recently made a presentation at the IBM DB2 Data Tech Summit held in San Jose, CA in early October. Perry’s presentation was entitled “DB2 for z/OS Autonomics – 2018 Update”. The conference was attended by IBM DB2 customers from all over the US.
Since mid-2015, Perry has been leading a project at PennDOT to implement IBM’s DB2 autonomics solution to make all of their DB2 environments as self-managing as possible. With many DB2 large application databases and a limited DBA staff, it is critical for PennDOT to automate regular database ‘housekeeping’ maintenance work as much as possible.
PennDOT is an early adopter of IBM’s DB2 autonomics solution and has been working closely with IBM and their partner Rocket Software over the last couple of years to implement this solution. Along the way, PennDOT has also provided valuable customer feedback to both IBM and Rocket Software as to how their autonomics solution can be improved. To IBM’s credit, many of our suggestions have already been incorporated into the software through the maintenance stream, and PennDOT has updated their software to take advantage of these new features.
In December of last year, PennDOT participated in a beta test program for a new piece of functionality within the DB2 Autonomics Solution called “Smarter Reorg Recommendations”. This functionality enhances existing DB2 Tooling software to collect database performance data on a scheduled basis. The collected performance data is then analyzed to determine if database performance could be improved if a DB2 reorg utility is run against a DB2 table or index. If database performance would not be improved, then the DB2 Reorg, that would normally be executed, can be totally avoided. This functionality has helped to greatly reduce the weekend database maintenance window at PennDOT. Specifically, since they first implemented DB2 autonomics, the normal weekend DB2 maintenance window has gone from 4 hours down to 15 minutes!
If you are interested in reading more about PennDOT’s journey to DB2 autonomics, please take a look at a case study paper published by IBM that can be found at: https://www.ibm.com/case-studies/pennsylvania-department-transportation