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.
Link row count
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 30
- Joined: Wed May 15, 2013 1:22 am
- Location: Bangalore
Link row count
Cheers,
Schindler
Schindler
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
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: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
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.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Participant
- Posts: 30
- Joined: Wed May 15, 2013 1:22 am
- Location: Bangalore
Link row count mismatch
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
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
Cheers,
Schindler
Schindler
-
- Participant
- Posts: 30
- Joined: Wed May 15, 2013 1:22 am
- Location: Bangalore