Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2006
    Posts
    4

    Unanswered: ***XML Extender for DB2 8.2.3****

    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

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Apr 2006
    Posts
    4

    it works

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

    Thanks for your help

  4. #4
    Join Date
    Apr 2006
    Posts
    4
    Marcus

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

    Thanks for your help

  5. #5
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    That is officially confirmed in the new documentation

    Sathyaram

    Quote Originally Posted by Marcus_A
    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).
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  6. #6
    Join Date
    Apr 2006
    Posts
    4

    Sql0443n Db2xml.xmlclobfromfile

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •