EPV for Db2 provides you with Db2 subsystems tuning and Db2 applications tuning, daily trends for day-by-day check, weekly and monthly trends for proactive tuning.

Db2 subsystems tuning

EPV for Db2 Critical Events provides a complete vision of the “health” of all Db2 subsystems 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 analyses the amount of system resources used by Db2 Address Spaces (Master, DBM1, IRLM, DIST), 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 Workloads provide complete control of all the workloads connecting to each Db2 subsystem. Utilizing extensive drill-down capabilities, you can explore workload performance and consumption at the connection type, plan, authid, correlation id, plan and package level. Using EPV for Db2 Workloads you can easily eliminate loops and abnormal behaviours, check sysplex balancing and perform more effective application tuning activities

Db2 day-by-day check and proactive tuning

EPV for Db2 Trends provides daily, weekly and monthly critical events, resources, throughput and workload trends. Daily trends allow you to perform a daily check of even complex environments in minutes. Using EPV provided functions, you can easily compare one day to another and spot anomalies in just a few mouse clicks. Weekly and monthly trends will assist you in adopting a proactive approach and understand long term tendencies before they can impact your Db2 subsystems performance. EPV for Db2 also audits DSNZPARM and other subsystem definition changes.

Access to available data

EPV for Db2 uses standard measures normally available in the z/OS environments and supports various sources, such as ITRM (IT Resource Management), MXG (Merrill’s eXpanded Guide) or native SMF data.

Using “de facto” Standard Technologies

All reports are produced in simple static HTML pages published on a server of your choice and can be accessed by your favourite internet browser. All the tables provided in the reports can be exported individually or together in a MS-Excel spread sheet.

Architecture

EPV for Db2 architecture is based on the following three layers:
• An interface to collect data input;
• An engine to correlate and aggregate data;
• An engine to produce HTML pages.

Requirements

EPV for Db2 has no pre-requisites; it’s an “out of the box” solution which integrates a light version of the EPV zParser product to interpret the needed SMF records and all the other input data required.

EPV for Db2 can also run on top of SAS. In this case the requirements are:
• Availability of a SAS System Base module at least on a PC;
• Availability of one of the following products: SAS ITRM, MXG.