In previous blog entries I have talked about transaction scope, how DB2 Java applications access the database too much and transaction units of work (UOWs) are not really analyzed properly.
. . . → Read More: DB2 Java Performance Standalone Transactions Part 1
DB2 Java performance is often a problem because the application processing is emulating the database which executes more efficiently or the processing is poorly designed. Either of these scenarios that my teams have found during performance or design reviews always led to extended I/O . . . → Read More: Design DB2 Performance into Your DB2 Java Transactions
Designing the Unit-of-Work for a given transaction entails many components. Different techniques and methods are incorporated depending on the components such as Hibernate, iBatis, JPA or Enterprise Bean technology to process the transaction. The Java transaction framework and the object patterns incorporated with the components also affect the transaction unit-of-work. All these factors together provide . . . → Read More: DB2 Java Performance: DB2 Design UOW
Control DB2 Java Application References to the Database
One of the first standards and principles neglected in the DB2 Java applications that I have seen is that the application references the database too many times to complete a single transaction. While . . . → Read More: DB2 Java Performance: DB2 Transaction Framework (cont.)
Given the object model of Java and the relational model of the database, accessing data properly continues to be difficult for most Java application developers. Over the history of Java development, there have been many attempts within vendor products, interfaces and open source projects . . . → Read More: DB2 Java Performance: DB2 Transaction Framework
Over the last three years, my clients have shown that multiple frameworks, architectures and programming patterns are usually implemented within the same project. The problem is the poor performance lessons experienced from the application implementation are not fully understood and the performance problems are . . . → Read More: DB2 Performance is Java Performance: Holy Grail (cont.)
When getting my taxes ready every year, I review the previous year’s activity. Reviewing 2008 has shown that the majority of my consulting was spent fixing and tuning DB2 Java based systems. This is not . . . → Read More: DB2 Performance is Java Performance: Holy Grail
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
Happy New Year!
Be Proactive with your DB2 Performance
Is it? Well, I know everyone is worried about the economy, but the best way to stay employed is to be proactive. Proactive is not that difficult it is just being extra helpful and providing extraordinary service.
For example recently helping a client, I was asked . . . → Read More: Be Proactive With Your DB2 Performance