Batch job performance.

[Former Member]

Hi

I have a batch job scheduled on the production system, which takes very loong time to complete. Its a Z program running behind. Name of the job is MM_PPALL_W_W_SET_DELCOMP_FINV. I have no clue where to check and which is the associated program and where is the dent on performance??

Any help will be appreciated.

Thanks

Subbu.

[Former Member · Accepted solution]

Hi Subbiah,

If its a custom program, your should talk to the programmer who wrote the program by finding out what is the program running behing the job.

Aslo, if you want to find out on your own, you can try to run the SQL trace on it using ST05 and then analyze the trace for the expensive statements. Check the trace wherevere it shows the fetch time marked in RED and then, you can try to analyze the SQL statement running in the backgroung, to see if the programmer is doing an unnecessary select/fetch, reading too many records etc.

Hope that helps..

Thanks

Abhi

[Former Member · Accepted solution]

Thanks Abhi I did the same on Z program. It had lot of Fetech and select entries and also, I did process check analysis in SE30, the background process took lot of time in DB.

Thanks.

[markus_doehr2]

You can try the following:

- SM50

- doubleclick on the job

- copy the full name into the cliboard

- SE38

- enter the name of the program

- display version and the developer

contact the developer of that program and ask what he's doing there.

--

Markus