(Paolo Bruni and John Iczkovits) DB2 integrates with the storage management software and continues to deliver synergy with FICON (fiber connector) channels and disk storage features. (pdf)

(Willie Favero) The inspiration for today’s entry is courtesy of the DB2-L listserver. While reading a few posts over the weekend, it came to me that Fast Log Apply (sometimes called FLA) doesn’t get enough decent exposure and deserve a little more airtime. At a minimum, it needs to be re-explained

(Chenhong Xia) This tutorial series teaches you how to create proof-of-concept Windows and Web applications to access relational and XML data in IBM DB2 Viper, using Microsoft Visual Studio.NET 2005. Part 1 explains the application specifications and illustrates how to create the relational database

(Carmen K. Wong and Stan Musker) LBAC is a security feature introduced in the DB2 Viper release. With LBAC, administrators can control read and write access of user to a table column and row level. This tutorial includes use-case scenarios that demostrate how users can apply LBAC to protect their da

(James Chamberlain, Corinne Blanchard, Sam Burlingame, Sarika Chandramohan, Eric Forestier, Gary Griffith, Mary Lou Mazzara, Subu Musti, Sung-Ik Son, Glenn Stump and Christoph Weiss) This IBM Redbook explains the key products and components that are included in the WebSphere RFID solution, with a fo

(Howard Goldberg) The amount of structured and unstructured data companies must manage continues to grow exponentially, and with it, the DBA workload and importance increases. Application requirements, market competition, and the effects of government regulations are increasing both the volume and t

(Greg Scriba) In the computer performance arena we often think of “Looping” in a negative sense. But is all looping really bad? The loop control structure is actually one of the most often used control structures in programming today. This paper suggests using the loop structure in our daily perf

(Joe Pluta) You know me, always trying to find quotes that really fit. Well, this song is appropriate to this article for a number of reasons. First, it’s both old and new. The original was recorded in 1967, and it’s been re-recorded dozens of times over the years. Each time, it gets a little someth

(Chris Eaton) Let’s start with the syntax for creating the partitioned table. The table creation syntax has a short form and a long form. I gave a brief example of the short form in my last posting. Before diving into the syntax, let’s first talk about the partitioning column. Table partitioning all

DB2 Viper contains innovative features for delivering information on demand and scaling databases to new levels. The Table (Range) Partitioning capabilities in DB2 Viper provide a number of advantages including better query performance, improved large table manageability, and dynamic data roll-in/ro