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?TALK TO EXPERTS
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
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