(Alex Osuna, Jawahar Lal and Bobby Oommen) As the need for uninterrupted availability of enterprise data is growing, more businesses are striving for 24×7 system availability and can’t afford any downtime. In this era of continuous information availability, the complete and rapid recovery from a dis

(Susan Malaika and Pichler Christian) The Universal Services are a set of database operations, including insert, update, delete, and query, exposed as Web service operations. These services enable someone who has a pureXML column in a DB2 database to set up database Web service operations quickly, f

(Willie Favero) Although not a big deal, and absolutely meaningless technically, up until now, DB2’s name has managed to stay operating system free. However, with Version its name gets a little longer. On November 30, 1995 DB2 for MVS/ESA Version 4 went generally available (GA). From this point forw

(Kent Milligan) Is there a way to determine when a row in a table on iSeries has been added or changed? Currently there is no user field tracking this. I’m looking for some hidden DB2 function, like the RRN. (R)

(Michael Schenker) Data Studio, the new unified tooling platform for IBM data servers, provides a feature that allows easy exposure of database operations as Web services, also known as IBM Data Web Services (DWS). This tutorial series will show how Web services created with DWS can be deployed on I

(Daya Vivek) IBM pureQuery is a high-performance Java data access platform focused on simplifying the tasks of developing and managing applications that access data. It consists of tools, APIs and a runtime engine. pureQuery introduces two programming styles to help users access the database through

(Rufus Credle, Martin Gerlach, Sanjeev Sharma and Xiao Qing Wang) Building a high performance and high availability commerce site is not a trivial task — from having right capacity hardware to handle the workload to properly testing the code change before deploying in production site. This redbook

(Scott Hayes) Understanding Table I/O performance is critically important to properly diagnosing the health and efficiency of a database and pinpointing problems. In fact, if I only had just a few minutes to quickly assess a database, I’d look at 3 key measurements…

(Ted) If you already know about these, then just hit the ol’ delete key on the message. I learned how to do this today. SQL is great for going “down the page.” It’s when they want data summed across that it gets to be a real kludge! Pivot tables are the answer.

(Troy Coleman) DB2 V9 includes the capability to rename a COLUMN on a table without having to drop the table and recreate it. Given how time-consuming it is to unload all the table data, drop the table, recreate it and then reload the data, it’s easy to see how this single enhancement can make a DBA