dsjob linkinfo

kavuri · Post by **kavuri** » Tue Mar 25, 2008 3:58 pm

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

kumar_s · Post by **kumar_s** » Tue Mar 25, 2008 9:28 pm

Is Jobmonitor running? Do you see the Row statics in job when you select "Show Performance statics"?

ray.wurlod · Post by **ray.wurlod** » Tue Mar 25, 2008 11:28 pm

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

kavuri · Post by **kavuri** » Wed Mar 26, 2008 7:07 am

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