Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
7 replies Latest Post - ‏2012-10-23T04:51:44Z by MatthiasNicola
MKJT_Michael_Oliver
MKJT_Michael_Oliver
17 Posts
ACCEPTED ANSWER

Pinned topic DB2 9 pureXML Guide

‏2012-10-17T06:03:36Z |
I have read the Redbook DB2 9 pureXML Guide and while it renewed my interest in pureXML there is one problem and I hope someone has a solution. There is nothing wrong with the document per se, yes some minor things have changed since it was published but the problem is that the example app "XMLoan.war" with sources is noplace to be found. It says its in the distribution, but of course it isn't in the latest DB2 Express-C. Does someone have a copy they can share here? or DropBox? or ftp?
Updated on 2012-10-23T04:51:44Z at 2012-10-23T04:51:44Z by MatthiasNicola
  • MatthiasNicola
    MatthiasNicola
    6 Posts
    ACCEPTED ANSWER

    Re: DB2 9 pureXML Guide

    ‏2012-10-22T06:25:03Z  in response to MKJT_Michael_Oliver
    Hi Michael,

    please be aware that Redbooks and the samples provided with Redbooks are not maintained and kept up to date like the official product documentation and the official product samples.

    Anyway, I will see if I can locate the XMLoan.war file and -if successful- post a link here.

    However, I would not recommend using the DB2 9 pureXML Redbook from 2006. This book was specific to DB2 9.1 which is quite outdated by now. DB2 versions 9.5, http://www.ibm.com/developerworks/data/library/techarticle/dm-0904db297purexml/index.html, and http://nativexmldatabase.com/2012/04/19/xml-enhancements-in-db2-10-for-linux-unix-and-windows/ have added major enhancements to pureXML that are not reflected in that Redbook.

    Here are some suggested resources:

    DB2 pureXML product documentation:
    http://pic.dhe.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.db2.luw.xml.doc/doc/c0022308.html

    DB2 pureXML Tutorial
    http://pic.dhe.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.db2.luw.xml.doc/doc/c0023610.html

    DB2 pureXML Cookbook
    https://www.ibm.com/developerworks/wikis/display/db2xml/DB2+pureXML+Cookbook

    DB2 pureXML Technical Articles & Papers
    http://www.ibm.com/developerworks/wikis/display/db2xml/Technical+Papers+and+Articles
    Matthias

    Matthias Nicola
    http://www.tinyurl.com/pureXML
    http://nativexmldatabase.com/
    • MKJT_Michael_Oliver
      MKJT_Michael_Oliver
      17 Posts
      ACCEPTED ANSWER

      Re: DB2 9 pureXML Guide

      ‏2012-10-23T00:03:52Z  in response to MatthiasNicola
      Mathias,

      There is an old saying, "I don't know what I don't know". As the former CTO of the Knowledge Management Professional Society, one of the aspects of Knowledge Management is retiring of elements of the Knowledge Base that are out of date or irrelevant. In Military and other Intelligence agencies there is the concept of "time of significant value", i.e. intelligence is often stampled with a "LTIOV" latest time of value. Certainly articles in developer works, that are no longer of significant value as they are out of date, provide irrelevant or erroneious information, should be retired. Sure the user / reader should look to see if something is current, but that's not always apparent. Those of you that are in the know, don't see a problem, after all you know what the latest version of this or that is, and can filter results easily. But someone that isn't as well informed and searches your knowledge base / library of documentation and articles cannot judge until they spend time.

      Some sort of feedback mechanism, "not popularity contest" needs to be implemented where the consumers of the data can flag content that is out of date or irrelevant or just plain wrong for others to see automatically in the heading meta data for your articles. Then if there is some content of merit and therefore needs to be retained, but some out of date information, the reader can much more easily see that before spending time only to find out it was wrong.

      I hope you and this community see this as constructive criticism.
    • MKJT_Michael_Oliver
      MKJT_Michael_Oliver
      17 Posts
      ACCEPTED ANSWER

      Re: DB2 9 pureXML Guide

      ‏2012-10-23T00:51:21Z  in response to MatthiasNicola
      LOL Pardon me for laughing. Thanks for the up to date links. I am laughing because I went to the tutorial link and the very first step says

      Create a database called XMLTUT by issuing the following command:
      CREATE DATABASE xmltut~

      only problem is when I open CLP and enter

      CREATE DATABASE xmltut~ it fails with

      SQL1001N "xmltut~" is not a valid database name. SQLSTATE=2E000

      So I looked up the error and tried

      CREATE DATABASE xmltut

      nothing happened, like it was dead. I do see the database XMLTUT in NODE0000 and when I restart CLP and type

      connect to xmltut it says "The database is currently in use." Cool...I guess. Nothing in the tutorial about that...oh well, trial and error.
  • MatthiasNicola
    MatthiasNicola
    6 Posts
    ACCEPTED ANSWER

    Re: DB2 9 pureXML Guide

    ‏2012-10-22T16:40:48Z  in response to MKJT_Michael_Oliver
    Hi Michael,

    the download you are looking for is actually exactly where it should be. Please take another look as follows:

    Go to the website of the DB2 9 pureXML Redbook:
    http://www.redbooks.ibm.com/abstracts/sg247315.html

    Click on the link called "Additional Material"
    ftp://www.redbooks.ibm.com/redbooks/SG247315

    Then download the file "setup.zip" which contains the XMLoan.war file:
    ftp://www.redbooks.ibm.com/redbooks/SG247315/setup.zip

    I just downloaded it without a problem.

    Thanks,

    Matthias


    Matthias Nicola
    http://www.tinyurl.com/pureXML
    http://nativexmldatabase.com/
    • MKJT_Michael_Oliver
      MKJT_Michael_Oliver
      17 Posts
      ACCEPTED ANSWER

      Re: DB2 9 pureXML Guide

      ‏2012-10-23T00:20:00Z  in response to MatthiasNicola
      Mathias,

      Uh well no "exactly" is not correct. When I went to that link ftp://www.redbooks.ibm.com/redbooks/SG247315

      I got...

      227 Entering Passive Mode (170,225,15,45,14,82)
      550 /redbooks/SG24731501: No such file or directory.

      I am happy to hear you had no problem.
      • MatthiasNicola
        MatthiasNicola
        6 Posts
        ACCEPTED ANSWER

        Re: DB2 9 pureXML Guide

        ‏2012-10-23T04:51:44Z  in response to MKJT_Michael_Oliver
        Hi Michael,

        thanks for your comment on retiring old or outdated material. You have a valid point.

        As for the problem that "CREATE DATABASE xmltut~" fails, please note the advice on the first page of the tutorial where it says:

        In a DB2 command window, start the DB2 command-line processor by issuing the db2 -td~ command, the db2 command with the -td~ option.
        The -td option sets the tilde (~) as the statement termination character. Specifying a termination character other than the default semicolon (-t option) ensures that statements or queries that use namespace declarations are not misinterpreted, because namespace declarations are also terminated by a semicolon. The examples throughout this tutorial use the ~ termination character.

        If you start the DB2 command line processor with the -td~ option, than the specified create database statement should work fine.

        Regarding the download of the sample code: does it work for you if you go to the redbook page first (http://www.redbooks.ibm.com/abstracts/sg247315.html) and then click on "Additional material"?

        In any case, I have attached the downloaded sample code as an attachment to this post.

        Best regards,

        Matthias

        Matthias Nicola
        http://www.tinyurl.com/pureXML
        http://nativexmldatabase.com/