Customer Success
One of the major benefits of Eccox/Advisor for DB2 is that it can easily be cost justified. Here are three examples of customer success.
![]()
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
![]()
Financial Services Company with 553 Branches and 3,567 Point-of-Sale Terminals was Consuming 6,500 MIPS
Eccox/Advisor for DB2 focused on overall DB2 applications in an online production environment operating at peak.
Eccox/Advisor System Analysis revealed that two sub-programs were being called by hundreds of transactions.
By creating a new index:
- Total MIPS consumed dropped from 1,290 to 4
- CPU usage in seconds was cut from 8,640 to 19
Thanks to these efficiencies, planners were able to:
- AVOID A CPU UPGRADE
- Achieve full ROI within 2 days of product deployment
- Estimate a 2-year savings of $25 million
![]()
Financial Services Company with 400 Branches and 3,000 Associated Bank Branches was Consuming 1,100 MIPS in an Online Production Environment
Eccox/Advisor for DB2 focused on all DB2 applications being used for vehicle quotation transactions.
Eccox/Advisor System Analysis revealed that two programs were the primary users of CPU capacity and there was a table mismatch.
Via a simple SQL correction, the customer:
- Improved response time
- increased number of daily transactions 18-25%
Thanks to these efficiencies, planners were able to:
- Reduce overall use of CPU by 7%
- Achieve full ROI within 3 days of product deployment
- Estimate a 3-year savings of $2.65 million
For more details on these success stories, click here

