3 Areas to Verify When Experiencing DB2 Performance Degradation

When you experience DB2 performance degradation, you’ll discover no one has changed anything (of course), or admits to changing anything. Luckily there are a wide variety of DB2 performance dependencies to check. When DB2 processes are running consistently well, then suddenly the DB2 performance reports show degradation, or users start to complain, there are many . . . → Read More: Three DB2 Performance Areas to Verify When Experiencing DB2 Performance Degradation

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

DB2 Pool Performance

We’ve talked about CICS transaction performance improvements and security performance improvements. Now let’s check into the Sort Work, EDM, RID and Buffer Pools.

DB2 Sort Work Pool

. . . → Read More: DB2 Pool Performance