(Kent Milligan) The latest version of IBM DB2 for i boasts a trunkload of features designed to make your job easier. This overview article highlights some of the most interesting enhancements in DB2 for i 7.1, including adaptive performance tuning via Adaptive Query Processing (AQP), a real-time sel

(Robert Catterall) I had to smile when I saw the thread that Ed Long of Pegasystems started the other day on the DB2-L discussion list. The subject line? “IDUG radio silence.” Here it was, IDUG NA week, with the North American Conference of the International DB2 Users Group in full swing in Tampa, F

(Willie Favero) Sort invokes many thoughts and emotions—most in the “necessary evil” category. A discussion of sort also can head off into many different directions; it’s a subject you could discuss forever. For this article, the scope will be on only the internal sort for DB2 for z/OS, which is the

(Dave Beulke) Have you heard about DB2 10 for z/OS yet? The announcement of the beta program and presentations from the IBM System z Summit road shows highlight many of the new functions and features, and the upcoming International DB2 Users Group (IDUG) conference should provide further details. Al

(Willie Favero) In most cases, if you want to get something done twice as fast, get a friend to help. Two can usually accomplish more than one, especially when you are trying to reduce how long it’s going to take to complete. The same could be said for DB2’s queries.

(Craig Mullins) I’ve been running around kinda busy the past couple of days here at IDUG in Tampa, so I got a bit behind in blogging about the conference. So, today I’m combining two days of thoughts into one blog post.

Guidelines and techniques that can help to improve performance when authors and analysts deal interactively with relational data sources within the IBM Cognos 8 BI studios (Query Studio, Analysis Studio, Report Studio Express).

(Susan Lawson and Daniel L. Luksetich) As we continue to expand and combine our data and applications into enterprisewide applications and layer them in an architecture that adds abstraction and expands usage, we find our database access activity greatly increases.

(Rebecca Bond) Database administrators consistently strive to find faster ways to accomplish tasks in an effort to maintain some semblance of sanity as they navigate through persistent chaos. Learn how to simplify your IBM DB2 Database Security Setup using DB2 ROLEs.

(Roger E. Sanders) Database performance has long been constrained by the I/O capability of hard disk drives (HDDs). The reason is that HDD performance is limited by mechanical constraints such as head movement (seek time) and rotational latency. And while the capacity of HDDs has grown exponentially