DB2 Sub-System Tuning
EPV for DB2 Critical Events provides a complete view of the “health” of all DB2 sub-systems by collecting a set of measures, such as:
- Logging delays
- Thread and RID pool failures
- Buffer pool and global buffer pool internal thresholds violations.
EPV for DB2 Resources analyzes the amount of system resources used by DB2 Address Spaces (Master, DBM1, IRLM, DIST and Stored Procedures), deadlock and timeout events up to the impacted applications, DBD and EDM pool usage, Buffer and Global Buffer Pools hit ratios and read rates.
DB2 Applications Tuning
EPV for DB2 Workload provides complete control of all the workloads connecting to each DB2 subsystem. Utilizing extensive drill-down capabilities, workload performance and consumption can be explored at the connection type, plan, authid, correlation id, transaction and plan level. Easily eliminate loops and abnormal behaviors, check sysplex balancing and perform more effective application tuning activities.
DB2 Day-to-Day and Proactive Tuning
EPV for DB2 Trends provides daily and monthly critical events, resources, throughput and workload trends. Daily trends provide a key element in day-to-day tuning activities. Easily compare one day to another and spot anomalies in just a few mouse clicks. Monthly trends support a proactive approach and long-term tendencies become apparent before they can impact DB2 sub-system performance.
All reports are produced in simple static HTML pages and can be accessed by your favorite browser. All report tables can be exported individually or combined to an MS-Excel spreadsheet.
Access to available data
EPV for z/OS uses standard measures available in the z/OS environment and supports various sources, such as ITRM (IT Resource Management), MXG (Merrill’s eXpanded Guide), or native SMF, RMF, and IMS data, limiting the number of variables, using intelligent filters and avoiding data duplication and redundancy. The product’s architecture is modular and user-friendly.
Requirements
EPV for DB2 is available in two versions: Standard or Plus
The requirements for EPV for DB2 Standard are:
- Availability of an SAS System Base module at least on a PC;
- Availability of one of the following products: SAS ITRM or MXG
EPV for z/OS Plus has no pre-requisites; it’s an “out-of-the-box” solution which integrates a “light” version of the EPV parser for SMF product to interpret the necessary SMF records and all other input data required.