Key Challenges

A leading US retailer had a large IBM DB2 implementation on their mainframe that was consuming huge amounts of processing power. The client needed recommendations to reduce the MIPS being processed.

Ready to experience?



Identified and optimized high processing power consuming jobs for improved efficiency

The solution enabled a recommendations system for the client, which implemented key changes.

A total reduction of 371 MIPS was achieved

Optimized the client’s mainframe, boosting efficiency

High-CPU-usage jobs identified and optimized

Created indices replacing the CURSOR in the DB2 program with an unload step

Removed improper usage of OUTER JOIN, arranging columns in WHERE clause to ensure index usage

Reduced the number of iterations performed by the program

Implemented recommendations in the test region and verified the MIPS savings