Page 1 of 1
DS not showing job statistics after job runned successsfully
Posted: Fri Oct 20, 2006 12:32 pm
by chrisjones
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
Posted: Fri Oct 20, 2006 12:36 pm
by ArndW
The first question is where are you looking for the statistics and not seeing the results you expect? Designer, Director? Log files? dsjob call?
DS not showing job statistics after job runned successsfully
Posted: Fri Oct 20, 2006 1:00 pm
by chrisjones
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...
Posted: Fri Oct 20, 2006 1:11 pm
by kduke
Right click on the palette and show performance statistics.
DS not showing job statistics after job runned successsfully
Posted: Fri Oct 20, 2006 1:33 pm
by chrisjones
kduke wrote:Right click on the palette and show performance statistics.
Yes ,we already did but we are not able to see..
Posted: Fri Oct 20, 2006 2:06 pm
by kduke
It does not show right after a compile.
Posted: Fri Oct 20, 2006 2:16 pm
by ray.wurlod
I note that this is a parallel job. Is the job monitor running? You won't get statistics at all unless it is.
Posted: Mon Oct 30, 2006 10:54 pm
by samsuf2002
is it because the data stage not installed correctly?
Posted: Tue Oct 31, 2006 11:34 am
by roy
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,
Posted: Tue Oct 31, 2006 12:02 pm
by lstsaur
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.
Posted: Tue Oct 31, 2006 2:51 pm
by Nageshsunkoji
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.
DS not showing job statistics after job runned successsfully
Posted: Tue Oct 31, 2006 4:30 pm
by chrisjones
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.
Posted: Tue Oct 31, 2006 5:04 pm
by lstsaur
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.
Posted: Mon Nov 27, 2006 9:55 pm
by Magesh_bala
Hi,
After reseting jobmoninit also i am not getting the statistics, can u just give me some other solution
