Error enable database for use with xml extender

[Jeff]

I am trying to run the getstart_prep.cmd to enable the SALES_DB

on the "/var/tmp/db2/ese/db2/solaris/db2xml81/reloc/IBM/db2/\$PRODVERS/bin/dxxadm
enable_db SALES_DB" command I get the following error:

SQL0444N Routine "*EnableDB" (specific name "SQL040218113955930") is
implemented with code in library or path ".../sqllib/function/db2xml",
function "dxxEnableDB" which cannot be accessed. Reason code: "4".
SQLSTATE=42724
DXXM001W A DB2 error occurred.
DXXA065E Calling stored procedure "db2xml!dxxEnableDB" failed.
I am using db2 v8.1 on solaris.

I modified the getstart_prep.cmd to be contain the following:
LD_LIBRARY_PATH=/var/tmp/db2/ese/db2/solaris/db2xml81/reloc/IBM/db2/\$PRODVERS/lib:/opt/IBM/db2/V8.1
/lib
export LD_LIBRARY_PATH

by doing this I got around my previous error of libicudt20b.so not
found.

Can anyone help me get around this error?

Thanks,

jb

[Knut Stolze]

Jeff <jb***@charter.net> wrote:

I am trying to run the getstart_prep.cmd to enable the SALES_DB

on the
"/var/tmp/db2/ese/db2/solaris/db2xml81/reloc/IBM/db2/\$PRODVERS/bin/dxxadm
enable_db SALES_DB" command I get the following error:

SQL0444N Routine "*EnableDB" (specific name "SQL040218113955930") is
implemented with code in library or path ".../sqllib/function/db2xml",
function "dxxEnableDB" which cannot be accessed. Reason code: "4".
SQLSTATE=42724
DXXM001W A DB2 error occurred.
DXXA065E Calling stored procedure "db2xml!dxxEnableDB" failed.

You do have a library named "db2xml" installed under sqllib/instance, don't
you?

--
Knut Stolze
Information Integration
IBM Germany / University of Jena

[Jeff]

The only directory on the unix box named sqllib is under
"/export/home/db2inst1/sqllib" There is no file called db2xml under
this directory.

I do find four instances of db2xml on this box
/var/tmp/db2/ese/db2/solaris/db2xml81/reloc/IBM/db2/$PRODVERS/db2xml
/var/tmp/db2/ese/db2/solaris/db2xml81/reloc/IBM/db2/$PRODVERS/function/db2xml
/var/tmp/db2/ese/db2/solaris/db2xml81/reloc/IBM/db2/$PRODVERS/samples/db2xml
/var/tmp/db2/ese/db2/solaris/db2xmls81/reloc/IBM/db2/$PRODVERS/samples/db2xml

How would I get this library installed under sqllib?

Thanks,

jb

[Jeff]

Finally found the answer. Version 7.1 of the XML Extender was loaded
on this unix box. The version of XML Extender that comes with 8.1 was
not. I search for the samples, found them, and attempted to run them.
I kept getting strange errors because version 7.1 (32 bit) and 8.1
(64 bit) did not play well together.

The DBAs are now reinstalling DB2 with the XML Extenders, or just
appling the XML Extender to the 8.1 database. This should get rid of
all of my errors.

jb

[gabriel_]

Finally found the answer. Version 7.1 of the XML Extender was loaded
on this unix box. The version of XML Extender that comes with 8.1 was
not. I search for the samples, found them, and attempted to run them.
I kept getting strange errors because version 7.1 (32 bit) and 8.1
(64 bit) did not play well together.

The DBAs are now reinstalling DB2 with the XML Extenders, or just
appling the XML Extender to the 8.1 database. This should get rid of
all of my errors.

jb

Hello,
I have exactly the same problem!!! My version of XML Extender is 7.2 and version of DB2 UDB is 8.2.
Impossible to enable any database because of the error ' "dxxEnableDB" cannot be accessed'.
How can i resolve it???