DataStage Audit counts

reddy · Post by **reddy** » Mon May 01, 2006 1:49 pm

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

ray.wurlod · Post by **ray.wurlod** » Mon May 01, 2006 2:35 pm

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.

kduke · Post by **kduke** » Mon May 01, 2006 5:04 pm

Download EtlStats from my tips page.

sb_akarmarkar · Post by **sb_akarmarkar** » Tue May 02, 2006 1:28 am

Use DSGetJobInfo() also....

Thanks,
Anupam

Sreenivasulu · Post by **Sreenivasulu** » Tue May 02, 2006 1:33 am

Hi reddy,

If you have Asential Meta Stage you can use it to get detailed information about the count, records,jobname etc...

Regards
Sreeni

reddy · Post by **reddy** » Tue May 02, 2006 7:57 am

Sir,

Suppose if i use DSGETJOBINFO() in the jobcontrol of a jobs and i am using jobsequencer how can i get link counts for all jobs.

Thanks
Reddy

DSguru2B · Post by **DSguru2B** » Tue May 02, 2006 8:02 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.

reddy · Post by **reddy** » Tue May 02, 2006 12:07 pm

Excellent Thanks a lot guys.