DB2 subsystems tuning
EPV for DB2 Critical Events provides a complete vision of the “health” condition 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 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. Utilising extensive drill-down capabilities, you can explore workload performance and consumption at the connection type, plan, authid, correlation id, transaction and plan level.
Using EPV for DB2 Workload you can easily eliminate loops and abnormal behaviours, check sysplex balancing and perform more effective application tuning activities

DB2 day by day and proactive tuning
EPV for DB2 Trends provides daily and monthly critical events, resources, throughput and workload trends.
Daily trends will be a key element in day by day tuning activities. By EPV provided functions you can easily compare one day to another and spot anomalies in just few mouse clicks.
Monthly trends will assist you in adopting a proactive approach and understand long term tendencies before they can impact your DB2 subsystems performance.

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), TDS (Tivoli Decision Support) and CA-MICS. EPV optimises data collection by using existing summarised data, limiting the number of variables, using intelligent filters and avoiding data duplication and redundancy. The product’s architecture is modular and user friendly. EPV can be installed on most of the popular hardware and software platforms available on the market.

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 “browser”. All the tables provided in the reports can be exported individually or together in a MS-Excel spreadsheet.

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

The interface to collect input data is designed to optimise performance and consumptions of the loading phase, avoiding duplication or loss of data. It uses simple exits, that adapt the product to the environment characteristics; a set of ready user exits for each data type to is provided.

The engine to correlate and aggregate data builds a standard SAS relational Data Base, containing only those metrics used by the product and automatically aggregated at the monthly, daily and hourly level. You can customise the product by setting the appropriate parameters and values to keep in your EPV Performance Data Base for your desired retention time periods.

The engine to produce the HTML pages can be customised to:
• Report daily resource and workload statistics for any desired period,
• Report daily and monthly trends for any desired period,
• Report top consumers in DB2 by connection type (batch, CICS, DDF, IMS, TSO, WEBSPHERE, etc.),
• and much more…

Requirements
The requirements for EPV for DB2 are:
• Availability of a SAS System Base module on any platform;
• Availability of one of the following products: SAS ITRM, MXG, IBM TDS or CA-MICS.

Trial
In order to perform an EPV for DB2 trial you need to send an e-mail to EPV Technologies or to our local representatives specifying "EPV for DB2 trial" in the subject.