we are loading a seq file to db2 stage using upsert method and getting this warning message in db2 stage
[code]
Failure. Error code SQL0803N. Execute array one element at the time.
[/code]
what does this warning message means. Please advise as we are getting alot of them.
Unique key violation... you attempted to insert rows with the same key from different processing nodes. The message is telling you to change the commit interval to 1. Doing so will result in one processing node inserting the row and the other processing node updating the row.
[quote="Mike"]Unique key violation... you attempted to insert rows with the same key from different processing nodes. The message is telling you to change the commit interval to 1. Doing so will result in one processing node inserting the row and the other processing node updating the row.
Terala - just an FYI. Your "code" and "quote" tags are not working because (I assume) you have checked/enabled the Disable BBCode in this post option for some reason. Uncheck that or change the default in your profile and they'll work as designed.
-craig
"You can never have too many knives" -- Logan Nine Fingers