A question about R3ta_hint.txt in table splitting

[jack_chen4]

HI, all

I am doing a system copy of NW7.4SR2. According to the system copy guide,

“With the file R3ta_hints.txt, you can instruct R3ta to use specific columns of a table to create a WHERE condition.”

But after step "Table splitting prepare" in SWPM, I found no .WHR file in the export directory or installation directory. I am wondering whether the R3ta_hints.txt works or not.

Thank you

Jack

[former_member283199]

Hello Jack,

two different files for different purposes but working with each other:

If you decide to make your export faster by splitting the largest or complexest tables so that more than one R3load job can export a table, you have to give sapinst a file called "R3ta.txt". In that file you have to provide the result a list of tables that you want to split, e.g.

(Content of file "R3ta.txt" in exact following syntax)

ARFCSDATA%5          -> splits table ARFCSDATA in 5 parts

BALDAT%10               -> splits table BALDAT in 10 parts

Next step, if you don't want to spent hours in letting R3ta find out the "DISTINCT" value of above tables that should be splitted, you prepare a file called "R3ta_hints.txt" where you give already analyzed fields where data can be extracted.

(Content of file "R3ta_hints.txt" in exact following syntax):

ARFCSDATA       ARFCTIME

BALDAT  LOG_HANDLE

Regards,

Pino

[Former Member]

Hello Jack,

Can you check once under DATA directory under specified Export directory?

Thanks.

Best Regards,

Anita

[jack_chen4]

Hi, Anita

I checked it again and found only whr files of table recorded in the manually predefined file.  Since the guide says "Create a file that contains lines of the form <table>%<nr_of_splits> for all tables to be split.", I added the table ATAB for test and found ATAB-i(1,2,3...).WHR.  But no whr file of the tables recorded in the R3ta_hint.txt was produced here.   do you mean if R3ta_hint.txt work correctly, whr files should be produced under DATA directory under specified Export directory?

Thanks for your response

Jack

[Former Member]

Hello Jack,

I did mean 'R3ta_hint.txt work correctly, whr files should be produced under DATA directory under specified Export directory'.

So, if I understand correctly you got *.WHR files for table ATAB only under DATA directory and not other predefined tables in R3ta_hint.txt.

What is source OS and DB?

Thanks.

Best Regards,

Anita

[jack_chen4]

Hi, Anita

Yes, only .WHR files for table ATAB under DATA directory was created. And it may be caused by that I manually created a file other than R3ta_hint.txt.  Did they conflict with each other?

My source OS is Euse Linux Enterprise 11 SP4 and DB is DB2 10.5 FP6SAP. And I run them in a virtual machine  created by vmware.

Thanks

Jack

[jack_chen4]

My OS is SUSE not EUSE, Sorry for the mistyping.

[Former Member]

Hello Jack,

That is the reason I think. You need to edit the R3ta_hint.txt file and append there itself. Try that and see.

Thanks.

Best Regards,

Anita

[jack_chen4]

Hi Anita,

if I understand right, "Create a file that contains lines of the form <table>%<nr_of_splits> for all tables to be split.", and using R3ta_hint.txt play the same role.  Actually, R3ta_hint.txt do not obey the form <table>%<nr_of_splits> and cannot be used directly, so it just indicate me to how to create the file as the input in the step "table splitting preparing" in SWPM , right?

Thanks,

Jack

[Former Member]

Hello Jack,

Pasting this from SAP System Copy Guide:

Using Hints

With the file R3ta_hints.txt, you can instruct R3ta to use specific columns of a table to create a WHERE

condition. The file has to be located in the directory in which you start R3ta.

With one line in the file R3ta_hints.txt, you specify the table name followed by one or more column names,

separated by a blank. The columns have to be part of the primary key of the table. These specifications are used

by R3ta to create the WHERE condition.

A file R3ta_hints.txt with column hints for several tables is delivered with the installation media (folder

IM_<OS>). If you want to modify this file, copy it from the directory IM_<OS>/COMMON/INSTALL to the installation

directory and adapt it according your requirements as soon as the Parameter Summary dialog appears and before

starting the processing phase.

So from what I understand, you need to modify R3ta_hints.txt file itself.

Thanks.

Best Regards,

Anita

[jack_chen4]

Hi Anita

Thank you very much.  This question confused me too long.

Best regards

Jack