(Troy Coleman) Last week I listed some new DB2 9 features that can help you while requiring essentially no effort on your part. These benefits are in utility CPU reduction, logging, larger prefetch sizes, LOB performance and DDF virtual storage constraint relief.

(Willie Favero) It appears that a few interesting looking stored procedures have been added to DB2 via APAR PK46562 (see link below). They will allow you to bring administrative information back to an application program.

(Vijay Bommireddipalli) IBM Data Studio is a unified tooling platform that contains a comprehensive set of features to develop, administer, and manage your database servers. The development IDE of Data Studio packs in a number of features to assist in all your data related development needs. An inte

(Willie Favero) It has been more than three years since IBM DB2 Universal Database (UDB) for z/OS Version 8 became generally available. Since that time, we have learned quite a bit from some of the initial installations. One of the significant lessons learned is that planning is essential to the suc

(Carla Wilcox) Database management systems continue to focus on performance as the amount of data continues to grow at a staggering rate. This article focuses on a performance tuning technique called functional indexes. Creating and using functional indexes based on database use statistics can signi

(Roger Sanders) Practice for the DB2 9 DBA certification exam by trying your hand at these two sample questions from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press. The questions are reprinted here with permission. Check back eac

(Sing Li) The combination of Eclipse, DB2 Express-C 9.5, and WebSphere Application Server Community Edition 2.0 — all free to download, use, and deploy — is an excellent from-prototype-to-production suite for all of your Java and Java enterprise development needs. What might not be obvious is the re

(Paul Zikopoulos) At the IBM Information Management Information on Demand (IOD) conference in Las Vegas in October 2007, IBM made a number of major announcements, which included the christening of the DB2 Viper 2 beta as DB2 Version 9.5 (DB2 9.5), and the introduction of a new toolset for IBM data s

Microsoft introduced the PIVOT and UNPIVOT operator in SQL Server 2005 to generate cross tab reports i.e. to convert rows into columns and columns into rows. You can read more on that in our whitepaper. We have also covered the traditional way of pivoting the data for prior version of SQL Server and

(Tom Huntington) Do you need to combine System i, UNIX, and Windows data all on one executive dashboard panel? Do you need to consolidate data from multiple databases in your network? Are you tired of being forced to transfer System i data from your DB2/400 database to a data warehouse so that it ca