(Michael Sansoterra) The long awaited announcement of IBM i 7.2 comes with several enhancements to DB2 for i. In this tip, I’m going to explore the new set of built-in global variables that come with DB2 for i 7.2.

(Kent Milligan) The DB2 for i 7.2 release is chock full of enhancements that take its legendary ease of use and security to new levels. In this article, you’ll learn how to simplify development with procedural SQL advancements, streamline management with new DB2 capabilities, and tighten data securi

(Jacques Roy) Part 1 of this series discusses using a program to implement data-in-motion processing. It also argues that this approach should be dismissed in most cases because once the volume of data gets high enough, additional time is required to maintain a distributed infrastructure that does t

(Henrik Loeser) Do you like playing “Connect Four” (4 gewinnt, Four in a Row, Fire på stribe, Connecta 4, …)? Well, there is a new new video talking about DB2 with BLU Acceleration, SAP BW, and DB2 on POWER. And it has an ending that is typical for IBM 🙂 The customer wins. See for yourself…

(Willie Favero) Today’s post started out as one of my APAR Friday post, in fact my first post for the month of May. However, the more I read about what this APAR delivered, the more I released it was much much more.

(Martin Smithson) 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 integrate the two products, and provides sa

(Danny Arnold) As part of my role in IBM Information Management, as a technical advocate for our DB2 for LUW(Linux , Unix, Windows) product set, I often enter into discussions with clients that are currently using Oracle Database.

(Scott Hayes) 18% of our audience was running DB2 LUW V10.5 in production and 45% of our audience was running V10.1 in production. The INGEST Utility became available in V10.1 as a client side utility, yet 0% of our audience today was using it.

(Mike Walker and Lester Knutsen) What can be done about accidentally deleting a critical table? What if a WHERE clause in an update statement was omitted, causing important data to be overwritten? Recently, a client organization had one of those heart-stopping moments after deleting all the rows in

(Dave Beulke) As I talked about last week, the application and database performance involves constantly analyzing different DB2 I/O aspects of your environment. By analyzing the DB2 I/O reports you’ll discover there are many different aspects to examine to optimize your environment, application work