(Alex Osuna, Nailah Bissoon, Sunil Kamath, Jawahar Lal, Augie Mena and Roger Sanders) This IBM redpaper provides a performance comparison and tuning recommendations for three different transport protocols – FCP, iSCSI, and NFS – when running IBM DB2 9 and AIX 5L 5.3 TL-04 on a 2-way IBM System p5 52

(Vasantha Jayakumar) Using the IBM Database Add-ins for Visual Studio 2005, you can now avoid the manual steps that have previously been required to deploy a stored procedure on a second target server. In addition, you can also easily view, create, and drop packages for stored procedures. Each packa

(Craig Mullins) Another nice new feature deep in the bowels of DB2 9 for z/OS is the ability to hide columns from the SELECT * statement. As far back as anyone can remember the advice has been given to avoid using SELECT * in application programs. But I still see it every now and then.

(Alex Woodie) There is no sense in denying it: Microsoft Office–not a 5250 screen–is the interface that the majority of people feel the most comfortable using. With this sentiment in mind, System i business intelligence software vendor New Generation Software unveiled a new product called Qport Of

(Willie Favero) Are you a data person? Is your company becoming more and more interested in Service Oriented Architecture (SOA)? Would you like to know more about how SOA ties into your data and your mainframe? What about the value of your data’s quality?

(Craig Mullins) DB2 9 for z/OS offers, for the first time, the ability to create an index on data that is not technically in the table. At this point, you may well be asking “What does that mean?” and “Why would I do that?” I’ll attempt to answer both of those questions.

(Paul Zikopoulos) In an article called “Rational Data Architect and DB2 9: Building an SQL Statement”, I introduced you to the IBM Rational Database Architect (Rational DA) product and its SQL builder feature. Specifically, I showed you how easy it is to build an SQL statement using the Rational DA

(Manjula Panthagani, Rashmi Chawak and Siva K. Ane) Install and configure IBM Informix Dynamic Server, Version 11.10 (IDS 11), manage space and logs, and configure the different security options available in IDS. The first in a series of eight tutorials, use this tutorial to help prepare for the IDS

(Willie Favero) DB2 9 introduces a little thing called universal table spaces or what everyone seems to like referring to as UTS. This is, IMHO, an extremely cool feature. And although you haven’t heard everyone clamoring for universal table spaces, it’s a concept that quite a few people have wanted

(Joe Pluta) Strap in, kids; this is going to be a fast ride. The new Screen Designer included in WDSC is just chock full of features, and I want to show you as many as possible within the space we have here.