SEO

#1 (**permalink**) 02-26-2008, 10:00 AM

Hi,

I'm trying to load a XML file into a table DB2 (Version 7.2) with XML
Extender.
It work fine if my file have a dimension 1K

But if my file have bigger dimension (12 M ) I get this error message:

parse err 10 in file C:\temp\dxx11 line 26301 col 49: DXXQ047E Parser error
on
line 26301 column 49: Expected end of tag 'CodiceClienteCapogruppo'

My xml file is valid (I'm sure), but load fail.

This is my command:
"C:\dxx\bin\shred.exe" DBNAME filename.dad "C:\temp\filename.xml"

I work on PC with Win2000.

Thanks for yours replies.

#2 (**permalink**) 02-26-2008, 10:00 AM

Hello,

I belive that CLOB the limit is 1MB. Check the Appendix D of the XML
Extender Admin Guide.

ftp://ftp.software.ibm.com/ps/produc...r/db2sxe70.pdf

There's a link on increasing the CLOB limit at the bottom of the page.

Kind regards,
Eric

Silvano Attolini wrote:
> Hi,
>
> I'm trying to load a XML file into a table DB2 (Version 7.2) with XML
> Extender.
> It work fine if my file have a dimension 1K
>
> But if my file have bigger dimension (12 M ) I get this error message:
>
> parse err 10 in file C:\temp\dxx11 line 26301 col 49: DXXQ047E Parser error
> on
> line 26301 column 49: Expected end of tag 'CodiceClienteCapogruppo'
>
> My xml file is valid (I'm sure), but load fail.
>
> This is my command:
> "C:\dxx\bin\shred.exe" DBNAME filename.dad "C:\temp\filename.xml"
>
> I work on PC with Win2000.
>
> Thanks for yours replies.
>
>
>
>
>

#3 (**permalink**) 02-26-2008, 10:03 AM

Silvano Attolini wrote:
> I have increased the CLOB limit in dxxShredXML and dxxInsertXML following
> this steps:
>
> 1) db2 DROP PROCEDURE db2xml.dxxShredXML
>
>
> 2) db2 create procedure db2xml.dxxShredXML( in dadBuf Clob(100K),
>
> in XMLObj Clob(20M),
>
> out returnCode integer,
>
> out returnMsg varchar(1024))
> external name 'db2xml!dxxShredXML'
> language C
> parameter style DB2DARI
> not deterministic
> fenced
> null call;
>
>
> but we have same results.

Telling DB2 that the compiled function can handle larger chunks of data
doesn't change the behavior of the object code which gets called!

Or, am I missing something here?

> "Eric Sirois" <esiroisREMOVESPAMFILTER@ca.ibm.com> ha scritto nel messaggio
> news:bf9h5c$4vu$1@hanover.torolab.ibm.com...
>
>>Hello,
>>
>>I belive that CLOB the limit is 1MB. Check the Appendix D of the XML
>>Extender Admin Guide.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

DB2 XML EXTENDER