Data migration thru BDC

[Former Member]

Hello experts,

Here we are trying to migrate the master data using BDC but the problem what we are facing is that the mgiration rate becomes very less after few hours of starting the program. When we restart the server again the transfer rate is high but reduces after few hours of its run.

could anyone give some suggestions to increase the migration rate ?

Is there any procedure to be adopted at BASIS level before starting/or during the BDC program run, as we can see using SM50 that the program gets stuck at certain tables during the run.

Could somebody please suggest what are the various possibilities available in refreshing the databases statistics using the TCODE DB20 or by the program RSANAORA and how it would help to increase the transfer rate of the BDC program.

With Regards

Balaji.J

[abdul_hakim]

Hi,

Check the following Criteria!

1. Volume of data that you are uploading(If the data volume is huge then it may cause performance problem, in such case you need to split your input files with less no of records)

If you dont have huge volume of records in your upload file then check the following.

1. No of Background Work Process Available(Incase if you are uploading in Background)

2. No of Dialog Work Process Available(Incase of Foreground)

3. No of available Update Work Process(V1/V2)

Cheers,

Hakim

[Former Member]

Dear Abdul,

Even though we have a huge volume of data we have split the record into 500 each. we are having 6 daialog process and four users currently working. we are using oracle 10 G with ECC6.0 and windows 2003 server.

we checked with sm50 and we found that the process gets stuck mainly in two tables which are sequentially read.

kindly let us know whether any way is there to refresh the tables to regain its data transfer speed or the process of creating tables statics for these tables.

We aslo think it is not picking the right index. what is the process for making it to pick the right index.

with regards

Balaji.J

[abdul_hakim]

Hi

What are the tables that you are reading in? Paste ur source code here so that we can see and suggest you some solution.

Cheers,

Hakim