RowCount from the DSGetLinkInfo always return zero

grace · Post by **grace** » Fri Sep 08, 2006 8:34 am

Can you please explain how to turn on the monitor?

meena · Post by **meena** » Fri Sep 08, 2006 8:40 am

Hi,
Go to DS Director, right click on your job and select "monitor" option.

Can you please explain how to turn on the monitor?

kumar_s · Post by **kumar_s** » Fri Sep 08, 2006 8:45 am

This is to Monitor your row count. To turn it on, you have the variables in Datastage Admisntrator client.
Something like, DISABLE_JOBMON under monitor. Set it to true. Some other relevent parameters are APT_MONITOR_TIME and APT_MONITOR_SIZE.

grace · Post by **grace** » Fri Sep 08, 2006 2:02 pm

Thank you very much for all your responses, that was very helpful.
I did notice that we have a "Failed to connect JobMonApp on port" error, and after I restart the JobMonApp, I am able to retrieve the rowcount being passed down to the link, so this solved one of the mysteries.

But now back to my another question, does anyone know how to get the rowcount that actually be inserted/updated/deleted in an oracle table, not the rowcount being passed down?

kduke · Post by **kduke** » Fri Sep 08, 2006 3:02 pm

Row counts are based on link names only. If you use update and then insert then there is no way to call an API to get this count. I do not think there is a way ask Oracle how many updated versus inserted either.

kumar_s · Post by **kumar_s** » Fri Sep 08, 2006 11:50 pm

As Kim mentioned, if you use seperate link for each Insert/update/delete you can count using the link count. Else if you have any lookup feature, maintain a internal counter using any stage variable.