NOTICE: 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.
This topic has been locked.
7 replies Latest Post - 2012-10-23T04:51:44Z by MatthiasNicola
Pinned topic DB2 9 pureXML Guide
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
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
Re: DB2 9 pureXML Guide2012-10-22T06:25:03Z in response to MKJT_Michael_OliverHi 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:
DB2 pureXML Tutorial
DB2 pureXML Cookbook
DB2 pureXML Technical Articles & Papers
Re: DB2 9 pureXML Guide2012-10-23T00:03:52Z in response to MatthiasNicolaMathias,
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.
Re: DB2 9 pureXML Guide2012-10-23T00:51:21Z in response to MatthiasNicolaLOL 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.
Re: DB2 9 pureXML Guide2012-10-22T16:40:48Z in response to MKJT_Michael_OliverHi 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:
Click on the link called "Additional Material"
Then download the file "setup.zip" which contains the XMLoan.war file:
I just downloaded it without a problem.
Re: DB2 9 pureXML Guide2012-10-23T00:20:00Z in response to MatthiasNicolaMathias,
Uh well no "exactly" is not correct. When I went to that link ftp://www.redbooks.ibm.com/redbooks/SG247315
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.
Re: DB2 9 pureXML Guide2012-10-23T04:51:44Z in response to MKJT_Michael_OliverHi 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.