(Peter Bendel and Steffen Lang) A major trend in business intelligence is to create actionable results and use them to drive operational business decisions in call center or back-office applications. The best way to take advantage of such results in the context of operational business processes is b

(Willie Favero) Yup, one more… this one is different than the rest though. I’m not going to preach to you about improved performance and/or reduced CPU usage. You already know that. In fact, in a lot of cases you are going to get both when you rebind in DB2 9. But that’s still not going to convince

(Sing Li) To create, test, and deploy a Web-based application or Web service rapidly, you need a proven relational database, a standards-compliant Web application server, and a flexible IDE. Ideally, all these software packages are production-tested, simple to obtain, easy to use, and well integrate

(Alex Woodie) Ever wished you could access and edit your DB2/400 records directly from a Web browser? If so, perhaps you should check out iData, a new tool recently introduced by Profound Logic. The use of AJAX and other Web 2.0 techniques provides an extremely fast and intuitive way to access the d

(Roger Sanders) The DB2 database administration exam can be a challenge, even to experienced DBAs. Practicing in advance, with sample questions that resemble the kinds of questions on the actual exam, is one of the best ways I know of to prepare. Each week, I’ll be posting two new sample questions a

(Willie Favero) This morning I was chatting via SameTime with Pat Bossman (IBM DB2 Optimizer Team) about EXPLAIN and Visual Explain. Somehow we started to discuss who is actually responsible for the performance of the SQL developed for an application program. Pat commented “What a good question for

Yesterday, when helping out a friend who was working on a project that required porting an application from Oracle v9.2.0.5 to SQL Server 2005, he ran into the same UNIQUE index issue as we had blogged before. Since that was a major requirement by the client, this project needed to support having mu

(Vincent McBurney) The IBM Federation Server can run on the Information Server or standalone – either way it can benefit from the latest DB2 fix packs with some Federation and Wrapper fixes.

(Willie Favero) Upgrades to DB2 for z/OS Version 8 are now moving along quite nicely. There are now (and have been for a while now) have more customers running on DB2 Version 8 than on DB2 Version 7. This is good news not only because V7 is going out of service in 6 months, but because Version 8 has

(Mei Selvage, Ray W. Ellis and Daniel T. Chang) In an SOA world, business process and data modeling are closely related. Most business processes need to manipulate some sort of data. Data supports business processes to accomplish desired business results. When you use a Model-Driven Development (MDD