Access your multi-member files, let your users dynamically select the member they want to query at run time, and create a report that uses the latest and greatest database engine technology.

Written by Gene Cobb

Over the last several years, I have written several articles about DB2 for i and DB2 Web Query, some of which emphasized the importance of employing techniques to ensure that your queries are using the SQL Query Engine (SQE), the strategic database engine for DB2 for i. One of the requirements for SQE processing is that the database access method must be SQL. However, one of the very few drawbacks with SQL access on our beloved system is that it does not natively support the concept of physical file members.

Tape may be everyone's darling, but SPHiNX is a dandy earning new friends daily.

Written by Chris Smith

I recently wrote an article titled "Bulletin: Tape Is Alive and Well at IBM." It was about several new technologies that will effectively extend the life of tape as a viable backup solution for a decade or longer. However, the whole time I was writing it, I was thinking, "Wow, this is amazing! I thought tape was on the way out long ago!"

That, of course, is a naïve belief. The fact is that almost every company uses tape in one capacity or another for backup or archiving even if they have a more robust backup solution running in parallel.