Link row count

[aschindler]

Hi,

I have total ten datastage parallel jobs and i need to capture each job src extraction count and target loading count and load it into audit table.
And the audit table looks like
jobname link_name source_count target_count

Assume that src and tgt link names are same for all jobs.

I have heard about Dslinkgetinfo(),but not sure in parallel jobs.

Please suggest the job design to achieve above functionality.

Quick help would be highly appreciated.

[ray.wurlod]

Welcome aboard.

DSGetLinkInfo() works with all job types.

However, it can also return per-node information in parallel jobs.

Others have already solved your problem. For example download ETLstats from Kim Duke's website for example.

[vmcburney]

In version 8.7 and 9.1 you have this functionality out of the box using the Operations Console and its supporting open database. There are tables for job runs and link counts that are collected and loaded from DataStage job reports by utilities bundled and installed with the software.

[aschindler]

Hi,

I'm using a server routine to get the count,below is the code.

$include DSINCLUDE JOBCONTROL.H

JOBHANDLE=DSAttachJob(JOBNAME,DSJ.ERRFATAL)
Ans:=DSGetLinkInfo(JOBNAME,STAGENAME,LINKNAME,DSJ.LINKROWCOUNT)

But i'm getting count always -1 ,though i could see the count passing through the link.

Please let me know if anything wrong.

P.S: Im using this routine to get the row count of a parallel job

[chulett]

DSGetLinkInfo needs JOBHANDLE, not JOBNAME.

[aschindler]

Thanks,

Now its working