Two Java Items to Check to Improve DB2 Performance

With DB2 10 coming out and the IDUG North American Conference this week, there should be another great opportunity for further information about the new release.

One problem is that too many shops have DB2 performance problems with existing Java applications and not even all the new DB2 10 features and enhancements will help solve these issues because the issues are not with DB2 but with the servers and applications delivering transaction to DB2.

Many Java application systems are having issues and here are two items to look at within your Java DB2 systems.

Garbage Collections

The Java applications with DB2 performance issues usually have other Java problems with their Java Virtual Machine (JVM).  Within the Java processing, the various application services frequently are required to dump a large amount of memory through their Java garbage collections.  This can be related to the poor coding within the framework such as Hibernate, iBatis and Spring.  Sometimes more than 25% to 50% of the time is spent in garbage collections and is a huge impact on overall performance.

Server Busy Time Percentages

Next Java application systems are served up to the mainframe through typically UNIX or Windows servers.  Ask about their server busy time percentages.  Many of these distributed environments have been consolidated and virtualized and now are starting to stress out now that they have real work loads and DB2 performance requirements.  If the server busy time is over 7% raise this as a performance issue because these small server environments of only quad or duo processors are now working harder than ever.  The server busy time affects transaction performance, commit scopes and other DB2 activities. If your application is waiting around it is never a good thing.

So see you at IDUG! Stop by my booth and attend my presentation to say, “Hi.”

_____________________________________________________

Dave Beulke is an internationally recognized DB2 consultant, DB2 training and DB2 education instructor.  Dave helps his clients improve their strategic direction, dramatically improve DB2 performance and reduce their CPU demand, saving millions in their systems, databases and application areas within their mainframe, UNIX and Windows environments.

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>