問(wèn)題描述
我已經(jīng)將一些數(shù)據(jù)從模式 A(表 x)導(dǎo)出到 XML，我正在讀取 XML 并將數(shù)據(jù)插入到模式 B(表 y)中.在 20000 條記錄之后插入數(shù)據(jù)時(shí)，它說(shuō)
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.
該批次已提交，但該批次的單個(gè)成員至少發(fā)生了一次異常.
The batch was submitted, but at least one exception occurred on an individual member of the batch.
我比較了表 x 和表 y 中對(duì)應(yīng)列的數(shù)據(jù)類型，它們是相同的.源和目標(biāo)中的標(biāo)識(shí)(自動(dòng)增量)col 和 LONG VARCHAR 都是 BIGINT..
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..
請(qǐng)幫助解決此問(wèn)題.
推薦答案
我曾經(jīng)遇到過(guò)類似的問(wèn)題.我解決了將隊(duì)列大小添加到 XML 中的問(wèn)題.在我的情況下是這樣的:
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>
使用 queueSize 批量啟動(dòng)查詢.
With the queueSize the queries was launched in batch.
這篇關(guān)于DB2 中的 ERRORCODE=-4461，SQLSTATE=42815的文章就介紹到這了，希望我們推薦的答案對(duì)大家有所幫助，也希望大家多多支持html5模板網(wǎng)！