(John Rasmussen) This article is the first in a multi-part series of articles describing OAuth support on WebSphere DataPower Appliances. Part 1 starts with an overview of OAuth and then describes DataPower support for OAuth features. The rest of the article series will go into detail on several asp

(Jim Staton) In my previous article, I discussed the goals I had set out for our programming group and how those goals helped determine the skills that I was looking for among the candidates for a job in our company. One of those goals was to encourage the use of SQL among our programmers for databa

(Willie Favero) Every once in a while I completely miss a feature added to DB2. This time I missed what I would call a biggie; a way to significantly improve the performance of your DB2 UNLOAD and LOAD utilities…… Sometime the middle of last year, around May 2011, APAR PM19584 arrived for DB2 9 fo

(Troy Coleman) IBM just published this security bulletin aimed at DB2 for LUW users, “Buffer Overflow Vulnerability in IBM DB2 Java Stored Procedure Infrastructure”:

(Linda Claussen) What’s so exciting about DB2 native SQL procedures? It’s a question I’ve been asked countless times. I can’t help it—native SQL procedures excite me. I think they truly represent the future of computing.

(Martin Dizon and Denis Kirichenko) Migration projects enterprises undertake can be complex, costly, and disruptive. If migration teams are not equipped with effective testing tools, they may spend months reviewing code to prioritize conversion efforts and preparing scripts to simulate production wo

(Danny Arnold, Steve Diniro, Vivian Lee,Stan Musker and Jo-Ann Woods) This IBM Redbooks publication provides a broad understanding of the key features in IBM DB2 10 and how to use these features to get more value from business applications. It includes information about the following features:

(Philip) XML is most useful, especially when it is well formatted and you know what it contains and all the documents stored in your XML column are the same. When they are not and you canft exploit fully DB2Œs very good XML features, and you donft know how to query your XML it can be very hard.

(Terry Purcell, Kendrick Ren, Jun Liu and Kewei Wei) The previous articles in this series introduced the concept of access paths, showed you how to read an access path diagram in Optim Query Tuner and went through the methodology for tuning individual queries.

(Robert Catterall) Today I’m writing about a situation that I first encountered almost 20 years ago, and which I most recently saw about three months ago: an organization with a CICS transaction workload accessing a DB2 for z/OS database reports a performance problem.