From a input fixed width Sequential file we are loading to DB2 table where all mapping columns to DB2 table are Key columns with Char format. Job designed as
Seqfile → Tfm→ Link Partioner(3 links)→Tfm→ Db2 table
and in Tfm it is direct mapping no transformation.
Round robin algorithm in Link partioner is used and with no Partioning key. The job gives mismatch in linkcounts statistics into and out from first Tfm stage while writing to Link Partioner stage ( with negative row counts), finishes with Duplicates warning which is not true with data. The round robin is not happening properly. same observation is not seen if we use a dummy sequential file in between tfm and LnkPtrn with same source and target.
thanks
Link Partioner Round Robin not happening
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Do you see the same problem with any of the other partitioning algorithms? This is a very surprising finding - Round Robin is about as simple as you can get! Can you please post the actual row counts from the output links of the Link Partitioner stage? And verify that you have row buffering enabled, with what settings.
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.
Row count for input to tfm is 2368 and out from tfm into link partn is
-12676 and job finishes with duplicates, only 1328 records are loaded to target db2 tables.
Again if I remove the Link Partioner and directly load then it loads all 2368 records .. that is no issue with the source data..
using Lnk Partn and then loading via Tfm here to improve the performance .. that it writes to target table fast by 3 instances at a time which worked fine in many other jobs
I could not understand why it is giving negative row counts....
Thanks
-12676 and job finishes with duplicates, only 1328 records are loaded to target db2 tables.
Again if I remove the Link Partioner and directly load then it loads all 2368 records .. that is no issue with the source data..
using Lnk Partn and then loading via Tfm here to improve the performance .. that it writes to target table fast by 3 instances at a time which worked fine in many other jobs
I could not understand why it is giving negative row counts....
Thanks
Shiva
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Sounds like a bug. Unsigned integers are sometimes reported as negative numbers, but never in the range about which you are talking. What did your support provider suggest?
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: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: