Banca Marche optimizes consumption and reduces the costs of using its mainframe thanks to Primeur
All the main applications at Banca Marche depend on IBM’s DB2 for z/OS. Both batch and on-line systems were increasing in CPU consumption and were pushing the mainframe beyond its established performance threshold. The significant increase in costs that would be incurred focused attention onto doing a detailed analysis of the most critical on-line and batch applications that were using DB2 and identifying those with the worst performance. Optimising these systems, particularly those supporting the bank’s core business, could potentially minimize or even eliminate the required increase in processing power and hence avoid cost increases.
Primeur’s Spazio DB2 Expert was chosen by Banca Marche to identify and subsequently optimize the critical applications. Spazio DB2 Expert is a specialized tool for monitoring DB2 applications on z/OS that identifiesthe programs and static SQL commands responsible for the highest CPU consumption.
- An easy to use solution, allowing the staff of Banca Marche to become immediately operational
- Low use of resources for DB2 optimization.
- Possibility to leave the solution always active, precisely because of the low resource use.
- Secure and non-intrusive monitoring of DB2.
- Easy interpretation of the information collected.
In addition, Spazio DB2 Expert also provided information on some of the more frequent problems such as;non-optimal processing sequences, repeated searching for inexistent data, data conflicts repeated several times for the same SQL command, and other error situations.
Avoidance of significant cost increases was achieved as a result of cutting processing consumption by as much as 50% for critical applications, batch and on-line, identified and analysed by Primeur's Spazio DB2 Expert. For some queries, the tests performed resulted in a reduction of CPU consumption by more than 90%. Not only did Primeur help Banca Marche realize significant
savings on infrastructure costs, there was also a noticeable improvement in system quality.
Following the success of this initial project, Banca Marche is now evaluating the use of Primeur’s Spazio DB2 Expert on applications in a test environment in order to optimize queries before they are migrated to production and to reduce the amount of testing currently carried out by the Database Administrator (DBA).