Wednesday, June 22, 2011

How to find job name from process ID (BI System Slow Analysis)

We used this scenario in term of BI system being slow :

Analysis steps :

1) Go to DB01 and find if there are any exclusive locks i.e. in HOLD _WAIT status

2) If yes find out the process ID and application server name of the locks in HOLD status.

3) Log on to the application server on which the process in Hold status is found and goto SM66

4) Find out the process ID against BTC and double click

5) Click on Job Information, it will give you the job name, you may find this on another application server as well but you need to enable below settings :

"For background processes, additional information is available for the background job that is currently running. You can only display this information, if you are logged onto the instance where the job is running, or if you choose Settings and deselect Display only abbreviated information, avoid RFC. In any case, the job must still be running".

For more information on this please goto below link:


http://help.sap.com/saphelp_nw70/helpdata/en/c4/3a6a6a505211d189550000e829fbbd/content.htm

6) Once you have found the job, you may give it to BI guys to relate the same to the Process Chain and kill the job / cancel the process chain.

No comments: