(Andrew Borts) Some of the important tools that you may not be aware of are actually external SQL stored procedures. A slew of these helper objects can only be created in RPG; requiring far too many JOIN statements, logical operators and SELECT/OMIT statements for logical files otherwise. Years ago,

(Thamizhchelvan A. Anbalagan and Vishwas T. Mahadevaiah) AGS Server Studio, Open Admin Tool (OAT), and Informix Server Administrator (ISA) are all graphical user interface (GUI) tools that are available to help you monitor and administer IBM Informix Dynamic Server (IDS). In this article, learn more

(Mark Wilding) We’ve been busy on a project that requires creating images (with DB2 installed) for both Eucalyptus and EC2 on a wide range of systems. Unfortunately, the various systems all have their nuances and things don’t always work at first. One of the common errors that we’ve seen relates to

(Willie Favero) Today’s APAR, PK85754 , has been around for a few months. However, I still thought it was worth mentioning because it can affect deferred close processing.

(Dmitriy Fot and Martin Oberhofer) This tutorial shows you how to implement behavior extensions for InfoSphere Master Data Management Server using the InfoSphere Master Data Management Workbench. Behavior extensions provide event capabilities that create actionable master data and improve the busine

(Robert Catterall) Following is some good stuff that I picked up during the course of day 3 of IBM’s 2009 Information on Demand conference:

(Shalom Momi Sabag) As promised, here are the answers to the questions from the previous post.

(Matthias Nicola) DB2 pureXML makes storing and querying XML data easy: just define a column of type XML and then insert or load XML documents into that column. But what if you need to go beyond the basics? With IBM DB2 for z/OS and DB2 for Linux, UNIX, and Windows (LUW), that’s no problem. Let’s re

(Troy Coleman) On Nov. 3, IBM is providing a sneak peek at the next release of DB2 for z/OS. I was fortunate enough to be briefed by the IBM lab last year on the new features and functions are being targeted for delivery in the upcoming release. It’s an impressive list.

(Robert Catterall) Another day done at IBM’s 2009 Information on Demand Conference – another day of learning more about DB2, and about technologies used at higher levels of the information transformation software stack. Some take-aways from today’s sessions follow.