(Troy Coleman) This is the fourth in a five-part series on tuning batch jobs. In part three I covered reducing I/O.

(Daniel Owusu-Afari, Sammy Chow and Andres Voldman) The database is the most critical component of a WebSphere Commerce site, and because of its dynamic nature, it requires continuous attention. The WebSphere Commerce database can experience lock contention issues as a result of poor maintenance, un

(Bonnie Baker) The SIX lock is one of DB2’s many mysteries. What is it, and how do we acquire it? Another mystery is the index_only flag on the plan_table: How can it be a Y for an UPDATE or a DELETE? Excuse me, but exactly how can an UPDATE or DELETE be “index-only?” A third mystery is the fact tha

(Robert Catterall) Not so long ago, a lot of people had the idea that if you wanted to do advanced, large-scale (multi-terabyte) data warehousing with DB2, your best bet, platform-wise, was DB2 for Linux, UNIX, and Windows (LUW).

(Troy Coleman) This is the third in a five-part series on tuning batch jobs. In part two I covered reducing CPU usage. Here I look at ways to reduce I/O, which in turn reduces CPU usage and elapse time.

(Kate Dawson) The Information Management Certification team has recently released a new DB2 exam. Exam 735, DB2 9.5 SQL Procedure Developer, is now available for anyone who has significant experience with intermediate or advanced level skills in developing DB2 stored procedures, user defined functio

(Leon Katsnelson) Just like any other DBMS, DB2 keeps all of your data in tables. The tables are organized in a usual i.e. data is stored in rows with each row having one or more columns. This is true even in the case when the data that is stored as XML. Hopefully it is not a surprise that DB2 Expre

(Roger Miller) DB2 9 for z/OS with a new APAR offers a way to get you out of a bind. I often encourage customers to rebind, paraphrasing Shakespeares Hamlet, act 3, scene 1.

How to remove backup pending state of a tablespace/database without actually taking a backup?

(Bharath Sriram and Chiranjeevi Vishnu Saran Sudha) Learn how to analyze IBM Informix Dynamic Server (IDS) performance using the IDS OpenAdmin Tool (OAT). OAT is an open source, Web-based interface to IDS and is supported on Version 11.10 and later. Parts 1 and 2 of this series introduced the tool a