Inaccurate Record counts on links

deepa_shenoy · Post by **deepa_shenoy** » Fri Mar 19, 2010 10:08 pm

Hi,

How do I get the ACCURATE record counts of links in a job?

I am using the following command

DSGetLinkInfo (handleJob, StgNmTrimed, LinkNmTrimed, DSJ.LINKROWCOUNT) in my basic routine.

I would like to know if the same command can be applied for jobs which are multiinstanced.

This is not working properly. In the first run it shows 9198 records, in the second run it shoes 0 records despite the count being 9198.

When run manually, it shows 9198 records.

When the job is called from a sequence, it shows 0 records.

Thanks in advance.

Deepa

ray.wurlod · Post by **ray.wurlod** » Sat Mar 20, 2010 1:18 am

Does invocation from the sequence disable use of the job monitor or disable collection of operational metadata?

deepa_shenoy · Post by **deepa_shenoy** » Sat Mar 20, 2010 3:06 am

No it does not do that.

chulett · Post by **chulett** » Sat Mar 20, 2010 7:26 am

When you attach to the multi-instance job, are you specifying the invocation id and a dot along with the job name?

handleJob = DSAttachJob(JobName.InvID, DSJ.ERRFATAL)

deepa_shenoy · Post by **deepa_shenoy** » Mon Mar 22, 2010 9:57 am

Yes we are specifying the invocation id and a dot along with the job name.

Sairam · Post by **Sairam** » Mon Mar 22, 2010 10:15 am

If calling in a independent routine
handleJob = DSAttachJob(JobName, DSJ.ERRFATAL)
InvocationID=DSGetJobInfo (handleJob, DSJ.JOBINVOCATIONID )
CurrentJob = JobName:".":InvocationID
StageName="xxxxx"
LinkName="lnk_xxxxx"
InfoType=DSJ.LINKROWCOUNT
Rec_Cnt = DSGetLinkInfo( CurrentJob , StageName, LinkName, InfoType )
Call DSLogInfo ("Rec_Cnt DS : ":Rec_Cnt , ROUTINE_NAME)

chulett · Post by **chulett** » Mon Mar 22, 2010 8:28 pm

I don't know how well that function works in a PX job, my direct experience is all in Server where the 'stage' you interrogate is always an active stage, thus typically a Transformer, or things may not go well. Not sure how that all works out in PX, what stage are you pointing it at?

deepa_shenoy · Post by **deepa_shenoy** » Tue Mar 23, 2010 12:10 am

It is working fine except when the first stage is a Dataset. It keeps giving incorrect record count.

chulett · Post by **chulett** » Tue Mar 23, 2010 6:23 am

OK... have you reported this to your official support provider?

kduke · Post by **kduke** » Tue Mar 23, 2010 4:12 pm

There is a bug where modify stages disable the counts. So they all go to 0. Sometimes from that point on in the job. The JobName above needs to be the job_name.instance_name or it will not count what you think it should.

ray.wurlod · Post by **ray.wurlod** » Tue Mar 23, 2010 4:17 pm

That's not a bug, and it can happen with Copy stage also. There's no count because the stage is optimized out of the design. Inspecting the score can verify that this has happened.

ray.wurlod · Post by **ray.wurlod** » Tue Mar 23, 2010 4:18 pm

deepa_shenoy wrote:It is working fine except when the first stage is a Dataset. It keeps giving incorrect record count.

What record count do you get when using the dsrecords command with the Data Set?