The data & column are stored, but we receive this error. We can retrieve the row fine also.
The settings for these variables are:
XMLVALA=2097152 XMLVALS=2048
Not sure whether it is a jcc driver or xml issue?
thanks for any info.
Hi. The error message is indicating that a resource is unavailable. It is strange that the insert appears to have succeeded. The message should also indicate the resource-name and resource-type that was not available at execution time. It might also help if you indicate what environment the insert was running when you go this message. In the meantime I'll ask a DB2 z expert for insight.
Why? LOB manager is re-used in DB2 for bringing XML data into DB2 from an application and vice versa. LOBVALA and LOBVALS put limits on the XML string size. You need to set LOBVALA to at least the maximum document length you will input and output.
Why? LOB manager is re-used in DB2 for bringing XML data into DB2 from an application and vice versa. LOBVALA and LOBVALS put limits on the XML string size. You need to set LOBVALA to at least the maximum document length you will input and output.
Hi,
I checked the values set for the following parms on our subsystem:
Currently, LOBVALA and LOBVALS are set to 2048kB and 2048MB respectively.
This is probably the problem. It will take a bit more time to have our support area to increase the value to what we need.
Thank you for pointing us to the parms required to change. I will post later whether this resolves our problem.
Again thanks for the prompt response.
Tags
Use the search field to
find all types of content in My developerWorks with that tag.
Use the slider bar to see more or fewer tags.
Popular tags shows the top tags for this particular type of content or application that you're viewing.
My tags shows your tags for this particular type of content or application that
you're viewing.
