Problem with the Job Monitor

r_arora · Post by **r_arora** » Tue Mar 11, 2008 3:52 pm

I have a parallel job which runs successfully..imports required no. of records (as shown in the job log) into the sequential file. But in the designer, it does not show any job statistics. Even though my job ran successfully I cant see the no. of rows passing through each stage. Job monitor also does not show the no. of rows exported to the target.
Can anyone help suggesting any possible solution to this problem.

Thanks

ShaneMuir · Post by **ShaneMuir** » Tue Mar 11, 2008 5:04 pm

Is there any message in the Director log? Perhaps something about Job AppMon not running?

lstsaur · Post by **lstsaur** » Tue Mar 11, 2008 6:05 pm

Open a command prompt; isssue netstat -an to see whethere ports 13400 and 13401 are listening.

r_arora · Post by **r_arora** » Wed Mar 12, 2008 8:17 am

I don't see any port 13400 or 13401 when I issue the netstat -an command

fc_user · Post by **fc_user** » Wed Mar 12, 2008 8:59 am

I looked for similar problem on this forum and I checked the value of APT_ORCHHOME variable and is properly set.
"APT_ORCHHOME=C:/IBM/InformationServer/Server/PXEngine"

I could not find any warning in my job log that says "Failed to dscover JobMon App" or any other warning related to the APT_ORCHHOME variable.

Please help suggesting as to why am I not able to see the job statistics.

srimitta · Post by **srimitta** » Wed Mar 12, 2008 9:11 am

Check APT_NO_JOBMON in environment variables under Reporting

This supposed to be False.

r_arora · Post by **r_arora** » Wed Mar 12, 2008 9:28 am

APT_NO_JOBMON is set to false and APT_RECORD_COUNTS is also set to True. I have explicitly included these variables in my job and set their values. Still I am unable to see the record counts in my job. It only shows 0 rows.

lstsaur · Post by **lstsaur** » Wed Mar 12, 2008 11:05 am

If you don't see that ports 13400 and 13401 are up and listening, that's why you wouldn't see perfomance statistics while running jobs.
Go to your Java directory of the ASBNode; issuse sh jobmoninit start $APT_ORCHHOME.

r_arora · Post by **r_arora** » Wed Mar 12, 2008 2:52 pm

After I executed sh jobmoninit command I tried running one of my simple jobs which just reads from a sequential file and writes to another sequential file, the job showed me the statistics. But when I used an Oracle stage, I did'nt see the statistics again. If i read from a sequential file or any other source I am able to see the statistics, but when I read from an Oracle stage it shows 0 rows, eventhough my job ran successfully and exported the records to the sequential file.

I also tried intorducing a peek stage instead of a sequential file, but still cant see the job statistics. Please help!

lstsaur · Post by **lstsaur** » Wed Mar 12, 2008 3:28 pm

Open the job using Oracle stage; check the Show performance statistis under the Diagram; compile the job. This time you should see the green light when job is run.

r_arora · Post by **r_arora** » Wed Mar 12, 2008 3:34 pm

I have checked the "Show Performance Statistics" in the job diagram but still can't see the job statistics.

kumar_s · Post by **kumar_s** » Wed Mar 12, 2008 4:50 pm

Doesn't it show in Director as well? With Monitor option?
Try to restart your job monitor. Do it from PXEngine.
,/jobmoninit start - to start
./jobmoninit stop - to stop.

ray.wurlod · Post by **ray.wurlod** » Wed Mar 12, 2008 5:46 pm

r_arora wrote:APT_NO_JOBMON is set to false and APT_RECORD_COUNTS is also set to True. I have explicitly included these variables in my job and set their values. Still I am unable to see the record counts in my job. It only shows 0 rows.

Are there record count entries in the job log? That should be the effect of the APT_RECORD_COUNTS environment variable.

fc_user · Post by **fc_user** » Thu Mar 13, 2008 10:24 am

yes I can see the record count in my job log. I don't see the record count in the job monitor or the designer("Show Performance Statistics")

ray.wurlod · Post by **ray.wurlod** » Thu Mar 13, 2008 5:13 pm

Is this just from your client machine or from others' as well.

I wouldn't worry too much - displaying row counts in Designer is purely cosmetic and just a convenience - the rows are clearly being processed satisfactorily.