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

Effects of Compression on DB2 Performance

Another place to look for DB2 performance results is to research the use of compression.

Using DB2 Compression

Researching another aspect of one of the main tables showed that the table was not leveraging DB2 compression. Since it has almost a million rows, a long record length and was probably referenced more for retrieval than . . . → Read More: Effects of Compression on DB2 Performance

Taking Advantage of Relational Technology Part 3

Last time we talked about excess tablespace scans, list prefetch and index scans. Let’s look further into potential application performance issues.

Lack of Data Access Reviews

Having good application and SQL review processes in place for testing, and quality assurance are vital for overall guarantees of application performance. One of the best ways to facilitate . . . → Read More: Taking Advantage of Relational Technology Part 3

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