Table splitting for Export

[Former Member]

Hello All,

I am working on SAP R/3 4.7 System OS migration which also includes Unicode conversion. I am using R3ta for splitting the first 50 tables into 1GB each. Table splitting completed successfully and I have copied the WHR files into DATA directory. Later when started SAP export the tables which I have split are getting exported successfully. However I noticed that these tables are also included in the TABART (i.e.) SAPAPPL1 and SAPCLUST which is doubling the export time

Can you please let me know if I am missing anything? I can exclude the tables by making changing in the TSK files however I am wondering why this is not happening automatically. I am using SAP Installation master for R.3 4.7 which is released on 2008. The latest installation master for R/3 4.7 is supported only for Oracle 10 but our system is running with Oracle 9 hence I am running the table split and export with Installation master released on May 2008. Also with this installation master we do not have option of using parallel export and import. Can you please let me know how to get this option?

Regards,

Anand

[Former Member]

Hello Anand,

I am also going to perform unicode conversion of 4.7 system , and i have a Inst Master for the same.

When I go to system copy option for export i get two options

1) Standard Mode (R3load-based)

2) Export using Migration Monitor

In both the cases I DO NOT have an option to "start Migration Monitor" Manually.

Please see the attached screenshot.

a) Standard Mode

B) Migration Monitor Method

I have manually downloaded Mig Mom files from SAP Note: 784118 and extracted it under

/usr/sap/SID/SYS/MM/Migmon

I have copied the Inst Master in

/usr/sap/SID/SYS/MM/InstDir

I have created a orderBy.txt file for export of packages and also configured export_properties file.

But None of the method from SAPInst picks up the configured file.

Instead the Mig-mon runs from c:/program file/Instdir.

Will you please let me know how did you go about your export and which Installation Master did you use ?

If you have any list of steps please let me know , it will be a great help.

Regards,

Victor

[former_member709110]

You haven't detailed the steps what you have done. But it seems in your DATA directory ... your STR's has multiple entry for those tables. Though package split ensure that those 50 tables are split out a seperate packages (STR). You should ensure you have 50 seperate STR for each of the tables and double check i will do a random check on the SAPAPPL1 , SAPCLUST , etc. for few of the tables. Use Migration Monitor that way you will have more control.

Also Migration Monitor will address your parallel export and import issue.

Regards,

Neel

[Former Member]

Hello Neel,

Thanks for your reply and I have detailed the steps performed:

1. Have performed the table split with SAPINST

2. Copied the WHR files to the DATA directory

3. Starting export with migration monitor option (parallel export / import option is not available with this installation master)

4. Performed export with migration monitor

Did I miss anything here? Should I copy anything at installation directory level?

With the installation master I use Parallel export / import option is not available. Will updating the migration monitor tools will bring the option? When I check the TSK files of SAPAPPL1 for example I can see the entry for the table which I have splitted using the table splitter. This is exporting the table once again and thus doubling the downtime

Note: I have tried the latest installation master NW01 SR1 for Oracle 10/11 however table splitting itself is not working with the following error "FJS-00003 Reference Error: nRunningR3taCur is not defined". After running the old installation master released on may 2008 table splitting is running fine.

Please suggest

Regards,

Anand

[former_member189725]

If you want to split a table , the table should be placed into a separate package outside the standard SAP packages. The SAP package splitter (split.jar) ensures this. Select the option "Start migration monitor manually" in the SAPINST dialogue. The migration monitor properties file provide you the option for parallel export import.

Before you start migration monitor , I can suggest a check for you to find duplicate table entries in the STR files.

Make a test directory. With user <sid>adm , navigate to the directory and just run R3ldctl without any arguments.

Once it finishes it will generate STR files.Run the following :

1. cat *.STR | grep "tab:" |wc -l

This would give you the number of tables.

Then go to the directory /<EXP_DIR>/ABAP/DATA . Run the following

1. cat *.STR | grep "tab:" |wc -l

This would give you the number of tables in STR files after split.

If the 2 numbers match , your split is perfectly fine.

You can then go ahead and configure the migmon on both export and import servers and start the parallel export/import.

Please find the migmon guide which can be found by extracting the MIGMON.SAR file in the installation master dvd /<DVD_DIR>/<PRODUCT>_SAP_Installation_Master/IM_<OS>_<PLATFORM>/COMMON/INSTALL

[Former Member]

Hello Ratnajit,

Thanks for your help

After testing the steps specified I can find the difference in the number of tables. The difference is exactly the number of tables I have splitted and this confirms my doubt over the tables getting exported twice. Again I have listed the steps performed and can you please let me know if there are any mistakes

1. Performed the TABLE SPLITTING and the WHR files are generated in <ExportDirectory>/ABAP/DATA

2. Copied the WHR files from <ExportDirectory>/ABAP/DATA into <ExportDirectory>/DATA (as the installation tool is writting the export data here)

3. Started the DB export with migration monitor manually

4. Started Migration monitor (export_monitor_cmd.properties) from Installation directory

Please suggest if I miss anything

Regards,

Anand

[former_member709110]

Choose any one of the tables you have split ... run the following command in the DATA directory.

fgrep -i 'tab: <tablename>' *.STR

This should return 2 entries ... that will help you identify how you are introducing duplicate entries.

Hope this helps ...

Regards,

Neel

[former_member189725]

Your should do the following .

1. Generate WHR files

2. Copy WHR files to /<EXP_DIR>/ABAP/DATA ( this is where your STR,Dump,TOC,WHR files to be placed)

3. Start the sapinst and provide option "start migmon manually"

4. Edit the export_monitor_cmd.properties to the required values in the installation directory.

5. Start the export migmon (export_monitor.sh -bg)

[Former Member]

Hello Ratnajit,

Thanks for the reply

I have performed the following and still having same issue:

1. Generated WHR files which are copied into <EXPDIR>/ABAP/DATA

2. Running the Database export with <EXPDIR>/ABAP/DATA as the export directory and migration monitor manually option

Still can find the tables I splitted in STR files (i.e.) SAPAPPL0 / SAPAPPL1 / SAPCLUST. My understanding is when I split a table then these tables should not be included in the STR files (SAPAPPL0/SAPAAPL1/SAPCLUST) and thus the TSK file generated for that STR file will not include the table for export. With this the table will not be exported again. However in my case the tables are added again in STR for TABART

What could have gone wrong here? How should I overcome this situation? Can I ignore the table in TSK files and proceed with export? If I ignore the table and proceed with export will the import run fine?

Please suggest

Regards,

Anand

[former_member189725]

I think the splitter has some issues. Can you please check manully if the splitting works.

create test directories splitter, str ,output with <sid>adm

go to str directory .Run R3ldctl without options

go to splitter directory.

Run SAPCAR -xvf /<DVD_DIR>/<PRODUCT>_SAP_Installation_Master/IM_<OS>_<PLATFORM>/COMMON/INSTALL/SPLIT.SAR

create a file package_splitter_cmd.properties with following entries

strDirs=<path>/str

outputDir=<path>/output

top=50

set JAVA_HOME

run ./str_splitter.sh

check the output directory for split files

check str directory for files renames to .old

check number of tables in both sets of STR files .

If you find difference , splitter has problems.

If there is no difference , splitter is fine , installation dvd has problem or there has been a manual mistake.

[Former Member]

Hello Ratnajit,

I have managed to split the files and the packages. Now the packages do not include the tables which I have split separately and the export is running fine. This time I have copied all the files *.old, *.whr and few other files like package_splitter.txt into the <EXPDIR>/ABAP/DATA and it worked. I just tried to see if this helps and it worked

Now for importing should I create the package order file with SAPNTAB/SAPSDIC as the first packages to be installed or the import monitor will take care of the order. Since this is Unicode conversion SAPNTAB must be imported first.

Please suggest

Regards,

Anand

[former_member189725]

The migmon should ensure that SAPNTAB is imported first.

[Former Member]

Hello,

I tried but the SAPNTAB or SAPSDIC are not imported first. I have mentioned the value for pacakage order as size and checked

Any suggestions? Should I maintain the order file?

Regards,

Anand

[former_member189725]

You can go ahead with the order ..should not be an issue.

[Former Member]

Hello Ratnajit,

Thanks for your help

Import completed successfully

Regards,

Anand