The following information describes crosstabs and how to create them using DB2 and Lotus Approach.

(Ken North) Never a simple undertaking, integration becomes even more challenging as performance demands increase, grids gain a foothold in enterprises, and regulations mandate tight privacy controls and document retention policies. IBM Distinguished Engineer Jim Kleewein explains why DB2 Informatio

(Barrie Sosinsky) Auto-incrementing columns are important when you need serial numbers or key fields for joins. In DB2 for versions 7 and later you can add the IDENTITY clause to the CREATE TABLE statement to create such a column. (R)

(Philip Gunning) Regardless of how well a RDBMS performs, the monitoring of SQL statements and resources is required to ensure continued good performance and to identify problem areas. Using the information gathered, adjustments can be made to instance and database configuration parameters, physica

(Craig Mullins) What is the syntex for altering the size of a varchar column in DB2? For example, from varchar(10) to varchar(20)? (R)

(Kulvir Bhogal and Grant Hutchinson) DB2 UDB provides for JDBC connectivity through a number of Java classes and interfaces that implement the JDBC specification. The implementation is known as a JDBC driver. DB2 currently offers JDBC drivers known as legacy/CLI drivers and the universal JDBC driver

(Marin Komadina) As a final word about Tivoli Storage Manager (TSM) database backup, here are a few tips I have found working with the TSM system. Only the most interesting tips are included since presenting all of them would be beyond the scope of this article. This article covers: –Tips Us

(Jonathan Gennick) DBAs spend a lot of time managing disk space. To maximize I/O rates, we spread the data we manage across many physical disks. Often we do this by working with a system administrator who uses a logical volume manager (LVM) to combine many physical disks into a single logical volume

(Craig Mullins) I have a table with a start date column which can be blank. What is your opinion as to a good default to have for this column? Should it be nullable or have some other default when no value is provided? SQL determines if the row is active by checking to see if it’s not null and less

This IBM Redbook discusses DB2 UDB for Linux on iSeries. We provide the installation and configuration steps for DB2 UDB for Linux on iSeries. We also present connectivity scenarios between OS/400 resources and Linux resources. (pdf)