(Paul Zikopoulos) Without a doubt, Microsoft Access 2007 (Access 2007) is one of the most widely used reporting and data persistence tools. Quite often, I see clients export massive amounts of data from their enterprise systems into Access 2007. They tell me they do this because they have so many ap

(Willie Favero) Today’s post will be very short. It’s been one of those weeks where I don’t seem to be getting anything done no matter how much work it seems I am doing or how late I work.

(Scott Hayes) Returning our attention to the question “Where does the time go?”, we need to look at Direct I/O times. Direct I/O is I/O that occurs directly to disk without an intermediate visit or presence in the Bufferpools. Direct I/O is used by DB2 in support of LONG and LOB objects. Even if you

(Willie Favero) First off, these are not mine. I found them in an article by Ian Bramley that arrived via an e-mail flash from Mainframe Executive Magazine. I just love finding stuff like this written by someone outside of IBM. Ian is Managing Director of Software Strategies, a specialist analyst fi

(Edward Oguejiofor, Edward Oguejiofor, Vijay Bhadriraju, Rajasekhar Durvasula, Andrew Jones, Ravikumar R Kanamatareddy, Yutaka Obuchi, Sebastian Pietrzak and Galina Rubinshtein) IBM WebSphere products for Telcom is a set of service enablers that extend the IBM WebSphere Application Server to deliver

(Tyler Anderson) This is the first in a two-part tutorial series creating secure Java-based Web applications using Rational Application Developer, Data Studio and Rational AppScan. This first tutorial begins by showcasing how Data Studio with pureQuery can increase the efficiency of your database-dr

(Craig Mullins) Table expressions are frequently overlooked as a potential solution for resolving problems using only SQL. Table expressions can be used to force the optimizer to choose a specific processing order.

(Matthew Bennett and Pat Moffatt) Here’s a fun way to learn about IBM Informix! Learn or teach the basics of Informix Dynamic Server (IDS) and relational databases with an interactive game called “The IDS Detective Game.” The game teaches relational database concepts and shows how technology can be

(John Shelton and Hardeep Singh) Learn about the XML functionality in DB2 9 for z/OS (DB2 9) and compare it with that of DB2 for z/OS V8. This article discusses the new XML features introduced in DB2 9, and goes into the details regarding the impact the new XML support has on migrating existing XML-

(John Shelton and Hardeep Singh) In this article, walk through an XML application migration process using an example scenario. The scenario goes through the steps of creating a sample application using DB2 for z/OS V8 functionality for XML. The application is then migrated using DB2 9 for z/OS XML c