By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,924 Members | 1,651 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,924 IT Pros & Developers. It's quick & easy.

SQL0444N Routine "DB2XML.CONTENT"

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
12 Replies


P: n/a
I forgot: DB2 UDB V8.2 FP9 on Windows.

"Jean-Marc Blaise" <no****@nowhere.com> wrote in message
news:42**********************@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

Nov 12 '05 #2

P: n/a
Jean-Marc Blaise wrote:
I forgot: DB2 UDB V8.2 FP9 on Windows.

"Jean-Marc Blaise" <no****@nowhere.com> wrote in message
news:42**********************@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
Nov 12 '05 #3

P: n/a
"Serge Rielau" <sr*****@ca.ibm.com> wrote in message
news:3e************@individual.net...
Jean-Marc Blaise wrote:
I forgot: DB2 UDB V8.2 FP9 on Windows.

"Jean-Marc Blaise" <no****@nowhere.com> wrote in message
news:42**********************@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
Nov 12 '05 #4

P: n/a
Jean-Marc Blaise wrote:
"Serge Rielau" <sr*****@ca.ibm.com> wrote in message
news:3e************@individual.net...
Jean-Marc Blaise wrote:
I forgot: DB2 UDB V8.2 FP9 on Windows.

"Jean-Marc Blaise" <no****@nowhere.com> wrote in message
news:42**********************@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
Nov 12 '05 #5

P: n/a
"Serge Rielau" <sr*****@ca.ibm.com> wrote in message
news:3e************@individual.net...
Jean-Marc Blaise wrote:
"Serge Rielau" <sr*****@ca.ibm.com> wrote in message
news:3e************@individual.net...
Jean-Marc Blaise wrote:

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

"Jean-Marc Blaise" <no****@nowhere.com> wrote in message
news:42**********************@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.
Nov 12 '05 #6

P: n/a

"Jean-Marc Blaise" <no****@nowhere.com> wrote in message
news:42*********************@news.wanadoo.fr...
"Serge Rielau" <sr*****@ca.ibm.com> wrote in message
news:3e************@individual.net...
Jean-Marc Blaise wrote:
"Serge Rielau" <sr*****@ca.ibm.com> wrote in message
news:3e************@individual.net...

>Jean-Marc Blaise wrote:
>
>>I forgot: DB2 UDB V8.2 FP9 on Windows.
>>
>>"Jean-Marc Blaise" <no****@nowhere.com> wrote in message
>>news:42**********************@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

Nov 12 '05 #7

P: n/a
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
Nov 12 '05 #8

P: n/a
"Knut Stolze" <st****@de.ibm.com> a écrit dans le message de
news:d6**********@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

Nov 12 '05 #9

P: n/a
Jean-Marc Blaise wrote:
"Knut Stolze" <st****@de.ibm.com> a écrit dans le message de
news:d6**********@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
Nov 12 '05 #10

P: n/a
The db2diag.log should have the full pathname of the library, and the
sqloloadmodule function should dump out the specific OS error that was
returned if it's more than a simple "library not found" message.

Jean-Marc Blaise wrote:
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

Nov 12 '05 #11

P: n/a
Jean-Marc Blaise wrote:
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 :-(


It is indeed a dependency issue and I got a response from the XML extender
folks...

-----------------------------------
The DB2 FP9 delta install fails to "install" certain XML Extender related
files that eventually results in a SQL0444N when running the XML Extender.

*If you are using a test system*, please try replacing the corresponding
files found in the zip file xml_install.zip that is in the following FTP
site:
ftp://ftp.software.ibm.com/ps/produc...p9nt/ptf050515
-----------------------------------

A future (most probable the next) fixpak will take care of this issue for
good.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena
Nov 12 '05 #12

P: n/a
"Knut Stolze" <st****@de.ibm.com> a écrit dans le message de
news:d6**********@fsuj29.rz.uni-jena.de...
Jean-Marc Blaise wrote:
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 :-(


It is indeed a dependency issue and I got a response from the XML extender
folks...

-----------------------------------
The DB2 FP9 delta install fails to "install" certain XML Extender related
files that eventually results in a SQL0444N when running the XML Extender.

*If you are using a test system*, please try replacing the corresponding
files found in the zip file xml_install.zip that is in the following FTP
site:
ftp://ftp.software.ibm.com/ps/produc...p9nt/ptf050515
-----------------------------------

A future (most probable the next) fixpak will take care of this issue for
good.

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


Hi Knut,

Great thanks !!! I have installed successfully these files in SQLLIB\bin and
everything is working fine.

Thanks for your help,

Jean-Marc
Nov 12 '05 #13

This discussion thread is closed

Replies have been disabled for this discussion.