(Knut Stolze) All major vendors of database systems provide extensions for text indexing and text search. If the full power of those products is not needed, IBM DB2 index extensions are a powerful mechanism to implement light-weight text indexes using user-defined index structures. In this article,

(Alex Osuna, Jawahar Lal and Bobby Oommen) As the need for uninterrupted availability of enterprise data is growing, more businesses are striving for 24×7 system availability and can’t afford any downtime. In this era of continuous information availability, the complete and rapid recovery from a dis

(Willie Favero) If someone has a performance question, one of the best first responses is “What traces are running?” After all, how can you determine if something is not doing what you expect (within the parameters you expect), when you have no idea what it’s doing. It can be a real problem. You don

(Roger Sanders) As conference season approaches, it’s time to step up your studying. Try these sample questions to help you prepare for the DB2 9 DBA certificiation exam. The questions originally appeared in the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Gui

(Robert Catterall) For a long time, many of us in the DB2 community didn’t pay a whole lot of attention to code pages (referring to the standard representations of numbers and letters and other characters within computer systems). There didn’t seem to be much of a reason to think about this particul

(Chuck Ballard, Joseph Baric, Ajay Gupta, Holger Kirstein, Rajesh Naicken and Nilesh Ozarkar) In this IBM Redbooks publication, we provide an overview of the high availability and enterprise replication features of the Informix Dynamic Server (IDS) Version 11, which can simplify and automate enterpr

(Troy Coleman) Last week I reviewed concepts and terms that are used to explain how DB2 filters and retrieves rows of data based on different types of predicates. I also offered some general rules for coding efficient SQL.

(Benjamin Lieberman) Valuable business information should never be left sitting around. It should be organized and saved into a permanent data store. In the past, these data stores were represented by large filing rooms filled with cabinets. Today, the same goal is achieved by using relational and o

(Willie Favero) I’m back with my Friday APAR hunt. This week I thought I would concentrate a few HIPERs. They are more critical and there are probably more folk tracking them on a weekly basis.

(Kent Milligan) Is there a command in sql that I can execute in order to show me the relation between all the tables/files used in my system application? (R)