Skip to Content
author's profile photo
Former Member

how to use tablesplitting

Dear All,

Please guide me for below query.

1. Migration monitor need to start duing export if we are using tablesplitting ?

2. In tablesplitting preparation we have to provide file which contain list of table which we want to split.

3. In tablesplitting preparation sapinst will create whr file automatically ?

4. we can use tablesplitting for cluster table ?

5. any futher steps need to follow for using tablesplitting ?

Regards,

Nikunj Thaker

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Posted on Apr 25, 2011 at 09:49 AM

    Hi Nikhun,

    1. Migration monitor need to start duing export if we are using tablesplitting ?

    No, you just need to run SAPINST - table splitting prepartion

    2. In tablesplitting preparation we have to provide file which contain list of table which we want to split.

    Yes, you need to create a file with the name of tables to be splitted, numbers of package and its distinct value.

    for example: /1CPMB/DM0001300%5;ROWINDEX

    3. In tablesplitting preparation sapinst will create whr file automatically ?

    Yes, you just need to specified the splitfile you created and the export location for whr files.

    4. we can use tablesplitting for cluster table ?

    Yes.

    5. any futher steps need to follow for using tablesplitting ?

    During Database Export with SAPINST, you need to select Split STR files in Export for Target System screen and check Split perdefined tables and specify the location of your whr files in Split STR files screen.

    I would advise your to use the same export location for table splitting and export dump. This save you from copying splitted *.STR files from /abap/data to the export Dir /abap/data dir.

    Cheers,

    Thanks,

    Nicholas Chang

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on May 06, 2011 at 12:41 AM

    Hi Nicholas Chang,

    QUOTE/

    2. In tablesplitting preparation we have to provide file which contain list of table which we want to split.

    Yes, you need to create a file with the name of tables to be splitted, numbers of package and its distinct value.*

    *for example: /1CPMB/DM0001300%5;ROWINDEX\

    /ENDQUOTE

    Is this file considered the R3ta_hints.txt that documentation usually refer to? I'm making reference to Chapter 5.1.1 of "DB2 Optimization Techniques for SAP Database Migration and Unicode Conversion (sg247774.pdf)" which can be easily locatable with google. The contents of the R3ta_hints.txt file has the following format though.

    BALDAT LOG_HANDLE

    BKPF BELNR

    Thanks.

    Add comment
    10|10000 characters needed characters exceeded

    • No, this is the file that you specified which table to splilt, into how many packages and with the distinct ROWID. You need to identify the tables you would like to split, and create this txt file (name it whatever filename you want, eg: split.txt) with the content of the table to be splits before you run sapinst. SAPINST will ask for the split file when you execute tablesplit prepration.

      Hope this clear your doubt and I can send you the doc if needed.

      Cheers,

      Thanks,

      Nicholas Chang