Download the 
Eccox Clients: Over 35,000 users at some of the most respected companies around the world.
A Fortune 500 telecom with 8 million clients and more than 20 billion records in DB2 tables.
Eccox Advisor for DB2 focused on a single sub-program in online production. The program utilized 80 SQL statements, 10 DB2 tables, and was called by hundreds of transactions.
Eccox Advisor System Analysis revealed that two of the DB2 tables were being heavily accessed and five SQL statements were occupying 99% of CPU.
By changing the indexes and correcting the SQL:
- Response time was dropped by 55%
- Total CPU usage by the program was cut by 99%
Thanks to these efficiencies, planners were able to:
- Reduce annual capacity projections by 30%
- Achieve full ROI within 3 days of product deployment
