(Markus Lorch) Get an introduction to “Easy Semantic Search,” a new functionality introduced in IBM OmniFind Enterprise Edition V8.4 that enables end-users to leverage the power of semantic search to query for concepts through the well-accepted keyword query paradigm. Follow the steps outlined in th

(Chris Eaton) Now that I have described a lot of the details of the db2pd tool, let’s look at how you can use it in the event of a DB2 software failure.

(Gene Fuh and Terry Purcell) In prior releases of DB2, the optimizer’s cost estimates were hidden from view in the mysterious “hidden plan tables.” But even if you could get your hands on them, it was generally difficult to determine what to do with the information these tables contained.

IBM’s DB2 has long been a Linux-friendly, cross-platform database. But as of this week, there will be improved coexistence between DB2 and the latest Ubuntu 6.06 Linux release.

(Marianne Nesiem and Lili Zhang) One of the many enhancements of IBM DB2 9 for Linux, UNIX, and Windows is the ability to install multiple copies of the DB2 software on the same server. In this article, you’ll follow step-by-step instructions to learn how to take advantage of this enhancement in an

(Craig Mullins) Two additional new SQL statements available in DB2 Version 9 are the MERGE and TRUNCATE statements.

(Timothy Prickett Morgan) The rumor mill panned out on this one. Two months ago, I told you that I was hearing that IBM was considering upgrading its high-end System i5 595 server with its fastest Power5+ processors, and that has indeed come to pass. In addition to upgrading the i5 595 processors, t

(Willie Favero) Sometimes stuff just all ends up in one place no matter how hard you try to pick a key that will spread the data around. I worked on a system many years ago where we jumped through all sorts of strange hoops trying to insure some kind of even distribution of our index keys to avoid h

(Joe Pluta) Thoreau is considered an optimist. That’s why the statement above has a particularly dark tone to me. Of course, Thoreau was something of a Luddite, so I suppose I can understand his distrust of all things invented. Then there’s the other end of the spectrum, where all that glitters is g

(Craig Mullins) One of the biggest technological advances in DB2 V9 is the ability to combine the management of structured and unstructured data. Basically, V9 will allow you to store data as native XML. This capability has already been introduced into V9 of DB2 for Linux, Unix, and Windows.