Working of Link Ordering
Moderators: chulett, rschirm, roy
Working of Link Ordering
Hi,
I have a job which reads data from DB2.. Upserts them into DB2 (link 1) & update a flag in DB2(link 2).
How this works ?? Will the 1st record sent to Link 1 gets processed before its being sent to link 2 ??
Or the transformer link ordering doesn't have any impact on this & the records flow directly on link 1 & link 2. (both are main outputs & not rejects).
Regards,
dxk9
I have a job which reads data from DB2.. Upserts them into DB2 (link 1) & update a flag in DB2(link 2).
How this works ?? Will the 1st record sent to Link 1 gets processed before its being sent to link 2 ??
Or the transformer link ordering doesn't have any impact on this & the records flow directly on link 1 & link 2. (both are main outputs & not rejects).
Regards,
dxk9
Re: Working of Link Ordering
This.dxk9 wrote:Will the 1st record sent to Link 1 gets processed before its being sent to link 2 ??
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
We don't have any delay in the processing of records in Link1 (insert else update) & Link2 (update). Especially don't want Link 2 to be faster than Link1.
But since the logic of both the links are different, we thought it might be an issue.
So since you say that Link1 processes first before the record goes to Link2, we can go ahead with the design right ?
Thanks,
dxk9
But since the logic of both the links are different, we thought it might be an issue.
So since you say that Link1 processes first before the record goes to Link2, we can go ahead with the design right ?
Thanks,
dxk9
It really is as simple as the links are completely processed in order, so the first one must go to the target and its fate determined before the second one is... released.
Now, array and transaction sizes can complicate error reporting and may affect how it works depending on the relationship between the two links. If the second link depends on seeing the result of the first link then you may need to drop one or both of the sizes down to 1 or at least ensure both links are sent to the same (single) target stage so their work is done in the same 'transaction'.
Now, array and transaction sizes can complicate error reporting and may affect how it works depending on the relationship between the two links. If the second link depends on seeing the result of the first link then you may need to drop one or both of the sizes down to 1 or at least ensure both links are sent to the same (single) target stage so their work is done in the same 'transaction'.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Without it, DSXchange would cease to exist.
Premium memberships are used to fund the hosting and bandwidth charges incurred by DSXchange. Notice the absence of ads? Notice the good signal to noise ratio?
Premium memberships are used to fund the hosting and bandwidth charges incurred by DSXchange. Notice the absence of ads? Notice the good signal to noise ratio?
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.
also check interprocess row buffering...that will dramatically impact the normal default "process each link thru completion" behavior.
Ernie
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Corporate discounts are available, but the model is for multiple individual memberships from that company's email domain. From memory the discounts kick in at five users.
But even without the discount it's less than 30c (Rs12) per day. A week on DSXchange costs less than a cup of coffee!
But even without the discount it's less than 30c (Rs12) per day. A week on DSXchange costs less than a cup of coffee!
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.