(Guogen (Gene) Zhang) On this last day of year 2008, I’d like to share with you on how easy it is to generate XML from relational data using SQL in DB2 V8 and DB2 9 for z/OS.

(Tom Glaser) Although DB2 Query Monitor for z/OS handles all the traditional tasks youd expect, as I explained in the first half of this article, its capabilities go far beyond the expected. Read part 1 for the first half of the list. Ill continue with items 6-10 here.

(Jeffrey Benner) db2pd is a relatively new DB2 LUW performance monitoring and troubleshooting tool introduced with DB2 version 8.2. Because it retrieves information from DB2 memory sets, it does not issue latches and is therefore a very low-cost means of monitoring DB2.

(Willie Favero) DB2’s use of hardware compression for data has been around since DB2 Version 3, around 1993. Throughout that time it’s just gotten better. Here are a couple of compression’s more recent changes that have help to make it the very cool feature it is today.

(Bob Callaway and Doug Williams) WebSphere DataPower SOA Appliances are purpose-built, easy-to-deploy network devices that simplify, secure, and accelerate XML and Web services deployments within an SOA. The WebSphere DataPower XI50 Integration Appliance can efficiently communicate with enterprise r

(Jeffrey Benner) No, this isnt a tutorial on transcendental meditation, though it takes certain Zen-like qualities. Being good at any job means knowing what to look for – an artist sees one thing, a photographer another. Theres a vast amount of information available, and we filter for what is import

(Robert Catterall) In my own experience as a DB2 consultant, I’ve seen organizations put their trust in DB2 for Linux, UNIX, and Windows (LUW) when it comes to automatic management of the server memory resources utilized by DB2 – with positive results. Self-tuning memory management (STMM) was activa

(Willie Favero) You have just completed your upgrade to DB2 9 for z/OS new function mode (NFM). You’ve completed the big jump. However, you still have lots of simple table spaces. After all, just because DB2 9 deprecated (don’t you just love that word) simple table spaces, they don’t instantly just

(Antonio Cangiano) As pre-announced in my two previous posts, DB2 for Mac OS X Leopard is finally available for download. Its now official, DB2 on Mac is here.

(Scott Hayes) I was recently contacted by a DBA at a large insurance company. After upgrading from DB2 V8.2 to 9.1.0.3, the DBA activated the Self Tuning Memory Manager (STMM) in the hope that it would solve all performance. To the contrary, performance got worse, and the DBA noted a marked increase