(Kirsten Ann Larsen and Michael I. Schwartzbach) To demonstrate how to use the new pureXML in DB2 9 for z/OS, we’ve created an actual Web-based application for use in the real-estate industry. In describing this application, we’ll explain the basic technologies of XML, XML Schema, and XPath, so even

(Antonio Cangiano) Support for Rails 2.1 has been added to the latest version of the ibm_db gem (0.9.5). To install this version run gem install ibm_db on Windows.

(Robert Catterall) When data sharing was delivered with DB2 for z/OS (OS/390 at the time) Version 4, more than ten years ago, I was part of IBM’s DB2 National Technical Support team at the Dallas Systems Center. I was tasked at the time with learning all that I could about data sharing, so that I co

(Hardeep Singh) This article is an introduction to InfoSphere MashupHub, part of the IBM Mashup Center product. You’ll learn about the architecture of the product and about the different tools and utilities within it. Then, explore a simple use case scenario that showcases the different components a

(Willie Favero) Sure, I’m not the one doing the upgrade to DB2 9 and as I always say “It’s not pager that goes off you if take my advice”. However, this time I really believe that if you are on DB2 Version 8 it’s time for you start putting your plans together to upgrade to the latest and greatest DB

(Craig Mullins) Here is a question that was posed to me recently: Q: We have a CHAR(10) column that cannot contain alphabetic characters. How can we make sure that the letters A thru Z are not allowed.

(Kent Milligan) With the announcement of the new IBM Power System platform in April, IBM unified the integrated IBM System i with the IBM System p product line. The integrated operating system that has served AS/400, iSeries, and System i clients for over two decades was also renamed from i5/OS to I

(Paolo Bruni, Gaurav Bhagat, Lothar Goeggelmann, Sreenivasa Janaki, Andrew Keenan, Cristian Molaro and Frank Neumann) Enterprises look more and more to business intelligence to gain a competitive edge. Todays business intelligence systems incorporate large data warehouses that are consolidated with

(Harjit Thind) Over the years we have had many questions about when or how often should a reorg be run on tables in a database.

(Chris Eaton) There have been a number of questions lately on my backup and recovery postings which has been great. One of the questions was how to do recovery to get the database back to a specific point in time. Its easier today than it has been in the past. The command to use is the RECOVER comma