Usage of splitter (OssNote 1043380) with Sapinst 620/640

[Former Member]

Dears,

I'm trying to export a big Oracle dabatase throught Sapinst, in order to perform a Unicode conversion.

It's a R/3 47 Ent ext 200 system, with kernel 640_REL, based on Was 620.

So I'm using the NUC Installation Master 620/640, (Edition May 2008), Number 51033746.

This Sapinst under the branch SystemCopy-> SourceSystem has only two items:

-Table Splitting preparation

- DB Export

I need to split the biggest tables, but I experimented the first item is very very slow (I'm not able to see it finished), as it try  to perform a :

"SELECT COUNT(DISTINCT MANDT) FROM..." for the tables I want to split.

So I try to use the splitter script by note 1043380; I know it and I already used successfully in the past with latest Sapinst 700 .

Unfortunately the Sapinst I'm using is different and it's not so easy to integrate the WHR files produced by the splitter.

Even if you copy them under the /DATA directory the R3load does not take them in consideration duting the database export phase.

Any suggestion?

[Former Member · Accepted solution]

Hi Roberto,

Table splitting makes use of migmon. In this release MIGMON ain't fully integrated with SAPinst (like in case of 7.00). You need to start migmon for both export and import manually for table splitting to work.

Regards.

Ruchit.

[Former Member · Accepted solution]

Thanks for the feedback.

For the moment I  went back to the R3ta splitter integrated into the Sapinst.

As the Sapinst 620 propose the Item "Table Splitting Preparation" I expect it is supposed to work.

I managed the R3ta_hints.txt file in the proper way, (a lot of tables I want to split were missing) and now the WHR clauses are generated in a reasonable time.

I run the DB Export, moving the .WHR files and the whr.txt under the proper DATA directory.

I selected "customer order" , as I want to start the export with VBAP-1, VBAP-2 ... and so on , the splitted tables for which the R3ta generated the WHR files.

But I discovered this Sapisnt does not generate the 'order_by.txt' file, where you can adjust the export order, placing at the top the splitted tables VBAP-1, VBAP-2....but appears only a table containing a row for any STR package and you have to change the order changing the default number 0.

I do not know in which way insert in this table my packages VBAP-1, VBAP-2 and so on.

The table is a list of .STR files, but for my VBAP table there is only the VBAP.STR file for example.

If I put -1 for this table it's exported as first, but from one R3load process only.

It does not take anyway in consideration my WHR files.

Do I have to generate some file manually ? I supposed using the "Table Splitting Preparation" step to create all the things needed for the DB export step.

I miss something or I'm doing something wrong ?

regards

[Former Member · Accepted solution]

The intergration of the WHR files was solved using Migmon.

Anyway also using the table splitting the export performances on the CDCLS table are very very bad...