Guogen Zhang is a Senior Technical Staff Member at IBM. He is the Architect and Lead Developer responsible for pureXML in DB2 for z/OS (in other words, DB2 on the mainframe). Guogen has put together a very nice 10-part podcast series about DB2 pureXML. You can hear his podcasts at http://www.ibm.com/developerworks/wikis/display/db2xml/DB2+for+zOS+pureXML

Recently, a few clients have asked about using commercial Business Intelligence (BI) software to generate reports for information that is stored in native XML format. I received these requests from clients with data-centric XML-based applications, where they want to generate reports against transactional data. For DB2 pureXML, there are a few possible approaches to generating such reports. See the following two articles for more information:

    Create Business Reports for XML Data with Cognos 8 BI and DB2 pureXML (http://www.ibm.com/developerworks/data/library/techarticle/dm-0811saracco/index.html)
    In this article, Cindy Saracco and Tad Worley tell you how to use Cognos 8 Business Intelligence to generate reports for information stored using DB2 pureXML. DB2 pureXML is, of course, the native XML storage capability in the IBM DB2 database.

    Create Business Reports for XML Data using IBM DataQuant and DB2 pureXML (http://www.ibm.com/developerworks/data/library/techarticle/dm-0901patterson/index.html)
    In this article, Bryan Patterson and Terry Zhang tell you how to use DataQuant to generate reports for information stored using DB2 pureXML. DataQuant is a Business Intelligence (BI) tool from IBM, based upon the Eclipse open development platform and available on a variety of systems including IBM System Z™, Linux, Microsoft® Windows, IBM AIX®, and Solaris.

DB2 Technology Sandbox

January 20, 2009

Do you want to get your hands on the latest innovations from the IBM labs? Would you like to provide feedback to help shape new product features? IBM has opened the DB2 Technology Sandbox, which allows you to download and play with technology that is still in the lab. Of course, the IBM developers will be delighted if you have any feedback for them.

The DB2 Technology Sandbox includes several new features for the pureXML feature in DB2–IBM’s native XML database. For more information about the DB2 Technology Sandbox, see http://www.ibm.com/software/data/db2/technology-sandbox/