(Michael Sansoterra) It eventually happens to every developer. You write a stored procedure to return one or more sophisticated result sets to a Java or .NET client. Everyone is (temporarily) happy. Eventually, a need arises for an RPG or COBOL program to execute this stored procedure and process th

(Willie Favero) On September 21, IBM will be presenting a no-charge Webcast “TCO news: Optimizer in DB2 10 for z/OS Beta” featuring optimization expert Terry Purcell. Here’s an opportunity to find out what the enhancements and additions to DB2’s optimizer in DB2 10 will do for you.

(Sheryl M. Larsen) Few things do well without proper care. Houses, cars, pets, friends, and family all need our attention to stay happy and healthy, and database management systems are no different.

(Dave Beulke) The beta of DB2 10 for z/OS continues to progress with the early indications that the relative performance processing bar is definitely being raised in this next version. Early DB2 10 beta customers are truly experiencing 5-10% performance improvements out of the box. Some are even e

(Robert Catterall) For a number of organizations, a key issue related to DB2 for z/OS Version 8 to Version 9 migration has been the elimination, in a DB2 9 environment, of the BUILD2 phase of partition-level online REORG. The concern with the elimination of BUILD2 had to do with the attendant restri

(Roger E. Sanders) Table partitioning is a data organization scheme in which table data is divided across multiple storage objects called data partitions, based on values in one or more columns. A partitioned table can contain significantly more data than an ordinary table; yet, by taking advantage

(Henrik Loeser) When you create a table, by default, DB2 is resource-conscious in terms of space. So-called FSCRs (free space control records) are used to keep track of free space in the pages. When you delete a row or a row has to move because of an update statement expanding the row size, the new

(Frank Fillmore) Thanks to all who attended the Optim Virtual Briefing on DB2 Connect. If you were not one of the 250 attendees last Thursday, the replay and materials are available here.

(Lester Knutsen) My last column discussed why and how we use dimensional modeling to organize the data in a data warehouse. To briefly reiterate, the goal of a data warehouse is to give users fast access to data so they can make better business decisions, and to give them a separate area to run quer

(Lockwood Lyon) When involved in application performance tuning, the database administrator usually concentrates on reducing elapsed times or I/O waits. Too often, the CPU is forgotten, perhaps because of recent advances in CPU speeds, parallelism, and specialty processors.