Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Split a large table into multiple packages - R3load/MIGMON

Hello,

We are in the process of reducing the export and import downtime for the UNICODE migration/Conversion.

In this process, we have identified couple of large tables which were taking long time to export and import by a single R3load process.

Step 1:> We ran the System Copy --> Export Preparation

Step 2:> System Copy --> Table Splitting Preparation

We have created a file with the large tables which are required to split into multiple packages and where able to create a total of 3 WHR files for the following table under DATA directory of main EXPORT directory.

SplitTables.txt (Name of the file used in the SAPINST)

CATF%2

E071%2

Which means, we would like each of the above large tables to be exported using 2 R3load processes.

Step 3:> System Copy --> Database and Central Instance Export

During the SAPInst process at Split STR files screen , we have selected the option 'Split Predefined Tables' and select the file which has predefined tables.

Filename: SplitTable.txt

CATF

E071

When we started the export process, we haven't seen the above tables been processed by mutiple R3load processes.

They were exported by a Single R3load processes.

In the order_by.txt file, we have found the following entries...

-


order_by.txt----


# generated by SAPinst at: Sat Feb 24 08:33:39 GMT-0700 (Mountain

Standard Time) 2007

  1. default package order: by name

CATF

D010TAB

DD03L

DOKCLU

E071

GLOSSARY

REPOSRC

SAP0000

SAPAPPL0_1

SAPAPPL0_2

...........

...........

-


We have selected a total of 20 parallel jobs.

Here my questions are:

a> what are we doing wrong here?

b> Is there a different way to specify/define a large table into multiple packages, so that they get exported by multiple R3load processes?

I really appreciate your response.

Thank you,

Nikee

Former Member
Not what you were looking for? View more on this topic or Ask a question