I have a job which reads the data from sequential file and based on some conditions it passes it to two links(link 1 and link2). The data from link1 and link2 has to be upserted into a table. There will be no records for the key in the table initially, so whichever link gets executed first, it will insert the record for the key and the next link will update the record for the same key.
While doing this, sometimes we are experiencing a lock on the record. Is there a way in which we can delay(some kind of timing set) the execution of one link?
record lock in table
Moderators: chulett, rschirm, roy
I don't think you can delay the record through a link. If the metaData is the same then why not funnel them into one link and then upsert. You will have to hash the input to the target stage to avoid lock. Or probably you can write one of the link data into a DataSet and then upsert these records in a separate job.