(Paolo Bruni, Kevin Harrison, Garth Oldham, Leif Pedersen and Giuseppe Tino) DB2 9 for z/OS is an exciting new version, with many improvements in performance and very little regression. DB2 V9 improves availability, security and adds greatly to SQL and XML function. Optimization improvements include

(Willie Favero) I’m not saying there’s no longer a need for QUIESCE. It’s just that its more traditional roll in a recovery scenario may no longer be what it once was!

(Eric Johnson) Combine debugging C# applications with SQL stored procedures, in Part 3 of this series. Parts 1 and 2 of this series were about debugging SQL stored procedures on their own. (R)

(Sam Lennon) In a previous TechTip, I encouraged you to do stringent error-checking on SQL return codes. In this TechTip, I suggest a standard error-handling routine for those SQL return codes you don’t expect. I also provide template program SQL_SKELR, which you can clone as a beginning for many of

(Willie Favero) A universal table space is a cross between a partitioned table space and a segmented table space, hopefully giving you many of both of its parent’s best features. (pdf)

(Matthias Nicola and Fatma Ozcan) DB2 9 introduces pureXML support, which means that XML data is stored and queried in its inherent hierarchical format. To query XML data, DB2 offers two languages, SQL/XML and XQuery. You can use XQuery and SQL separately, but you can also use XQuery embedded in SQL

(Chris Eaton) Anyone reading this blog also a member of Facebook? Well I know those of us with graying or little hair left are far outnumbered on facebook but it’s picking up steam with more than just university students. Facebook is a social networking site that is now the 7th most visited site in

(Carolyn Henry and Sangeetha Srinivasan) Use IBM DB2 Change Management Expert to make a complex change to a database while, at the same time, preserving all of the valuable information in the database. Follow a sample scenario that includes step-by-step instructions detailing how to complete this pr

(Robert Catterall) A few years ago, my friend Cathy visited my home in suburban Atlanta, Ga. I introduced her to my son, who was four years old at the time, and told him that Cathy had a farm in Pennsylvania. “Really?” asked Zachary. “Do you have horses?” “Yes,” said Cathy, “we have horses.”

(Bob Calio and Izzy Bendrihem) Learn how to handle mass inserts of data using Java and IBM DB2 Universal Driver Type 4 connection only, an efficient alternative for situations where the application code does not have access to a DB2 client, or where the use of import/load utilities do not apply. The