(Craig S. Mullins) DB2, and relational databases in general, have a reputation of being (relatively) easy for users to understand; users specify what data to retrieve, not how to retrieve it. The layer of complexity removed for the users, however, had to be relegated elsewhere: to the code of DB2.

(Cheung-Yuk Wu and Cliff Leung) With the InfoSphere Optim Performance Manager V5.3.1 web console, you can configure your monitored databases for a complete tuning cycle for single queries or workloads for DB2 for Linux, UNIX and Windows, and DB2 for z/OS data servers. You do not have to install Data

(Somu Chakrabarty) If you have been using DB2 10.5 with a mix of row and column based tables in the same database you may have experienced slowdown in some of your OLTP queries accessing your row based tables after implementing column based tables.

(Ember Crooks) Sometimes the connection state is unclear. The following can all make it fuzzy wether or not you have a valid connection:

(Martin) 100% of our studio audience learned something! Joel provided an in-depth look at buffer pool tuning with many real world examples.

(Willie Favero) I have found that over the years, some of the best ways for me to keep up with what’s going on in the wonderful world of DB2 for z/OS is teaching DB2 for z/OS (something I stopped doing many years ago when I returned to IBM), presenting at conferences and user group meetings (somethi

(Dmitry Drinfeld and Stephanie J. Hazlewood) One of the most fundamental extension mechanisms of InfoSphere Master Data Management (MDM) allows for the modification of service behavior. These extensions are commonly referred to as behavior extensions, and the incredible flexibility they provide allo

(Ember Crooks) The request from the developers was something along the lines of “Help, Ember, this query needs to perform better”. Sometimes the query I’m working on is not one that shows up as a problem from the database administrator’s perspective, but one that is especially important in some part

(Troy Coleman) Last week I discussed dirty reads and how isolation level (UR) is used to read uncommitted data. In the course of my research for that post, I came across a related topic: bind parameter conflict resolution for isolation and release parameters.

(Sunil Kumar) WebSphere MQ File Transfer Edition provides an enterprise-class platform for managed file transfer operations. Resource monitors in MQ FTE let you send a file from any directory or queue, and perform various operations on the file being sent or received.