(Dave Beulke) As I talked about database I/O performance the last three weeks here, here, and here, optimizing database I/O performance involves many different factors. When I left off last week I talked about the parameters for pinning your popular objects into DB2’s buffer pools to optimize and l

(Henrik Loeser) By now everybody should have heard about IBM BLU Acceleration for Cloud. The tagline is “Data Warehousing and Analytics for Everyone” which caught my eye. So this morning I wanted to find out how easy it is to get started. My conclusion: Almost too easy for an IBM product… 😉

(Anas Mosaad and Mohamed El-Bishbeashy) This tutorial introduces authentication, authorization, privileges, and roles as they relate to IBM DB2 10.1. It also introduces granular access control and trusted contexts. This is the second in a series of six tutorials designed to help you prepare for the

(Martin Smithson, Erik Nord, Stephen Rea and Jerry Stevens) Combining IBM Integration Bus (IIB) with WebSphere Service Registry and Repository (WSRR) lets you dynamically retrieve service metadata from WSRR and use it to modify message flow behavior at runtime. This article series shows you how to

(Norberto) Recently I needed to restore a backup taken on DB2 10.5 into a server where I was not able to install that same version (due to OS pre-reqs not met). As I already had DB2 v9.7 there – and I was not in a position where I could have the OS upgraded – I had to use db2move instead.

(Ember Crooks) Database management systems have the concept of a commit. This concept has to do with grouping sets of actions together such that they all succeed or fail as a group. This represents the A in the famous ACID properties of a transaction system.

(Harishkumar Baburao Pathangay) How to Configure Port Number for DB2 Instance Solution:

(Troy Coleman) The EXPLAIN statement provides a view into what DB2 determines is the optimum access path for accessing the data. The valid statements that can be processed by the EXPLAIN statement are SELECT, MERGE and INSERT, as well as search forms of UPDATE and DELETE.

(Willie Favero) For this APAR Friday post, I have a HIPER for all my data sharing friends, a very minor fix to one of the service utilities that is small but helpful, and a length issue fix for a scalar function and a productivity-aid sample program.

(Robert Catterall) zIIP is short for System z Integrated Information Processor. It’s a so-called specialty engine for an IBM mainframe server.