(Mike Cain) In Dan Cruikshank’s August 2008 article “Working with Data Sets,” Dan illuminated the power of SQL “set at a time” processing, and he used some of the new DB2 for i 6.1 OLAP functions to do it. In this article, I’ll expand on this concept and demonstrate some additional uses for OLAP fun

(Roger Sanders) Try the sample questions below, then review past questions here. All questions are from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press and are reprinted with permission. Check back each week for more.

(Alex Woodie) i-based Power Systems shops looking for a power tool to supercharge their database development and maintenance tasks may want to check out the latest release from AquaFold. Last week the Silicon Valley company unveiled Aqua Data Studio version 7.0, which adds support for the DB2/400 (D

(Willie Favero) This last week has been an interesting week for me. Although I did NOT get upgraded on my flight to or from Warsaw, Poland, I have had a whole slew of other things go very right for me.

IBM released an update Wednesday to patch at least 10 vulnerabilities in its DB2 database management system (DBMS). (R)

(Willie Favero) Were you not able to make it to an IDUG conference this year? Would you like the opportunity to attend even just a portion of an IDUG conference, maybe something even local to where you live?

(Troy Coleman) The industry is moving toward storing data in an XML format. No, really.

(HeQing (Hawking) Guan, Qiang Bai, YuLin Chen and YaoFei (Richard) Zhu) This article series introduces an automatic deployment toolkit (Automatic-DT), which helps infrastructure architects install and configure deployment nodes with a list of IBM software installed and configured automatically. It a

(Robert Catterall) The 2008 International DB2 Users Group European Conference concluded a little while ago, and I’m looking forward to seeing many of my fellow attendees (and some new people) at the 2009 conference that will take place October 5 – 9 in Rome. This was another good day, from my perspe

(Andrew Ford) One of the engines that I manage contains a particularily nasty table. Let me know if this sounds familiar: This troublemaker is a history table that stores the details of each of the 2 million transactions our platform processes each day. The rows are wide, weighing in at over 900 byt