(Dave Beulke) Another great feature that is in the new Version 9.7 of DB2 is its new compatibility with Oracle. This compatibility takes many forms within the database such as understanding operational syntax, stored procedures keyword syntax and improved operational concurrency that I covered last

(Holly Hayes) With the June 2009 announcements, IBM is consolidating many of its Data Studio offerings under the Optim name. The Optim portfolio will focus on realizing integrated data management with innovative delivery of application-aware solutions for managing data and data-driven applications a

(Paolo Bruni, Felipe Bortoletto, Thomas Hubbard, Ernest Mancill, Hennie Mynhardt and Shuang Yu) In this age of complex regulatory oversight and wide ranging threats to corporate data, securing a company’s information assets from internal and external threats has become a primary focus and concern fo

(Troy Coleman) For years, reviewing and fixing SQL performance problems was a big part of my job, and I remain in the habit of looking for ways to help people write efficient SQL. In my experience, developers who not only know DB2 for z/OS SQL but know how to tune the SQL are nearly impossible to fi

(Nora Sokolof) Have you ever wondered how IBM DB2 and IBM solidDB procedures differ? This article series of comparisons spells out the differences very clearly. In this Part 1, learn the differences between the structures, parameters, variables, assignments, procedure bodies, cursors, and dynamic SQ

(Robert Catterall) I was in the Upper Midwest of the USA for most of last week, presenting at three regional DB2 user group meetings – in Minneapolis, Chicago, and Milwaukee – on three consecutive days. One of the presentations I gave in each city covered DB2 for z/OS data warehouse performance. In

(Jean-Marc Blaise ) Do you remember DB2 UDB Version 5? No, so maybe you remember DB2 UDB Version 6.1 that you may have skipped, or DB2 UDB Version 7.2 that has been out of support for some time now?

(Yan Jun Mo, Lei Zhang, Peng Tang, Jing Feng Zhang and Wei Wang) The first article in this series, Part 1: Overview of WebSphere Business Services Fabric v6.1, provides an overview of WebSphere Business Service Fabric 6.1. In Part 2: Scenario Introduction, Problem Statement, and Business Analysis, w

(£ukasz) In this post I will show you the basics of XML support in IBM DB2 pureXML.

(Eric Ahrendt) Time is money, but in the data management business, this saying might be better phrased as “Time costs money” and so does everything else! Servers, storage, power, administrative time, development time, and support time all show up on the balance sheet these days, and pretty much ever