Hi Folks,

I'm getting this message with the XML tutorial: getstart_exportXML.cmd file:

SQL0444N Routine "DB2XML.CONTENT" (specific name "DB2XMLCONTENTVF") is
implemented with code in library or path "\db2xmlfn", function
"dxxContent_varchar2file" which cannot be accessed. Reason code: "4".
SQLSTATE=42724
DB20000I The TERMINATE command completed successfully.

db2xmlfn.dll is in E:\SQLLIB\FUNCTION as well as others, like db2clifn.dll
(I tried ABS in SQL and it works).

Do you have any ideas to solve this problem ?

Thanks,

JM

I forgot: DB2 UDB V8.2 FP9 on Windows.

"Jean-Marc Blaise" <nobody@nowhere.com> wrote in message
news:428a295f$0$3113$8fcfb975@news.wanadoo.fr...
> Hi Folks,
>
> I'm getting this message with the XML tutorial: getstart_exportXML.cmd
file:
>
> SQL0444N Routine "DB2XML.CONTENT" (specific name "DB2XMLCONTENTVF") is
> implemented with code in library or path "\db2xmlfn", function
> "dxxContent_varchar2file" which cannot be accessed. Reason code: "4".
> SQLSTATE=42724
> DB20000I The TERMINATE command completed successfully.
>
> db2xmlfn.dll is in E:\SQLLIB\FUNCTION as well as others, like db2clifn.dll
> (I tried ABS in SQL and it works).
>
> Do you have any ideas to solve this problem ?
>
> Thanks,
>
> JM
>
>

Jean-Marc Blaise wrote:
> I forgot: DB2 UDB V8.2 FP9 on Windows.
>
> "Jean-Marc Blaise" <nobody@nowhere.com> wrote in message
> news:428a295f$0$3113$8fcfb975@news.wanadoo.fr...
>
>>Hi Folks,
>>
>>I'm getting this message with the XML tutorial: getstart_exportXML.cmd
>
> file:
>
>>SQL0444N Routine "DB2XML.CONTENT" (specific name "DB2XMLCONTENTVF") is
>>implemented with code in library or path "\db2xmlfn", function
>>"dxxContent_varchar2file" which cannot be accessed. Reason code: "4".
>>SQLSTATE=42724
>>DB20000I The TERMINATE command completed successfully.
>>
>>db2xmlfn.dll is in E:\SQLLIB\FUNCTION as well as others, like db2clifn.dll
>>(I tried ABS in SQL and it works).
>>
>>Do you have any ideas to solve this problem ?
>>
ABS is SYSIBM.
Try SYSFUN.APPLICATION_ID() and see what it does.

Is this the first time you try to use DB2XML.CONTENT()?
Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

"Serge Rielau" <srielau@ca.ibm.com> wrote in message
news:3euobmF544o4U1@individual.net...
> Jean-Marc Blaise wrote:
> > I forgot: DB2 UDB V8.2 FP9 on Windows.
> >
> > "Jean-Marc Blaise" <nobody@nowhere.com> wrote in message
> > news:428a295f$0$3113$8fcfb975@news.wanadoo.fr...
> >
> >>Hi Folks,
> >>
> >>I'm getting this message with the XML tutorial: getstart_exportXML.cmd
> >
> > file:
> >
> >>SQL0444N Routine "DB2XML.CONTENT" (specific name "DB2XMLCONTENTVF") is
> >>implemented with code in library or path "\db2xmlfn", function
> >>"dxxContent_varchar2file" which cannot be accessed. Reason code: "4".
> >>SQLSTATE=42724
> >>DB20000I The TERMINATE command completed successfully.
> >>
> >>db2xmlfn.dll is in E:\SQLLIB\FUNCTION as well as others, like
db2clifn.dll
> >>(I tried ABS in SQL and it works).
> >>
> >>Do you have any ideas to solve this problem ?
> >>
> ABS is SYSIBM.
> Try SYSFUN.APPLICATION_ID() and see what it does.
>
> Is this the first time you try to use DB2XML.CONTENT()?
> Cheers
> Serge
>
> --
> Serge Rielau
> DB2 SQL Compiler Development
> IBM Toronto Lab

Hi Serge,

Yes.

Jean-Marc

Jean-Marc Blaise wrote:
> "Serge Rielau" <srielau@ca.ibm.com> wrote in message
> news:3euobmF544o4U1@individual.net...
>
>>Jean-Marc Blaise wrote:
>>
>>>I forgot: DB2 UDB V8.2 FP9 on Windows.
>>>
>>>"Jean-Marc Blaise" <nobody@nowhere.com> wrote in message
>>>news:428a295f$0$3113$8fcfb975@news.wanadoo.fr.. .
>>>
>>>
>>>>Hi Folks,
>>>>
>>>>I'm getting this message with the XML tutorial: getstart_exportXML.cmd
>>>
>>>file:
>>>
>>>
>>>>SQL0444N Routine "DB2XML.CONTENT" (specific name "DB2XMLCONTENTVF") is
>>>>implemented with code in library or path "\db2xmlfn", function
>>>>"dxxContent_varchar2file" which cannot be accessed. Reason code: "4".
>>>>SQLSTATE=42724
>>>>DB20000I The TERMINATE command completed successfully.
>>>>
>>>>db2xmlfn.dll is in E:\SQLLIB\FUNCTION as well as others, like
>
> db2clifn.dll
>
>>>>(I tried ABS in SQL and it works).
>>>>
>>>>Do you have any ideas to solve this problem ?
>>>>
>>
>>ABS is SYSIBM.
>>Try SYSFUN.APPLICATION_ID() and see what it does.
>>
>>Is this the first time you try to use DB2XML.CONTENT()?
> Yes.
And I take it SYSFUN.APPLICATION_ID() works..?
What about permissions on db2xmlfn.dll are they the same as for
db2clifn.dll ?


--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

"Serge Rielau" <srielau@ca.ibm.com> wrote in message
news:3eus70F55hk2U1@individual.net...
> Jean-Marc Blaise wrote:
> > "Serge Rielau" <srielau@ca.ibm.com> wrote in message
> > news:3euobmF544o4U1@individual.net...
> >
> >>Jean-Marc Blaise wrote:
> >>
> >>>I forgot: DB2 UDB V8.2 FP9 on Windows.
> >>>
> >>>"Jean-Marc Blaise" <nobody@nowhere.com> wrote in message
> >>>news:428a295f$0$3113$8fcfb975@news.wanadoo.fr.. .
> >>>
> >>>
> >>>>Hi Folks,
> >>>>
> >>>>I'm getting this message with the XML tutorial: getstart_exportXML.cmd
> >>>
> >>>file:
> >>>
> >>>
> >>>>SQL0444N Routine "DB2XML.CONTENT" (specific name "DB2XMLCONTENTVF")
is
> >>>>implemented with code in library or path "\db2xmlfn", function
> >>>>"dxxContent_varchar2file" which cannot be accessed. Reason code: "4".
> >>>>SQLSTATE=42724
> >>>>DB20000I The TERMINATE command completed successfully.
> >>>>
> >>>>db2xmlfn.dll is in E:\SQLLIB\FUNCTION as well as others, like
> >
> > db2clifn.dll
> >
> >>>>(I tried ABS in SQL and it works).
> >>>>
> >>>>Do you have any ideas to solve this problem ?
> >>>>
> >>
> >>ABS is SYSIBM.
> >>Try SYSFUN.APPLICATION_ID() and see what it does.
> >>
> >>Is this the first time you try to use DB2XML.CONTENT()?
> > Yes.
> And I take it SYSFUN.APPLICATION_ID() works..?
> What about permissions on db2xmlfn.dll are they the same as for
> db2clifn.dll ?
>
>
> --
> Serge Rielau
> DB2 SQL Compiler Development
> IBM Toronto Lab

Application_id() works and permissions on both dll are the same:
read&execute + read + write for DB2USERS and all for SYSTEM,DB2ADMNS +
Administrators.

"Jean-Marc Blaise" <nobody@nowhere.com> wrote in message
news:428a3ff8$0$839$8fcfb975@news.wanadoo.fr...
> "Serge Rielau" <srielau@ca.ibm.com> wrote in message
> news:3eus70F55hk2U1@individual.net...
> > Jean-Marc Blaise wrote:
> > > "Serge Rielau" <srielau@ca.ibm.com> wrote in message
> > > news:3euobmF544o4U1@individual.net...
> > >
> > >>Jean-Marc Blaise wrote:
> > >>
> > >>>I forgot: DB2 UDB V8.2 FP9 on Windows.
> > >>>
> > >>>"Jean-Marc Blaise" <nobody@nowhere.com> wrote in message
> > >>>news:428a295f$0$3113$8fcfb975@news.wanadoo.fr.. .
> > >>>
> > >>>
> > >>>>Hi Folks,
> > >>>>
> > >>>>I'm getting this message with the XML tutorial:
getstart_exportXML.cmd
> > >>>
> > >>>file:
> > >>>
> > >>>
> > >>>>SQL0444N Routine "DB2XML.CONTENT" (specific name "DB2XMLCONTENTVF")
> is
> > >>>>implemented with code in library or path "\db2xmlfn", function
> > >>>>"dxxContent_varchar2file" which cannot be accessed. Reason code:
"4".
> > >>>>SQLSTATE=42724
> > >>>>DB20000I The TERMINATE command completed successfully.
> > >>>>
> > >>>>db2xmlfn.dll is in E:\SQLLIB\FUNCTION as well as others, like
> > >
> > > db2clifn.dll
> > >
> > >>>>(I tried ABS in SQL and it works).
> > >>>>
> > >>>>Do you have any ideas to solve this problem ?
> > >>>>
> > >>
> > >>ABS is SYSIBM.
> > >>Try SYSFUN.APPLICATION_ID() and see what it does.
> > >>
> > >>Is this the first time you try to use DB2XML.CONTENT()?
> > > Yes.
> > And I take it SYSFUN.APPLICATION_ID() works..?
> > What about permissions on db2xmlfn.dll are they the same as for
> > db2clifn.dll ?
> >
> >
> > --
> > Serge Rielau
> > DB2 SQL Compiler Development
> > IBM Toronto Lab
>
> Application_id() works and permissions on both dll are the same:
> read&execute + read + write for DB2USERS and all for SYSTEM,DB2ADMNS +
> Administrators.
>
Serge,

I get the same behavior on anoter PC with same config V8.2 FP9 / W2K.

HTH,

JM

Jean-Marc Blaise wrote:

>>
>> Application_id() works and permissions on both dll are the same:
>> read&execute + read + write for DB2USERS and all for SYSTEM,DB2ADMNS +
>> Administrators.
>>
> Serge,
>
> I get the same behavior on anoter PC with same config V8.2 FP9 / W2K.

This looks like an installation problem to me. Most probably there are some
dependencies of the lib that could not be resolved.

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

"Knut Stolze" <stolze@de.ibm.com> a écrit dans le message de
news:d6et09$6eb$2@fsuj29.rz.uni-jena.de...
> Jean-Marc Blaise wrote:
>
> >>
> >> Application_id() works and permissions on both dll are the same:
> >> read&execute + read + write for DB2USERS and all for SYSTEM,DB2ADMNS +
> >> Administrators.
> >>
> > Serge,
> >
> > I get the same behavior on anoter PC with same config V8.2 FP9 / W2K.
>
> This looks like an installation problem to me. Most probably there are
some
> dependencies of the lib that could not be resolved.
>
> --
> Knut Stolze
> Information Integration
> IBM Germany / University of Jena

Hi Knut,

Thanks for your comment.

The only dependency problem that is referenced on the IBM support site for
SQL0444N is about msvcp60.dll, that is also used by the db2xml.dll function.
But, the dxxadm enable_db command and other functions that seem to use the
db2xml.dll function work perfectly.

To install 2 PCs and get the same problem, on Windows, make me think the
problem is not linked to the installation ... I have switched DIAGLEVEL to
4 but did not get better help. It's a pitty to have such a message and not
being capable to diagnose the source of the problem :-(

Everything works fine on Linux though ...

Regards,

Jean-Marc

Jean-Marc Blaise wrote:

> "Knut Stolze" <stolze@de.ibm.com> a écrit dans le message de
> news:d6et09$6eb$2@fsuj29.rz.uni-jena.de...
>>
>> This looks like an installation problem to me. Most probably there are
> some
>> dependencies of the lib that could not be resolved.
>>
>
> The only dependency problem that is referenced on the IBM support site for
> SQL0444N is about msvcp60.dll, that is also used by the db2xml.dll
> function. But, the dxxadm enable_db command and other functions that seem
> to use the db2xml.dll function work perfectly.

There are two different libraries: "db2xmlfn.dll" and "db2xml.dll". The
former is the one that contains the logic of the UDFs and the latter
contains the stored procedures, for example enable_db. So a proper
functioning of db2xml.dll does not say that dependencies of the UDF-library
are fine.

I had a look at the differences of the dependencies between the two libs,
and db2xmlfn.dll needs additionally an XSLT library (besides a couple other
DB2 libs). This library should be installed as part of the DB2 engine
under sqllib/bin/. In my installation, I have there
sqllib/bin/xml4c_5_3_0.dll (which should be working for you given that
enable_db succeeded) and sqllib/bin/xslt4c_1_6_0.dll. If you don't have
the 2nd lib, it might be the reason for the problem.

> To install 2 PCs and get the same problem, on Windows, make me think the
> problem is not linked to the installation ... I have switched DIAGLEVEL
> to 4 but did not get better help. It's a pitty to have such a message and
> not being capable to diagnose the source of the problem :-(

SQL0444, rc=4 is usually a pure operating system thing. DB2 uses OS calls
like dlopen() to load a library, and the OS handles the dependencies. If
one of the dependencies cannot be loaded, then the loading of the requested
library fails. The OS doesn't give any additional information to DB2
regarding the actual reason for the failure.

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