We have created a job which was loading about 5,000 records per second. But suddenly its loading only 10-12 records per sec. When we looked into the log for the job we found the following error. Can any body help us in this.
Part_Dimension_Loading_Final_3..DB2_UDB_API_1: This update action 'update or insert' is not compatible with parameter array binding. Array Size property will be set to 1.
Array size is not compatible plz help.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 232
- Joined: Fri Sep 30, 2005 4:52 am
- Contact:
-
- Premium Member
- Posts: 108
- Joined: Sat Feb 05, 2005 6:52 pm
- Location: US
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 252
- Joined: Mon Sep 19, 2005 10:28 pm
- Location: Melbourne, Australia
- Contact:
I could be wrong, but 5000/s is pretty darned fast (excuse my dockyards language) for an Update Else Insert job. Is it possible that it used to be Insert Only or Update Only and has recently been changed?
My experience is with Oracle, not DB2, but I have found Array Size / Transaction Size ineffective when using "Update Else Insert" or "Insert Else Update" because the logic to perform the second command if the first fails forces it to run one transaction at a time.
My experience is with Oracle, not DB2, but I have found Array Size / Transaction Size ineffective when using "Update Else Insert" or "Insert Else Update" because the logic to perform the second command if the first fails forces it to run one transaction at a time.
Ross Leishman
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Perhaps the answers on the other active thread on this issue would be a good place to look.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.