Skip to Content
author's profile photo Former Member
Former Member

A question about R3ta_hint.txt in table splitting

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 18, 2015 at 06:05 AM

    Hello Jack,

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

    Thanks.

    Best Regards,

    Anita

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 19, 2016 at 01:45 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.