R3trans large table import - ways to speed up?

[AnilDandi]

Hi

Can anyone suggest ways to speed up the import of a large table (100+ GB) using R3trans?

DB is MS SQL Server.

Thanks

AKD

[divyanshu_srivastava3 · Accepted solution]

Hi Anil,

Are you looking for parallel options for import using control file ?

That is R3trans -w ?

Not sure if this would work that way.

The other option would be to multiple export using conditional select and import them in same way.

Regards,

[AnilDandi · Accepted solution]

Thanks Divyanshu.

Multiple export import should work. Unfortunately the export is already done. We have to deal with data exported using select *.

[Former Member]

Dear

you can import large table by increasing parallel process while importing

Regards

[Former Member]

Does it mean in Export and import ctl files if I mention parallel=4  R3trans will be in parallel export/Import mode.

Please suggest.

Thanks,

Subhash.G

[hemanth2]

Hi Anil,

Hope you are doing good.

You can use parallel processes for this. Please see note: 1127194 - R3trans import with parallel processes and note 1223360 Composite SAP Note: Performance optimization during import.

 
Thank you!
____________
Kind Regards,
Hemanth
SAP AGS

[AnilDandi]

Hi Hemanth,

How are you?

Unfortunately we have already spent too much time waiting for import and it is close to completion. We did not get a chance to test the parallel option out.

Would the options in SAP note 1127194 work  for import of a single table from a single select * export of data?

regards

[hemanth2]

Hi Anil,

Please check note 68896 - R3trans: Performance problems and cluster for some more options. Would it be a good idea to reorganize the table (perhaps using BRSPACE) first for a smoother transition?