Hi all ,
I will have to do a Lookup ,Insert and update all on same table Irrespective of volume size ( Actually volume is 50k records), what will be the best design approach can we follow.
1) Can we do Lookup , Update , Insert all on one table and in one job ? If so what will be the pre steps we need to take care.
2) We can Look up the table and write Inserts and update saperatly to a Datasets and having 2 different jobs where one do Insert to table and other Update to table.
Can some one please give me the pros and cons of both approaches too.
Thanks
Rajan
Lookup Insert Update on same table in a job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Use a server job in which you can interpose a blocking operation (these are banned in parallel jobs). Otherwise there are no guarantees - among other things it depends on the level at which you are locking, the number of rows per transaction and the array size.
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.
Thanks Ray,ray.wurlod wrote:Use a server job in which you can interpose a blocking operation (these are banned in parallel jobs). Otherwise there are no guarantees - among other things it depends on the level at which you are locking, the number of rows per transaction and the array size.
Will this imply to the following scenario too?
1) Lookup and target (Insert) are same tables in a single job
2) I will create a diff job for only update.
we are doing this in parallel jobs and Here I will have 2 jobs instead of 3 jobs.