ERRORCODE=-4461, SQLSTATE=42815 in DB2

Question

I have exported some data from schema A (table x)to XML and I am reading the XML and inserting the data into schema B(table y). while inserting the data after 20000 records it says

com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][t4][20111][11366][3.63.75] The value of a host variable is too large for its corresponding use.  Host variable=1. ERRORCODE=-4461, SQLSTATE=42815
com.ibm.db2.jcc.am.BatchUpdateException: [jcc][t4][102][10040][3.63.75] Batch failure.

The batch was submitted, but at least one exception occurred on an individual member of the batch.

I compared the data types of the corresponding columns in table x and table y they are the same. It is BIGINT for the identity(Auto increment) col and LONG VARCHAR in both source and destination..

Kindly help in resolving this issue.

Data type might be the same, but what about the length of your fields ? — jazzytomato, Jul 10 '12 at 10:13
Are the schemata in the same database, or are these two different databases? What is the character encoding of them? — david a., Jul 10 '12 at 10:27
Hey thanks for the help, I got the issue there was a problem in my xml generation logic. element data was getting appended twice. — user1374266, Jul 27 '12 at 04:50

score 2 · Answer 1 · answered Nov 04 '15 at 13:05

I had a similar problem one time. I solved it adding to the XML the queue size. In my case was something like this:

<task>
   <name>Ventas MCC</name>
   <queueSize>100</queueSize>
   <queueNames>trashQueue</queueNames>
   <queryTasks>
     <queryTask>...</queryTask>
   </queryTasks>
</task>

With the queueSize the queries was launched in batch.

ERRORCODE=-4461, SQLSTATE=42815 in DB2

1 Answers1

Linked