(David Bridgewater) This tutorial shows you how to use the Data Modeler within the Rational XDE toolset to manage your database design and maintenance. It takes you through all the steps required to create a logical model for your database, and to transform this into a physical diagram and set of sc

(Paul Yip) Just updated with custom date/time formatting! This short article explains how to manipulate dates, times and timestamps using SQL on DB2 Universal Database for Windows, UNIX and Linux platforms.

I have an application that queries and writes to 11 normalized tables. While performance testing, I noticed that when I put all of the tablespaces used by these tables in the same 32K buffer pool, the application ran much faster than when I allocated separate buffer pools. Each table is in its own t

(Roger Sanders) As you may recall from my recent columns, I always recommend that DBAs approach performance tuning in an organized manner with specific, realistic, measurable goals in mind. Otherwise, tuning becomes a hit-or-miss exercise. To improve database performance, you must first identify

(Thomas Bauch and Mark Wilding) In this sample chapter, you’ll learn the ins-and-outs of the installation process for DB2 UDB in the Solaris operating environment (with some discussion of other platforms), including distributed installation.

(Whei-Jen Chen) DB2 Universal Database (DB2 UDB) has long been known for its technology leadership. This IBM Redbook is an informative guide that describes how to migrate the database system from Oracle to DB2 UDB Version 8.1 on AIX, Linux, and the Microsoft Windows platform. This guide presents

(Robert Westervelt) Stinger may be flapping its wings to take flight, but it will be a while before the next version of DB2 Universal Database will buzz across the radar screens of most DBAs, many of whom said they are too busy working on critical projects to even think of upgrading. (R)

(Abhiram Jayaram) Incorporating a large amount of batch process code into an online process while retaining the code in the batch process can cause problems from having to maintain the same piece of code online and in the batch. These problems can be compounded if some of the programs are third-

Mark your calendar and make plans to attend IDUG 2004 – Technical Symposium. This impactful, two day symposium hosted by the International DB2 Users Group (IDUG) provides you with an excellent training environment, relevant content and expert instructors, a convenient and accessible location, all fo

(Lisa Vaas) Updating databases isn’t minor surgery. From what I hear, it’s nowhere near as traumatic as updating an enterprise resource planning (ERP) system, which can take months of patching and testing patches and testing the patches upon which the patches rely. But still, as evidenced by the