The IT department at Banco BPI, one of Portugal’s five largest financial groups, has three major objectives: fulfill customer needs, stay ahead of the competition, and keep costs down. To meet these objectives, the IT department has transformed into a bimodal organization, with one group dedicated to legacy applications and the other to new digital and mobile services. Most of the bank’s production data is maintained in a mainframe IBM® Db2® database that serves both groups. Keeping the bank’s five terabytes of data and 500 million daily SQL requests running reliably and at peak performance is essential to the bank’s business.
For more than a decade, the IT department has relied on BMC Performance for Db2® SQL to provide visibility into and control of the Db2 environment.
The bank is increasingly exploiting the multifaceted capabilities of Performance for Db2 SQL to improve Db2 efficiency, speed response, and reduce mainframe costs.
- By eliminating SQL issues, IT is shrinking the time it takes to run batch jobs—from 90 minutes to less than 30 minutes in some cases.
- By maximizing Db2 database operation efficiency, IT maximizes online transaction speed, cutting response times by up to 50%.
- Maintaining detailed data on SQL queries facilitates audits and reduces audit preparation time.
- By tuning SQL of new applications in the QA environment, IT ensures optimum performance in the production environment.
“With BMC Performance for Db2, we’re able to meet our objectives. We keep our customers happy and we can deliver services in a way that’s competitive with the largest banks, all while keeping our costs down.”— Armando Arranja, Database Administrator, Banco BPI