DSXchange

Hi all,

Normally when you run a job (on the designer) the links changes their colours between black, blue, green, red. We have one job that during and after the execution the links are allways black. The job finish successfully and the records gets the target stage.

Do you know how to see the links colours and the statistics?

We enable the Show performance statictics job option without success.

Thanks in advance.

Multi-instance ?

Have you disabled display of "performance statistics"?

Yes it's still active, but the colors and the number of rows are not displayed. However te job seems to work fine.


We just have to know what is causing this behaviour, because from time to time it's happening.


Thanks a lot for your help

can you see the stats in job monitor?
if no
Do you have any warning in the log?
any message handler active?

Maybe your job monitor is not running.

What exactly are the stage types at either end, and/or other characteristics....is there a container involved, etc.. I've seen this sort of thing lots of times. Does the Job work as designed?

The performance stats are just a "convenience aid". Personally, they annoy me, especially since in v8 they seem to always get "turned back on again" after I uncheck them. ; ) Once they are on, you can't easily re-name the links, etc. until you turn them back off. And if it's red, you have to go back to the Director anyway (old habits die hard).

My humble opinions aside, what is the structure of the job...that may offer us some hints.

Ernie

Hi,

the stage types are:

Dataset ------> Remove Duplicates ---------> Oracle (Green link)


Dataset ------------------------------------------> Oracle (Black link)

No containers involved. The job works as expected. But no statistics are shown por the Dataset to Oracle link.

Hi,

I forgot to clarify that it's not a multiple instance job.

regards.

What if you put a copy and force it ?

Are those separate paths in the same job? That may explain it. As noted above, I've seen Containers and other "not-so-standard" Job constructs result in behavior where some links fail to show any performance results or color status. This may be one of those situations.

If in fact they are separate paths, what happens if you put it in its own job...and also, what happens if there is something, like a Copy as noted before, or a Transformer, between the two I/O stages.

Ernie

What about my questions?

add one more question to that.

What is the value set for APT_NO_JOB_MON?

APT_NO_JOB_MON = False

Hi,

Following eostic workaround to add a copy stage between the dataset and the oracle stages now the link becomes green.

I think remember that when datastage compiles a copy stage that is just mapping all the fields on the compiled code is like this copy stage doesn't exist. In case I'm right. Why the link is not working without the copy stage?

Thanks!!!

Dump the score, inspect it, and answer your own question. Please post the results of your investigations here.