load问题
DB2 V9文件数据入库时报错
Agent Type Node SQL Code Result
______________________________________________________________________________
LOAD 000 +00003107 RESTART required.
______________________________________________________________________________
LOAD 001 +00003107 RESTART required.
______________________________________________________________________________
LOAD 002 +00003107 RESTART required.
______________________________________________________________________________
LOAD 003 +00003107 RESTART required.
______________________________________________________________________________
LOAD 004 +00003107 RESTART required.
______________________________________________________________________________
LOAD 005 +00003107 RESTART required.
______________________________________________________________________________
LOAD 006 -00006103 Error. RESTART required.
______________________________________________________________________________
LOAD 007 +00003107 RESTART required.
______________________________________________________________________________
PARTITION 001 +00000000 Success.
______________________________________________________________________________
PRE_PARTITION 000 +00000000 Success.
______________________________________________________________________________
RESULTS: 7 of 8 LOADs completed successfully.
______________________________________________________________________________
Summary of Partitioning Agents:
Rows Read = 0
Rows Rejected = 0
Rows Partitioned = 0
Summary of LOAD Agents:
Number of rows read = 0
Number of rows skipped = 0
Number of rows loaded = 0
Number of rows rejected = 0
Number of rows deleted = 0
Number of rows committed = 0
SQL6103C An unexpected utility error occurred. Reason code = "Row found on
wrong partition".
请高手帮忙解决！
Agent Type Node SQL Code Result
______________________________________________________________________________
LOAD 000 +00003107 RESTART required.
______________________________________________________________________________
LOAD 001 +00003107 RESTART required.
______________________________________________________________________________
LOAD 002 +00003107 RESTART required.
______________________________________________________________________________
LOAD 003 +00003107 RESTART required.
______________________________________________________________________________
LOAD 004 +00003107 RESTART required.
______________________________________________________________________________
LOAD 005 +00003107 RESTART required.
______________________________________________________________________________
LOAD 006 -00006103 Error. RESTART required.
______________________________________________________________________________
LOAD 007 +00003107 RESTART required.
______________________________________________________________________________
PARTITION 001 +00000000 Success.
______________________________________________________________________________
PRE_PARTITION 000 +00000000 Success.
______________________________________________________________________________
RESULTS: 7 of 8 LOADs completed successfully.
______________________________________________________________________________
Summary of Partitioning Agents:
Rows Read = 0
Rows Rejected = 0
Rows Partitioned = 0
Summary of LOAD Agents:
Number of rows read = 0
Number of rows skipped = 0
Number of rows loaded = 0
Number of rows rejected = 0
Number of rows deleted = 0
Number of rows committed = 0
SQL6103C An unexpected utility error occurred. Reason code = "Row found on
wrong partition".
请高手帮忙解决！
7 同行回答
同意楼上的兄弟们的观点，文本格式估计是问题的原因。
另外，建议楼主把你执行的语句，报错的信息都贴出来，最好也说明这个load 文件的来源 收起
另外，建议楼主把你执行的语句，报错的信息都贴出来，最好也说明这个load 文件的来源 收起
Rows Read = 0Rows Rejected = 0Rows Partitioned = 0看样子连读都没读到数据，更别说装载了。查查数据和文件格式的问题吧。
[ 本帖最后由 Felix 于 2009-4-9 15:03 编辑 ] 收起
SQL6103C 发生意外的实用程序错误。原因码 = "<原因码>"。
解释:
发生意外的实用程序错误。
用户响应:
记录消息中的消息号 (SQLCODE) 和原因码。
如果跟踪是活动的，则在操作系统命令提示符处
调用“独立跟踪设施”。请参阅 管理指南
以了解有关如何使用此设施的信息。然后与技术服
务代表联系，并提供下列信息：
o 问题描述
o SQLCODE 和嵌入式原因码
o SQLCA 内容（若有可能的话）
o 跟踪文件（若有可能的话） 收起
解释:
发生意外的实用程序错误。
用户响应:
记录消息中的消息号 (SQLCODE) 和原因码。
如果跟踪是活动的，则在操作系统命令提示符处
调用“独立跟踪设施”。请参阅 管理指南
以了解有关如何使用此设施的信息。然后与技术服
务代表联系，并提供下列信息：
o 问题描述
o SQLCODE 和嵌入式原因码
o SQLCA 内容（若有可能的话）
o 跟踪文件（若有可能的话） 收起