DB2 Performance Summary Part 3

Make sure that the interface with CICS works well to improve performance:

Validate the settings between your DB2 CICS transaction configurations. Make sure the maximum workload from one TOR, AOR or DOR is not overwhelming another CICS processing partner. If your system is heavily dependent on CICS transactions: Make sure that you are reviewing the . . . → Read More: DB2 Performance Summary Part 3

Taking Advantage of Relational Technology Part 4

Once you have reviewed the overall system for the aspects that we have discussed over the last few months, it’s time to drill down into your more critical transactions and processes. Critical transactions are those frequently executed transactions that are using excessive CPU or I/O resources. For this analysis using a performance monitor is necessary . . . → Read More: Taking Advantage of Relational Technology Part 4

CICS: Security Performance Improvements Using DB2

Over the last two posts, I gave you an overview of a DB2 system that needed performance improvements.Here we are going to delve deeper into the problems and recommendations.

DB2 Performance Discoveries and Recommendations

The operating system, CICS and DB2 systems were operating efficiently and managed well within the overall environment. As the number of . . . → Read More: CICS: Security Performance Improvements Using DB2

DB2 System Analysis Case Study (cont.)

In this post, I’ll delve a little deeper into the system architecture and CPU reduction opportunities found in a major DB2 system at a large financial institution.

Analysis

. . . → Read More: DB2 System Analysis Case Study (cont.)

DB2 Case Study Introduction: DB2 Performance and Throughput

Every client is different and working in a variety of different environments helps me understand different systems, applications and DB2 database design performance aspects and what works and doesn’t work. Over the next few weeks, I’ll be highlighting for you how to improve the DB2 performance . . . → Read More: DB2 Case Study Introduction: DB2 Performance and Throughput