cancel
Showing results for 
Search instead for 
Did you mean: 

How to Speed the Data retrival process ?

Former Member
0 Kudos

All,

Does anyone know, If a user is performing a BTC job which is reading millions of records (say 40-70 million records), can we increase some parameter on the R/3 side which would help with this Job to speed the process?

Thanks In Advance!

Kumar

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

If a user is performing the BTC job which is taking too long time then you need to perform troubleshooting with SAP performance and health check tcodes.

1. There may insufficient BGD processes in the system and hence your user is waiting for long time to execute hence look at tcode SM37 to see status of the job.

2. See what amount of data is being pulled from the system through tcode STAD/ST03(N)

3. Check SE30 with the tcode/report code and perform and evaluation which displays the graph

4. Run tcode ST04 to perform trace.

Once you are done with these steps you will get to know the exact problem why the load time is long.

Solutions

1. May be you need to use operation modes to increase the number of BGD process if they are the root cause

The demands of users on the SAP system vary during the course of the day.

During the day, a large number of dialog users, who want to be served with high

performance by the system, are working. Therefore, a large number of dialog

work processes should be available for users during the day. During the night,

however, only a small number of these dialog work processes are used, and the

system can be used to a larger extent to process background jobs.

For operation modes tcode RZ04 is used to create empty containers

2. The problem of data load may be due to ABAP code with many loop statements and hence loops need to reduced and indexes may be added.

Also check parameter rdisp/btctime and rdisp/wp_no_btc

SAP Note 24092: Distribution of background jobs on application server

Rakesh

Former Member
0 Kudos

Hi,

From my knowledge you can do shrinking in the database side