From: RTR on
New to the group so go easy on me : )

I am trying to determine the best way to get the current SQL for a
job. I have tried using the API QUSRJOBI with format JOBI0900 and I
have also tried using the tool in iSeries Navigator titled "Current
SQL for a job" but after several reviews of the data that I get back,
it appears that the API is returning me the last completed SQL for a
job and not necessarily the current SQL statement that is being
processed.

I have a couple of jobs that are taking a life of their own and I
haven't been able to pinpoint what they are trying to do. They will
consume a large % of CPU for about 10 to 15 minutes. I have started
database monitors and have had the problem happen while the monitors
are running, but when I review the data collected nothing points to 15
minute query being processed.

Is there any way to dump the job information to find out EXACTLY what
is being processed at that time?

Also and FYI: This is a java application that can run probably 1,000
different types of statements. I am having this particular problem at
only 1 client site that I know of out of about 75 different clients
all running on the System i. IBM has assured us that PTF levels are
fine.

Thanks in advance. Your help is greatly appreciated.