(Sean Byrd) Consistent Change Data (CCD) tables have been a popular type of target table in SQL Replication. By enabling CCD tables as another target option, it is simple for someone familiar with Q Replication to take advantage of this new functionality. So at this point, you might ask, “Why should

(David Beulke) Relational databases and relational set theory hold many performance advantages over other networked and hierarchical databases. Relational set theory and the ability to process multiple rows through one database SQL statement can be very powerful. Unfortunately, I continue to find pe

(Chris Eaton) IBM User Experience is looking for DBAs to participate in user feedback study sessions. The sessions will consist of face-to-face interviews or phone interviews (depending on your location) to learn about your data server requirements, work environment, and ways in which you use the da

The excuses have been eliminated: Get ahead of your workloads by upgrading to DB2 for z/OS Version 8 today. This complimentary seminar will show you how easy it is to take advantage of the latest technology for reducing operational costs and minimizing the costs of bringing new workloads online. Eve

(Rav Ahuja) Disk storage systems can often be the most expensive components of a database solution. For large warehouses or databases with huge volumes of data, the cost of the storage subsystem can easily exceed the combined cost of the hardware server and the data server software. Therefore, even

(Chris Eaton) Let’s now look at rolling in new data. Assume you have a partitioned table where each partition is a month worth of data and you want to add a new month. The first step is to create a table that will hold the new month’s worth of data CREATE TABLE FACT_NEW_MONTH LIKE FACT_TABLE

(Lily Goh and Allan Tham) Information defines health and wealth for a corporation. The lack of information readiness can cost dearly for some. As Steve Mills, senior vice president of IBM Software Group, once put it, “Next to people, information is a company’s greatest asset. But its value can’t be

(Hardeep Singh) XML support in DB2 UDB Version 8.x was based on DB2’s relational infrastructure. XML data was either stored intact as a character large object (CLOB) or shredded to relational tables. DB2 UDB Viper, on the other hand, has true native support for XML data. XML is now handled as a new

This article describes how to install and configure DB2 Version 8 on UNIX platforms without using the “db2setup” command, as described in the “DB2 Quick Beginnings” manual. There are two good reasons for using an alternate method. (pdf)

(Rav Ahuja) Management of large databases and tables has its own challenges. As tables grow in size, it sometimes becomes easier to manage their data in chunks or by limited ranges, rather than operate on all of the data in those large tables in their entirety. This methodology of managing data is a