(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
Tag: IBM
Clouds ahead: Playing with DB2 and Cognos (FREE)
(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… 😉
DB2 10.1 fundamentals certification exam 610 prep, Part 2: DB2 security
(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
Integrating IBM Integration Bus with WebSphere Service Registry and Repository: Part 7: Configuring the WebSphere Service Registry and Repository cache in IBM Integration Bus
(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
db2look from a DB2 10.5 to a 9.7 database: how to successfully apply the SQL
(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.
What does a Commit mean in DB2?
(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.
DB2 Tips n Tricks Part 32 – How to Configure Port Number for DB2 Instance
(Harishkumar Baburao Pathangay) How to Configure Port Number for DB2 Instance Solution:
Why is DB2 Rewriting my SQL?
(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.
APAR Friday: A HIPER, two fixes, and an improvement
(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.
Some zIIP Things of Which DB2 for z/OS People Should be Aware
(Robert Catterall) zIIP is short for System z Integrated Information Processor. It’s a so-called specialty engine for an IBM mainframe server.
