DS not showing job statistics after job runned successsfully

chrisjones · Post by **chrisjones** » Fri Oct 20, 2006 12:32 pm

Hi Friends,
DS is not showing job statistics after job runned successsfully.
Records are getting inserted into target tables but in job we are not getting any job information after job runned successfully..today early morning we are able to see but now the problem is coming...

Please let meknow what to do to get the job statistics

ArndW · Post by **ArndW** » Fri Oct 20, 2006 12:36 pm

The first question is where are you looking for the statistics and not seeing the results you expect? Designer, Director? Log files? dsjob call?

chrisjones · Post by **chrisjones** » Fri Oct 20, 2006 1:00 pm

ArndW wrote:The first question is where are you looking for the statistics and not seeing the results you expect? Designer, Director? Log files? dsjob call?

Thanks for ur reply,

In the datastage designer..i:e after job runned succussfully generally we will get the no of records inserted or rejected in green color..that we are not able to see...

kduke · Post by **kduke** » Fri Oct 20, 2006 1:11 pm

Right click on the palette and show performance statistics.

chrisjones · Post by **chrisjones** » Fri Oct 20, 2006 1:33 pm

kduke wrote:Right click on the palette and show performance statistics.

Yes ,we already did but we are not able to see..

kduke · Post by **kduke** » Fri Oct 20, 2006 2:06 pm

It does not show right after a compile.

ray.wurlod · Post by **ray.wurlod** » Fri Oct 20, 2006 2:16 pm

I note that this is a parallel job. Is the job monitor running? You won't get statistics at all unless it is.

samsuf2002 · Post by **samsuf2002** » Mon Oct 30, 2006 10:54 pm

is it because the data stage not installed correctly?

roy · Post by **roy** » Tue Oct 31, 2006 11:34 am

Hi,
As Ray noted if the monitor process is not running no info will be shown.
Is this a fresh install?, if so it might be lacking (missing) a patch install.
Otherwise if all is well you might need to jump-start it (contact your support, or wait till some one having current access to parallel engine get the exact command to run)

IHHTH,

lstsaur · Post by **lstsaur** » Tue Oct 31, 2006 12:02 pm

Chris,
You need to go your ../DataStage/PXEngine.751.1/java directory to re-start the jobmoninit, i.e. sh jobmoninit start $APT_ORCHHOME.
After jobmoninit started, then you will see the perfomance statistics.

Nageshsunkoji · Post by **Nageshsunkoji** » Tue Oct 31, 2006 2:51 pm

Hi Chris,
Just check the environmental variable called APT_JOB_MONITOR in the project level. If it is switch off position, you will not able to see the statictics.

chrisjones · Post by **chrisjones** » Tue Oct 31, 2006 4:30 pm

Thans for the information.

Yes after re-start the jobmoninitor we are able to see but we wonder why this happend suddenly with doing any changes..

IBM asked us to give some information on this when and in what suitation this happening but we are not getting this suitation now..but we are worried when this problem again may come after moving into production..

Please let us know generally when we will face this problem and why does this happen and in which suitation this problem comes.

lstsaur wrote:Chris,
You need to go your ../DataStage/PXEngine.751.1/java directory to re-start the jobmoninit, i.e. sh jobmoninit start $APT_ORCHHOME.
After jobmoninit started, then you will see the perfomance statistics.

lstsaur · Post by **lstsaur** » Tue Oct 31, 2006 5:04 pm

Chris,
This situation is caused by when the DS server is brought down for whatever reasons (e.g. updating the dsenv file), but during the re-start of the DS server, the jobmoninit did not start properly (due to one of the ports, 13401, 13402, is unavailable). This situation can also happen when the Unix box is re-booted.

Magesh_bala · Post by **Magesh_bala** » Mon Nov 27, 2006 9:55 pm

Hi,

After reseting jobmoninit also i am not getting the statistics, can u just give me some other solution