how to use tablesplitting

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

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.