cancel
Showing results for 
Search instead for 
Did you mean: 

Background job performance issue

Former Member
0 Kudos

Dear Team,

Am facing some performance issue in SCM/APO system. Previously all jobs are finished with in 200 to 500 sec , since last few days, all these jobs are running for long time(5000 to 7000sec) and finished successfully.But user are complaining about these jobs. I didn't find any logs,other than job logs in sm37.

If anyone has come across the same issue, please provide your inputs on this.

system looks fine...but still jobs are taking long time to finish.

Thanks in advance.

Regards,

Venkat

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Please check whether any DB activity has been carried out for the tables you are facing the issues. What is the size of the table that is taking long time. You can get a help of ABAPer to see the tables that are used.

You can try the following.

1. Run oracle update stats and make sure that your oracle is up to date.

2. create indexes for the tables that are running for long time

3. Try to update the kernel to latest level . If you are using 701 kernel, you can upgrade to 720 and check.

Please check and provide your feedback.

Thanks and Regards

Vimal

Former Member
0 Kudos

I have already checked those things. Here my DB is DB2....

former_member188883
Active Contributor
0 Kudos

Hi Venkata,

Could you specify the job details for more clarity. Also explain us the what is this job used for ?

Regards,

Deepak Kori