Dave Beulke

Actions speak louder than words. So if you want to be appreciated as a DBA, save your company big bucks and CPU resources.
These days it seems everyone is running out of CPU capacity on their UNIX machines and on the mainframe. With pureQuery you can provide a way to help your company save real [...]

DB2 Java Performance Standalone Transactions Part 2
By David Beulke

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 [...]

DB2 Java Performance Standalone Transactions Part 1
By David Beulke

In previous blog entries I have talked about transaction scope, how Java applications access the database too much and transaction units of work (UOWs) are not really analyzed properly.

Too often these days the design and development are done in an Agile or SCRUM type of [...]

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 activities and excessive CPU usage.
Too often, when the application was designed, [...]

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 complete [...]

Control Java Application References to the Database
One of the first standards and principles neglected in the Java applications that I have seen is that the application references the database too many times to complete a single transaction. While it is good to use your ORM database interface, the architect and application programmer should know how [...]