- Monitoring/Tracking Performance on a regular basis is vital
- There is a lot of information available, and some of it is outside the DB2 statistics and accounting records.
– You must know/learn other areas such as CICS/IMS, MVS, DASD, etc, etc - After the physical application design and SQL coding Buffer Pool are the big tuning Lever.
- The Basics of performance Don’t change….
Regular tracking of performance, and performance ‘history’ is critical to maintain the health of your system. When someone complains about performance, it is quite important to know if this is a new problem, something has recently degraded, and has always been running poorly.
The basics of performance have not changed within my three (plus) decades in this industry, they will not change within the next decade, and probably will not change when most of you are retired and playing golf or fishing.