This article will help DB2 DBAs and Users to proactively monitor their most critical and live systems on continuous basis without any impact to production and analyze the data on key points to identify any possible DB2 health/hang/performance issues and fix them.
My wife and I set a goal early in our married life. It was to pay for our daughters’ university education (at a school of their choosing) so they could start their adult lives debt free. We were able to keep that promise, in part due to the opportunity to tune DB2.
The second entry of this month’s theme, DB2 for z/OS performance, is a video by Thomas Baumann covering “Tuning Explained to C-level”. Take the time to watch this great video by one of IDUG’s Hall of Famers. Because, as important as tuning your system, is explaining what you did to your management.
Cutting SAP Down To (a Manageable) Size
The DBA wouldn’t touch it as there are 83,000 tables in SAP. He was busy with other applications, and he had no time in dealing with a big package that was a mess.
For as long as I've been involved with IDUG, performance tuning has always been one of the most popular subject areas for conference presentations and technical articles. From the wide range of possible topics in this area, two perennial favourites are buffer pool tuning and indexing strategies.