(Robert Catterall) I’ve written a number of entries, here and in my old Catterall Consulting blog, on various topics related to DB2 buffer pools (I posted the most recent of these just a few weeks ago).

(Willie Favero) It’s a legitimate question that hopefully you are giving some serious thought to every time you create a new table space. If you are on DB2 9, we know you’re not using simple table spaces… so glad we’re finally seeing the demise of the simple table space. In fact, even the DB2 catalo

(Dave Beulke) Everyone is really wondering whether the performance improvement numbers are really true for DB2 10. The answer is a big “YES” according to the majority of the DB2 10 Beta customers.

(Heather Lamb) IBM pureQuery is a high-performance data access platform that makes it easier to develop, optimize, secure, and manage data access. It consists of tools, APIs, a runtime, and client-monitoring services. In this article, get an introduction topureQuery annotated methods–the quickest w

(Scott Hayes) In episode #32, special guest Martin Hubel, IBM DB2 GOLD Consultant and Owner MHC Inc., talked about a successful SAP implementation on DB2 LUW at The Wasserstrom Company. Martin shared valuable tips and lessons learned, and some of the tips apply to any OLTP application database. Watc

(Henrik Loeser) First off, let me start by pointing out that it is best practice to use parameter markers for repeating, similar dynamic SQL queries. Instead of issuing

(Flannan Lo) This article shows users how to test their web service modules with test case support in WebSphere Integration Developer. I have discovered that most users do not know why and how to use Java expressions to set their test variables in their test cases. This article will explain how to u

(Willie Favero) Yup, you’re reading the subject of today’s post correctly. The DB2 Version 7 precompiler is part of the base DB2 10 for z/OS product. Well, it’s not the actual V7 precompiler, it’s a V7 precompiler clone called DSNHPC7 that is very similar to the DB2 V7 precompiler .

(Dave Beulke) Everyone is really wondering whether the performance improvement numbers are really true for DB2 10. The answer is a big “YES” according to the majority of the DB2 10 Beta customers.

(Yun Feng Sun, Eileen Lin, Art Kaufmann, Martin Klumpp and Xing Yu Liu) The LDAP wrapper is a pure Java package that is based on InfoSphere Federation Server Java wrapper SDK technology. By providing read-only access to Lightweight Directory Access Protocol (LDAP) directory servers in an SQL environ