Hello-

I am trying to enable the XML support for the database running on the 8.2.3 server on Windows and is getting the error message below:

db2 => connect to mydb user myadmin using mypassword
Database Connection Information
Database server = DB2/NT 8.2.3
SQL authorization ID = myadmin
Local database alias = mydb

db2 => bind "C:\Program Files\IBM\SQLLIB\bnd\@dxxbind.lst"
LINE MESSAGES FOR dxxbind.lst
------ --------------------------------------------------------------------
SQL0061W The binder is in progress.
LINE MESSAGES FOR dxxcomp.bnd
------ --------------------------------------------------------------------
2015 SQL0204N "DB2XML.XML_USAGE" is an undefined name.
SQLSTATE=01532
LINE MESSAGES FOR dxxbind.lst
------ --------------------------------------------------------------------
SQL0091N Binding was ended with "0" errors and "1" warnings.
db2 =>terminate
H:\>dxxadm enable_db mydb -l myadmin -p mypassword
DXXA002I Connecting to database "mydb".
DXXA005I Enabling database "mydb". Please wait.
SQL0818N A timestamp conflict occurred. SQLSTATE=51003
DXXM001W A DB2 error occurred.
DXXG001E An internal error occured in build "Aug 12 2005/13:18:27", file "dxxsuwo.sqx", and line "339".

Any help is highly appreciated

Thanks

I would try to use the ADD keyword after you bind, or use replace if that does not work.

I would recommend that you not use XML Extender since native XML support will be available in Version 9, and XML Extender will not be supported in Version 10 (according to my sources at IBM).

I also had to run: db2updv8 -d mydb-u myuser -p mypassword -c 1.

Thanks for your help

Marcus

I also had to run: db2updv8 -d mydb-u myuser -p mypassword -c 1.

Thanks for your help

That is officially confirmed in the new documentation

Sathyaram

Thank you all for your replays

well...untill the new version comes I have to use this tool. Now when I got it working I am getting the error below even for the sample file :
db2 => values (db2xml.XMLClobFromFile('D:\Program Files\IBM\SQLLIB\samples\db2xml\dad\valid.dad'))
---------------
SQL0443N Routine "DB2XML.XMLCLOBFROMFILE" (specific name "DXXCLOB") has returned an error SQLSTATE with diagnostic text "DXXC002E Unable to read file. ". SQLSTATE=38X02

Any ideas?
Thanks
Victoria