Sir,
I have job with one source and one target with 3 links one for Insert and another for Update and another for Reject.
How can i get counts for all input links and output links means
source count,insert count,update count and reject counts along with job name,jobstaus and start and end times.
Thanks in advance.
Reddy
DataStage Audit counts
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Find the "active stage finishing" entry in the log - this contains all the link row counts. Otherwise use DSGetLinkInfo() function in the DataStage API in your own routine.
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: 232
- Joined: Fri Sep 30, 2005 4:52 am
- Contact:
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
You need to have a pre-process and post-process either at each job level that gives you the row count.
Or you can call the Pre and Post process jobs through your sequencer.
Suggested design
Master Control Sequence
|
Job1Seq(Pre - Job1 - Post)
Job2Seq(Pre - Job2 - Post)
Job3Seq(Pre - Job3 - Post)
.....
The Pre and Post are jobs that do the count by calling the APIs.
Job1, Job2 and Job3 are your main jobs to be run.
Job1Seq .. are the sequencers.
Or you can call the Pre and Post process jobs through your sequencer.
Suggested design
Master Control Sequence
|
Job1Seq(Pre - Job1 - Post)
Job2Seq(Pre - Job2 - Post)
Job3Seq(Pre - Job3 - Post)
.....
The Pre and Post are jobs that do the count by calling the APIs.
Job1, Job2 and Job3 are your main jobs to be run.
Job1Seq .. are the sequencers.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.