Same Table as Source and Target
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 29
- Joined: Wed Jan 06, 2010 7:18 am
Same Table as Source and Target
Hi,
Can we use same table as source and target.
Job : Db2stage and lookup file -> Transformer -> DB2stage
Thanks in advance.
Can we use same table as source and target.
Job : Db2stage and lookup file -> Transformer -> DB2stage
Thanks in advance.
Regards,
Kumar
Kumar
-
- Participant
- Posts: 251
- Joined: Mon Jun 09, 2008 5:52 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Such blocking operations are not permitted in parallel jobs. Grimm's solution would require two jobs.
You can use the same table as source and target but you need to make sure that self-deadlocking does not occur, typically by using a transaction size of 1 and an array size of 1 and partitioning on the table key (so that the same key can not arrive into the table from more than one node, which might also cause a locking issue).
You can use the same table as source and target but you need to make sure that self-deadlocking does not occur, typically by using a transaction size of 1 and an array size of 1 and partitioning on the table key (so that the same key can not arrive into the table from more than one node, which might also cause a locking issue).
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.
-
- Participant
- Posts: 29
- Joined: Wed Jan 06, 2010 7:18 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Good thinking, and it may work but it may not. Certainly with a normal reference link the reference data set is completely loaded into memory and an index built before the first lookup is attempted, which is the situation where it may work, provided the database does not continue to hold any lock until the connection is closed.
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.
-
- Participant
- Posts: 29
- Joined: Wed Jan 06, 2010 7:18 am