While doing DB2 performance reviews for clients over the years, I’ve discovered that many times their projects are using Hibernate as their DB2 Object Relational Mapping (ORM) interface. While DB2 and Hibernate can produce tremendous performance there are many best practices to achieve that goal. The following DB2 Hibernate performance improvement techniques will help your . . . → Read More: DB2 Hibernate Performance Improvements
As your Java workload continues to grow, your application monitoring and SQL performance needs to be improved within the system and application coding. The following techniques will help you monitor, improve and streamline your DB2 Java application performance.
First, know your application connections and threads. When doing performance reviews of a client’s DB2 applications, . . . → Read More: DB2 Java Application Performance: Monitoring and SQL Improvements
One of the presentations that I did at the IDUG Berlin conference was “Java DB2 Developer Performance Best Practices.” This speech covers all the interesting Java application designs, coding consideration and database related best practices I have found over the years doing application performance tuning for a wide range of industries. Interestingly the main questions . . . → Read More: Java Database Exception Handling
Last week I talked about three important Java DB2 performance best practices that can help prevent performance problems before they get into production. Unfortunately, the comments from readers indicated that the Java DB2 performance problems are already in production and the database is being blamed. Proving the database is not the issues always . . . → Read More: Three Items to Improve Java Performance
Check out my video on “Building Scalable Data Solutions in a Changing Regulatory Landscape.”
These days Java systems have grown within the corporate software landscape because they provide a flexible language for running programs on all types of platforms. Unfortunately, the Java language, like any software language, can suffer from bad . . . → Read More: Three Important Java Performance Best Practices
Sleep is over rated. Sleepless from too many time zone changes from clients to then jumping on a plane and presenting at the IDUG conference in Vienna was great but a challenge. The baby two seats away from me had a bad flight over and I felt so sorry for Mom trying everything to stop . . . → Read More: IDUG Europe and DB2 Java Performance
Another situation when a transaction runs into problems is when it must check something outside of the critical transaction path or its normal activity. For example, when a transaction uses seven different discrete web services to accomplish a complete transaction unit-of-work and after the third web service runs into . . . → Read More: DB2 Java Performance Standalone Transactions Part 2
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