.: ITGAIN . DB2 EEE Tuning

Client: Premiere PayTV Hamburg

Premiere is Germany's largest pay-TV provider with over 3 million subscribers.
The goal of the project was to attain performance improvements to meet service-level agreements and save on hardware costs. 150 days of CPU run-time per year could be saved.

Project Details

Duration: 08/2003 - 01/2004

Task

Analysis with Speedgain for DB2
Coaching of applications developers, UBD Performance Workshops
SQL Tuning
Quality back-up procedures
Alteration of the back-up parameterization: back-up time shortened by a factor of 3
Bufferpool optimization with Speedgain for DB2
Establishment of special analyses for the use of the data warehouses with help from Speedgain for DB2

IT-Technology

Speedgain for DB2
Windows 2000 Advanced Server Cluster
DB2 EEE




	DB2 EEE Tuning Client: Premiere PayTV Hamburg Premiere is Germany's largest pay-TV provider with over 3 million subscribers. The goal of the project was to attain performance improvements to meet service-level agreements and save on hardware costs. 150 days of CPU run-time per year could be saved. Project Details Duration: 08/2003 - 01/2004 Task Analysis with Speedgain for DB2 Coaching of applications developers, UBD Performance Workshops SQL Tuning Quality back-up procedures Alteration of the back-up parameterization: back-up time shortened by a factor of 3 Bufferpool optimization with Speedgain for DB2 Establishment of special analyses for the use of the data warehouses with help from Speedgain for DB2 IT-Technology Speedgain for DB2 Windows 2000 Advanced Server Cluster DB2 EEE