The latest version 4.2 of ITGAIN’s performance management solution
Speedgain for DB2 offers several extensions to improve the efficiency of database monitoring.

The extended OS Monitoring offers detailed operating system performance metrics and reports that act as the basis for an integrated root cause analysis. This new feature in conjunction with existing Speedgain database metrics delivers a complete and unified picture of the whole operating system and database together filling the performance reporting gap.

With workload oriented monitoring the user is able to choose from predefined workload categories and monitoring levels in respect to the different requirements of the database, e.g. SAP or OLTP systems. This minimizes the costs of monitoring as well as the overhead on the monitored system.

ITGAIN’s Speedgain V4.2 completely supports the new DB2 V10 feature multi-temperature data management functionality. ITGAIN, in a statement by Thomas Kalb, CEO confirms the vast potential benefit and sustainability of this V10 feature in the latest IBM presentation. Below an excerpt of this presentation¹ is given:

Speedgain's new Status Monitor shows the current state of all monitored servers and databases in one complete view. Combined with the workload oriented monitoring data centers with large number of databases can now be monitored more effectively.

Speedgain V4.2 also supports DB2 pureScale providing detailed information both for members and the cluster facility of a pureScale cluster.

¹ Go to www.monash.com/uploads/DB2-10.ppt for the complete presentation.

Thanks for your participation and active feedback. You find the recorded webinar stream and the slides on the right hand side. For any questions regarding the presentation feel free to contact Norbert directly at norbert.munkel@itgain.de.

The following topics were discussed:

• Why should I do Benchmarks?
• Overview of existing benchmark suites (TPC-C, TPC-H, other)
• Why the big benchmark-suites don’t meet DBA's everyday needs?
• Defining database workloads for benchmarking
• Getting to the data
• Eliminating side effects
• Demo of ITGAIN benchmark approach (Linux and Windows)

ITGAIN is ready to deliver the new version of Speedgain for DB2
including IWH 1.0. The new Version stands out for it's completely
redesigned user interface and new algorithms in processing analyses.

New functions are:

The Information Warehouse IWH in version 1.0 let you show reports
of vital values in the defined monitoring timeframe.

ITGAIN thanks you for participating the webniar "SQL Workload Monitoring
and Tuning" on 18th Januar 2011.

The active and international participation encourages us to collect more topics around DB2 in order to prepare a follow up session. We will announce this follow up in advance here.

Right hand you find the discussed scripts and programs for download.
Also you find the recording webinar.

Specialists from ITGAIN and the IBM Labs in Toronto, Dublin, and Böblingen meet for a 3-day workshop to evaluate the capability of Speedgain to monitor IBM DB2 pureScale.

The team set up a new pureScale cluster and produced a high workload using the ITGAIN benchmark utilities. The goal was to find the perfect setup for DB2 pureScale testing for scalability and pureScale monitoring with Speedgain. Additional pureScale monitoring functionalty for future Speedgain releases was also discussed.

Monitor and tune your databases based on real time and historical performance values gathered from Snapshot monitoring and DB2PD.

Florian Boldt, ITGAIN, Product Manager
Phil Gunning, Gunning Technology Solutions, Principal Consultant

Download webinar pdf here...