(Alan Yaung) The ability to make automatic decisions is becoming more critical in content management systems. However, for a growing number of use cases, the embedded decision rules in an application might not meet the complex requirements of a rapidly evolving business environment. Therefore, a ded

(Keith McDonald) In Curt Cotner’s recent blog post, What’s new in statement-level performance metrics, he wrote about the popularity among customers of Optim Performance Manager (OPM)’s ability to create and visualize histograms of statement costs. In this post, I’m going to take a look at histogram

(Lockwood Lyon) Database management systems (DBMSs) have simultaneously simplified and complicated the lives of many IT workers. Error codes passed from the database back to the application can take on more than 1000 values. What level of error checking should developers include in applications?

(Grant D. Taylor) There are many reasons for incorporating binary Jar files into a WebSphere Integration Developer (hereafter called Integration Developer) module or library for execution in WebSphere Process Server (hereafter Process Server). There can be some existing Java resources developed by a

(Dave Beulke) Last week’s blog about making money with DB2 10 got some interesting comments, mostly related to how management only complains and does not really give us anything even after the performance is improved and we save the company a lot of time and CPU resources.

(Leon Katsnelson) Last week I blogged about the rise in importance of location-based data. The timing was not a coincidence. I am a bit of a gadget freak and last week was a pretty important event in the world of gadgets and technology in general. For the first time ever Apple, a company specializin

(Troy Coleman) I consider the REORG utility to be one of the most important tools in the DBA toolbox. It’s also one of the toughest utilities to understand. REORG is used to improve data access and reclaim fragmented space. It can run on the table space as well as the index space.

(Antonio Cangiano) I’m glad to report that we’ve just released a new version of DB2, namely DB2 Express-C 9.7.2. This version — of what is arguably the most advanced hybrid database system in the world — is (as usual) absolutely free to develop with, deploy in production, and even redistribute.

(Maksym Petrenko and Paul McInerney) Choosing proper partitioning keys is important for optimal query performance in IBM DB2 Enterprise Server Edition for Linux, UNIX, and Windows environments with the Database Partitioning Feature (DPF). To help with this task, this article provides new routines to

This chat introduces the spatial capabilities of IBM relational databases, focusing on the DB2 LUW Spatial Extender. Much of the business data that we work with has a spatial characteristic, such as customer or office locations, sales regions, hazard polygons or facilities such as utility lines and