EPV Technologies mission is to control and optimize hardware and software technologies in order to reduce costs and maintain service levels for z/OS systems.
EPV for Db2 is an “Out-the-box” Performance and Tuning solution for z/OS Db2 environment.
EPV for Db2 provides a comprehensive view of all Db2 environments. It allows for a quick and effective top down analysis of Db2 subsystems and workloads. Using automatic discovery techniques and built-in rules, EPV collects, relates and aggregates all necessary data to provide a complete vision of Db2 subsystems.
With EPV for Db2, performance analysts perform a complete check in just a few minutes, without coding and running SQL programs. EPV solves what has become a critical issue at most sites: the number of Db2 system analysts is barely enough to manage an ever-increasing number of Db2 subsystems. Db2 performance analysis and tuning activities are often seen as a luxury.
EPV highlights Db2 critical events and provides detailed information for all Db2 subsystems. EPV analysis is base on a number of measures such as logging delays, thread, RID pool failures, buffer pool, global buffer pool, internal threshold violations, etc.
EPV for Db2 also analyzes the number of system resources used by Db2 Address Spaces (Master, DBM1, IRLM, DIST and Stored Procedures), deadlock and timeout events up to the impacted applications. It reports on DBD and EDM pool usage, Buffer and Global Buffer Pools hit ratios, read rates and more.
EPV for Db2 provides complete control of all the workloads connected to each Db2 subsystem. Utilizing extensive drill-down capabilities, allows exploring workload performance and consumption at the connection type, authid, correlation id, plan and package level.
EPV for Db2 easily detects and eliminates application loops and abnormal behaviours, check Sysplex balancing and performs more effective application tuning activities.
EPV for Db2 provides daily, weekly and monthly trends for critical events, resources, throughput and workload.
Daily trend analysis allows performing a daily check of complex environments in minutes. With EPV, it is very easy to compare one day to another and detect anomalies in just few mouse clicks. Weekly and monthly trends assist you in adopting a proactive approach and understand long term tendencies before it impacts Db2 subsystems performance.
EPV for Db2 also audits changes in subsystems definition, and system configuration parameters contained in DSNZPARM.
EPV is an “out of the box” solution. It does not require any programming, and all reports are immediately available to anyone who needs it.
All EPV reports are formatted as simple HTML static pages accessible by any Browser. Reports include hyperlinks simplifying navigation and drill-down. Pre-defined navigation paths guide less experienced analyst to detailed information using a top-down approach. All reports provided by EPV can be exported individually or together in Excel spreadsheets.
EPV report generation is completely automated, and usually runs unattended during the night. This means that all Performance, Capacity Planning and Trend analysis reports are immediately available when you arrive at the office in the morning.
EPV for Db2 automatically produces over 400 reports on Db2 utilization
EPV for Db2 automatically creates an exception report identifying most critical issues. All changes made to the Db2 configuration parameters are easily identified through EPV reports. A set of user definable thresholds are available to trigger exception related to performance issues and excessive resource usage.
Alerts can be automatically and selectively distributed to technical groups and managers.
EPV saves up to 90 % of the time requires by technical staff to identify and correct problems, do reporting and performs tuning activities. EPV greatly increases control over the Db2 environment. It allows to recover valuable resources by easily identifying and eliminating Db2 subsystem and application anomalies. EPV for Db2 is constantly enhanced to reflect Db2’s evolution, removing the essential maintenance costs of in-house solutions.
Many EPV for Db2 customers indicated that other performance analysts (CICS, IMS, z/OS, WebSphere and Capacity Planning) don’t have to ask Db2 experts to produce the reports they need. With EPV for Db2, the information is always available to people who need it.
For more information on EPV for Db2, please fill our contact form or send us an email.
SenmeSoft represents several software solution publishers in Canada. Our innovative solutions are primarily aimed at large enterprises. Our solutions meet the management’s requirement for streamlining.
Our software solutions improve productivity and offer more flexibility. Our performance and capacity planning solutions help manage and control resource utilization and quickly detect any anomalies. Our Db2 tools manage and copy databases in a fraction of the time normally required.
✉ Email
info@senmesoft.com
Copyright © 2003-2024 Senmesoft Inc. All Rights Reserved.