Hi...
I observed this peculiar behaviour in one of my jobs...
I have a DB2 stage in which row leakage is happening. To capture this, I have used a COPY stage and enabled RCP so as to catch the sqlcode and sqlstate of the rows being rejected. The o/p of copy stage is a sequential file. Everything works fine (i.e., the sequential file gets loaded with the reject rows, etc. ), but the link count on the link from copy stage to sequential file shows as 0 rows/sec.
Replaced the copy stage with a MODIFY stage (disable RCP at prj level) and the link count is still 0 rows/sec though the sequential file gets loaded again.
When these 2 columns sqlcode and sqlstate are not being used, the link count on this link is perfect.
Can anybody let me know why is this happening?
Thanks for the replies
Link Count shows as 0rows/sec when RCP is enabled
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Seconds are rounded to the nearest whole number. 0 rows/sec can occur because the run tool less than 0.5 seconds; this is manifesting a strategy of avoidance of a divide by zero error.
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.
Re: Link Count shows as 0rows/sec when RCP is enabled
Think it has to do with RCP. In my RCP jobs,at stages where you do not have any metadata defined ,I've observed you can get 0 rows/sec (or in the monitor stage you get a Black box as opposed to Green).Aparna_A wrote:Hi...
I observed this peculiar behaviour in one of my jobs...
I have a DB2 stage in which row leakage is happening. To capture this, I have used a COPY stage and enabled RCP so as to catch the sqlcode and sqlstate of the rows being rejected. The o/p of copy stage is a sequential file. Everything works fine (i.e., the sequential file gets loaded with the reject rows, etc. ), but the link count on the link from copy stage to sequential file shows as 0 rows/sec.
Replaced the copy stage with a MODIFY stage (disable RCP at prj level) and the link count is still 0 rows/sec though the sequential file gets loaded again.
When these 2 columns sqlcode and sqlstate are not being used, the link count on this link is perfect.
Can anybody let me know why is this happening?
Thanks for the replies
Why not try building another simple RCP job and check whether you get row counts from it.
Chin