Page 1 of 1

dsjob linkinfo

Posted: Tue Mar 25, 2008 3:58 pm
by kavuri
Hi,
I am working to find the linkrow count for this I am using the following command. I am able to fetch the rowcount on one server and unable to do the same on the other server. I am not getting any error but it is resulting 0 rows. I checked the file, it is populated with some data in it.

This is the command I am using.

dsjob -linkinfo PROJECTNAME JOBNAME Copy_of_periodstxt DSLink380

Result:

Link Row Count : 0
Link Last Error : <none>
Link DBMS Code : not available
SQL State : not available
Link Name : DSLink380


Are there any settings need to be done on the server or client?

Thanks
Kavuri

Posted: Tue Mar 25, 2008 9:28 pm
by kumar_s
Is Jobmonitor running? Do you see the Row statics in job when you select "Show Performance statics"?

Posted: Tue Mar 25, 2008 11:28 pm
by ray.wurlod
Maybe the file was populated on a previous run?

Do you get a row count with

Code: Select all

dsjob stageinfo InStore InstoreTraffic_11_27TA Copy_of_periodstxt 

Posted: Wed Mar 26, 2008 7:07 am
by kavuri
Hi,
We resolved it.

This issue is resolved now. The problem was , in DataStage Administrator -> Projects -> Properties --> Environment - > Paralel - > Reporting ,:
set the variable APT_RECORD_COUNTS to 'True'.


Thanks
Kavuri