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 12 2839
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
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
"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
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
"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.
"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
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" <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
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
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
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
"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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Justin |
last post by:
I have a program that downloads files from the web. There are
instances in which a .info() will not return a "Content-length" header
to me. Is ther a way to specifically request this header or...
|
by: Blue® |
last post by:
I would like to call the content of content.htm (containing only HTML
codes) into index.htm.
This is usually done by renaming index.htm to index.shtml and use this tag:
<!--#include...
|
by: Michael Strorm |
last post by:
Hi!
I've been having problems with a DTD. Having had the Sun XML validator
reject a document, I put it through 'xmllint' for more information.
'Xmllint' noted a problem with the DTD itself;...
|
by: J.Edwards |
last post by:
I'm getting this error when trying to use a control built in VS 2003 (1.1)
in a new asp project in VS 2005.
"Content controls can only be used in a content page"
The control has always worked...
|
by: Phil |
last post by:
I am writing an application (using Visual Studio 2003) that consumes a third
party Web Service, but I receive the following error :
Client found response content type of 'application/xml;...
|
by: Trapulo |
last post by:
I've this statement in my output's creation:
Response.Clear()
Response.ContentType = "application/vnd.google-earth.kml+xml kml"
Response.AddHeader("Content-Disposition", "inline;...
|
by: Kevin Frey |
last post by:
We have a data-centric application where all of the "layout" for each data
centric page is to be codified (ie. it is expressed in C# code rather than
being expressed declaratively). This...
|
by: dave8421 |
last post by:
Hi,
I'm trying to make sense of the definition for "Rendered Content" in
current CR for CSS 2.1
Is rendered content what is displayed on the particular media or
device? from the...
|
by: Alexander Smirnov |
last post by:
I'm developing asp.net 2 web application and need to make a custom
http handler which sometime must send response with "204 No Content"
code.
I set HttpResponse.Status="204 No Content"; But asp...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |