(Pamela Siebert, Veronica Gomes and Manjula Panthagani) The new IBM Informix Warehouse Feature provides an integrated and simplified software platform to design and deploy a warehouse repository on your existing IBM Informix Dynamic Server (IDS) infrastructure. This tutorial, the second part of a se

(Robert Catterall) One of the things I really like about attending DB2 conferences is the face-to-face time I get with people who otherwise would be on the other side of e-mail exchanges. I get a whole lot more out of in-person communication versus the electronic variety.

(Dave Beulke) Recently working with a client’s SOA environment showed several interesting performance issues. One performance issue that was quite stunning was the large number of connections that the .Net and Java application were making to DB2 and other systems. Researching the system and applicat

(Shenfu (Mike) Fan) This article shows you how to configure and generate monitoring events in a WebSphere Message Broker message flow. Monitoring events are very useful built-in features for transaction monitoring and auditing, and this article describes them in detail.

(Craig Mullins) When a UNION is required to put together data from multiple queries, you might be able to use a CASE statement instead. This is very useful, particularly when the data for each of the queries in the UNION come from the same table. The CASE statement can potentially enhance performanc

(Troy Coleman) IBM continues to innovate to improve DB2 performance and availability. An example of this is the new RANDOM option, which I discussed last week. Found on the CREATE/ALTER INDEX statements, RANDOM stores an ever increasing sequential key index into random locations to help avoid the cr

(Misa Sakamoto) Learn how to use the Technology Explorer (TE) for IBM DB2 to control user and group authentication to DB2 through the use of a security plug-in called db2auth. The plug-in uses a DB2 database for storing authentication information instead of an external authentication repository, suc

(Chris Eaton) I’ll write a few blog posts on DB2 pureScale Scalability to keep them into bite sized pieces for all. As I add more postings I’ll update the links below so you can move between all the separate postings.

(Willie Favero) Things seemed to be going pretty well that bright sunny morning. then, without warning, “the phone call” comes in. It’s that feared complaint that nothing in DB2 seemed to be running. DB2 users are complaining that they have been waiting for the proverbial “forever”, waiting for thei

(Shalom Momi Sabag) In the previous post I started talking about the REORG utility with the shrlevel change option. I told you about two problems that one would probably encounter when running online REORG with the default parameter values: