(Chris Eaton) On the heals of the largest TPC-H benchmark result which I had posted on previously, now DB2 9 running on an IBM p5 595 published the most transactions per minute ever in the TPC-C benchmark. With over 4 million transactions per minute (4,016,222 tpmC) DB2 9 leads Oracle 10g by 2.5x an

(Xiao Li and Sheng Wei) The pClient and eClient, packaged with IBM DB2 Content Manager (CM), meet the client requirements of many Content Manager users. However, many others need to develop their own client applications to meet their special business needs and to integrate their own business with CM

(Willie Favero) The title sounds a little like Dorothy’s line from the Wizard of OZ: “Lions and tigers and bears, Oh my!” Although CCSIDs, Unicode, and DB2 V7 in the same sentence are something you definitely need to be concerned about, I’m not sure they are quite as scary as Dorothy’s plight on the

(Michael Dang and Sylvia Qi) This is the last in a series of seven tutorials to help you prepare for the DB2 9 for Linux, UNIX, and Windows Database Administration (Exam 731). This tutorial focuses on two advanced high availability topics: split mirroring and high availability disaster recovery (HAD

(Chris Eaton) Another of the more subtle enhancements in DB2 9 is the ability to transfer the ownership of objects from one user to another. The creator of any object has control authority over that object for the life of that object. Now in DB2 9 that control privilege (or ownership) can be transfe

(Richard Gregory, Jane Fung, Greg Adams and Randy Giffen) This series explores a service-oriented approach to application integration using IBM WebSphere Integration Developer. The first three articles took you through a scenic tour of the product and helped you build a simple application. The previ

(Farnaz Erfan and Mary Roth) Data integration in an enterprise of data sources is one of the most common requirements of any database shop. Users need on demand integrated access to a variety of diverse data sources, such as traditional data assets like Excel spreadsheets and legacy data, to new and

(Sylvia Qi and Raul Chong) Learn the basics of database backup and recovery. This tutorial explains the different methods of database recovery and logging, and how to use the BACKUP, RESTORE, ROLLFORWARD, and RECOVER commands. It also covers the new DATABASE REBUILD operation. This is the first of a

(Marichu Scanlon) Historically, customers who wanted to develop and deploy SQL and Java stored procedures could do so by using the Stored Procedure Builder delivered in DB2 for Universal Database (UDB) V7, or its successor, the Development Center. The process involves a “full build” of the stored pr

(Craig Mullins) As I’ve mentioned here before, sometimes I will use this blog to post answers to questions that have been sent to me. The question being answered today, is this: I have a select query that returns 1000 rows and I want to display the rows from 200 to 500. Could you please let me how t