Hello, I have report which usually runs for 10 mins but sometimes it takes over very long time to run. I have confirmed the paramters used are the same.
I noticed under the 'Agents' for column FOCUS/External IO it shows 0/0 and under the CPU Time it shows 0:02:28:578 and it is not changing the time.

How can I confirm if the report is still being processed?
What does it mean when FOCUS/External IO shows 0/0?

This message has been edited. Last edited by: kpiracha,

I could be wrong, but I've come to understand that the FOCUS/External IO is what is actually being done in the FOCUS engine. On my iSeries, I usually look to the DBMS/IO column to see what the record count of what is being processed. If the FOCUS column is 0/0, it's not a BAD thing, just means your records are passing through that part of the stack.

Are you running on a Windows server? Does that have any job listing you can look at?

Keep in mind that if the request is from an RDBMS, then WebFOCUS may be waiting for it to start returning data.

Thanks for the quick response. We are actually using Iseries as well and connect to JDE database. I don't have access to look at the Iseries side of data though.

Our webfocus is on Win2003. I didn't under the question 'Does that have any job listing you can look at?'.

Is there any tool we can use to figure out what exactly being done with the report at one perticular time, for eg, processing data, waiting for response etc etc.

You may have to talk to IBI about this.

Another option, testing only, would be tracing. This would log what is happening, but if there is large amounts of data, the logs could be quite large.

Ok. I will talk to IBI.

quote:

Originally posted by kpiracha:
Thanks for the quick response. We are actually using Iseries as well and connect to JDE database. I don't have access to look at the Iseries side of data though.

Our webfocus is on Win2003. I didn't under the question 'Does that have any job listing you can look at?'.

Option 1
In iSeries, get to a green screen and go to a command line. Type 'wrkactjob' and sort the list by processing %. If you are running the job at the time, you should see a TSCOM job near the top which is what WF kicks off to run your request. Use option 5 to work with the job and display the job log. If the job log tells you something like "xxxxxx used for SQL processing" copy that job number and get back to your command line. (continued in Option 2)

Option 2
Get the job number for your request. You can either get it from the Agents list on the webconsole or through wrkactjob on the green screen.
Type wrkjob 9999999/jobname/userid where 9999999 is your job number, jobname is TSCOM3 and userid is the userid that submitted your job.
When the job info screen comes up either use option 10 for the job log or option 14 to see a list of open files. If you use 14, you can press PF11 to view the DBMS i/o and make sure everyhting is processing and what your response time is.

Option 3
Do you have iNavigator in your shop? If so, use it to connect to your server, and under the "DATABASES" drop-down select your connection and navigate to the "JOBS" area. You can right-click the JOBS icon and include your specific job number that is running your request. There are a myriad of things you can do here. For a bit of training on that, click this link:
click here

awesome....thank you so so much.