split tables for DMO

[#1]

I am preparing to use DMO to upgrade/convert  an Oracle/Unix based BW7.1 to Bw7.4 at Hana/SUSE.

Some tables are very big so that I plan to split them.

However, the DMO document does not show the step where the table-split can be configured.

Could you please share you experience on how to do this?

Thanks!!

[Former Member]

Hi Christina,

Please refer to SAP note below on information on table splitting on HANA

1783927 - Prerequisites for table splitting with target SAP HANA database

Also I came across and excellent blog for Migration on SAP HANA.

http://scn.sap.com/community/bw-hana/blog/2013/08/29/sap-bw-powered-by-sap-hana-some-points-to-remem...

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Deepak:

Thanks for your reply.

My problem is as follows:

I have done OS/DB migration many times including migrations to SAP hana. However the tool used is SWPM(sapinst) which has a STEP to let me specify the table-splitting.

DMO  does not have the same STEP to do that.

May I

1) run SWPM export before running DMO;

2) once I finish specifying the table-splitting and SWPM generated the *.whr files and the whr.txt file, exit from SWPM;

3) run DMO -- I am NOT sure if DMO will pick up the table-splitting info and split the big tables.

Please help.

Thanks!

[Former Member]

Hi Christina,

I have no idea on usage of table splitting with DMO. Suggestion here would be to raise an OSS message for the same.

Alternatively you can give it a try using DMO and look out for advanced migration option for optimization.

Regards,

Deepak Kori

[Reagan]

Hello Christina

I doubt whether the table splitting files generated by SWPM will be recognized by the DMO option of the SUM tool.

If you are using the DMO option of the SUM tool to migrate and upgrade the SAP system then I suggest you to read this article to understand how the DMO works.

http://scn.sap.com/community/it-management/alm/software-logistics/blog/2014/03/10/dmo-technical-proc...

According to the above article, once the shadow repository has been created and migrated to the HANA database (using R3load) the source is shutdown and the application data is exported from the source and imported to the target system using R3load simultaneously without creating an export dump.

There is a also a file mode option and for that you may read this article.

http://scn.sap.com/community/it-management/alm/software-logistics/blog/2014/03/20/dmo-comparing-pipe...

As I haven't used the DMO yet I would ask for clarification from on this.

Regards

RB