(Vitor Rodrigues) pureQuery is a high-performance Java data access platform focused on simplifying the tasks of developing, managing and optimizing applications and services that access data. It consists of tools, APIs and a runtime engine. The previous articles in this series introduced the two pro

(Roger Sanders) Try these two sample questions to help you prepare for the DB2 9 DBA certification exam. Then, try past questions here. All questions are from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press and are reprinted with

(Ramchandra Raikar) This document provides information about how to determine if an index needs rebuilding and how to monitor index rebuilds to know if they have completed.

(Steve Brodsky) It is hardly surprising that there is a certain amount of interest among our customers over the relationship between the two pures that are shipped from IBM Information Management. As the architect for pureQuery, here’s my perspective on it.

(Erika Von Bargen) This article provides a step-by-step guide to creating plug-ins for IBM’s OpenAdmin Tool (OAT) for IBM Informix Dynamic Server (IDS). The newest administration tool for IDS has recently gotten even better with the addition of the new Plug-in Manager feature. It is now extremely ea

(Gene Cobb) In a previous article titled “Maximize SQL Query Engine (SQE) Usage of Your DB2 Web Query Reports,” I explained how you could utilize various techniques available on the System i to influence database optimization behavior for DB2 Web Query requests. That article relied upon the use of t

(Rikki Kirzner) The successful outcome of any project starts with defining, creating, and distributing project requirements in a form where all stakeholders can easily access, collaborate, and contribute to creating requirements. While this seems simple enough to explain, time and again, good intent

(Willie Favero) This is a blatant advertisement for an IBM class (CV040) that cost money. I don’t usually promote things that cost, I figure IBM has amble resources to do that on there own. However, this class is brand new, like in first time taught, and it’s sounds interesting.

(Sonali Surange, Rafael Cross and Vijay Bommireddipalli) IBM Data Studio Developer 1.2 speeds development and enhances control for a wide variety of experiences. Whether you are a developer or an application-centric DBA, Data Studio Developer has many new features that can get your job done faster a

(Scott Hayes) In the prior blog post, we learned how to determine if your database is CPU bound, lock bound, sort bound, or I/O bound, and how to determine if a performance problem is attributable to the database or not. We will now turn our attention to statement analysis methodologies so that we c