(Willie Favero) In my previous post on parallelism (“DB2 for z/OS Parallelism” ) back on May 15 I introduced some of the basic concepts behind parallelism. Today, I’d like to take a look at the DSNZPARMs that can affect parallelism behavior in your DB2 subsystem.

(Keith McDonald) Have you ever spent a long time trying to figure out what was causing DB2 to give you a bizarre error message only to find that the root cause was a default you didn’t know was a default? I got just such a message the other day when writing an SQL stored procedure. In this post, I w

(Roger Sanders) In my last column, I explained how isolation levels play a key role in preventing databases from becoming inconsistent in multi-user environments. I also showed how the Cursor Stability (CS) isolation level worked both before and after lock avoidance techniques were implemented in IB

(Bryan Smith) Writing to you now from outside of Rome at IOD EMEA, but I wanted to take some time to focus on some of my impressions of this year’s IDUG NA in Tampa:

(Bill Arledge and Lynn Gros) This article takes a detailed look at DB2 buffer pool management, an important performance consideration. The goal is to leverage virtual storage so you can keep application data closer at hand and eliminate physical I/Os—still the biggest component of DB2 application re

(Bonnie Baker) In my previous column, I wrote about unnecessary SQL. The goal was to make programmers stop and think about each statement and make sure that it was both absolutely necessary and absolutely necessary at that specific time. I gave examples of SQL that could be eliminated completely and

(Troy Coleman) The previous two weeks I’ve written about DB2 referential integrity (RI). My good friend Suresh Sane posted a comment to clarify my May 4 post on using RI.

(Keith McDonald) As we saw when we examined its background and collection modes, db2top is not just a tool for letting you observe a running system – it also lets you record activity for later analysis. Another way to record data for later is the db2top Watch feature, which lets you precisely specif

(Willie Favero) Testing for RSU1004 is now complete. This 1st addendum contains PE resolutions or HIPER/Security/Integrity/Pervasive PTFs and their associated requisites and supersedes through March 2010.

(Shalom Momi Sabag) It’s been a while since my last post and I want to apologize, this one is about DB2 LUW … (although everything here behaves the same on zOS if I’m not mistaken).