WHR splitter in OS DB migration

[Former Member]

Hi,

During export , table splitting preparation  .WHR files are created. and we need where splitter to split .WHR files again.

Now during table splitting preparation R3TA is called automatically.

Now when where splitter is called? is it automatically called by SAPINST , if yes at which stage? Or we need to manually split the .WHR files further.

Regards,

Arpit

[Former Member]

Hi Arpit,

I believe you are using SWPM/SAPINST for migration. In this case you don't need to call Where splitter manually as SAPINST will take care of it.

You need to call where splitter when you are using table splitter manually via command line.

Regards

Dheeraj Nathani

[yakcinar]

Hello Arpit,

What is your DB name?

These note could help you.

952514 - Using the table splitting feature 

• Manual modifications of the where conditions are not supported.

1650246 - R3ta: new split method for MSSQL

1043380 - Efficient Table Splitting for Oracle Databases

You can check TADM70 training document also.

Below you can see the migration steps and where splitting tekes place.

Regards,

Yuksel AKCINAR

[Former Member]

Hi Yuksel,

Thank you for your reply and the pic.

We have oracle database.

I Just gone through TADM70 [ Advance migration Tech ] page 236

"Where splitter is part of JAVA package splitter archive. In case of SAPINST , it will be called automatically. IF R3TA was called directly , the WHERE splitter must called manually."

Best regards,

Arpit.

[yakcinar]

Hello Arpit,

You can check "Figure 219: Table Splitting in SAPINST ≥ NW04" and below texts.

As you can see book says: "Table splitting is a task which will be done before the export."

You should give the top 50 (you can decide this) table names in the R3ta_hints.txt file and it will prepare .WHR files for the given tables.

You can decide the size of the export files. So analyze is done automatically for the given tables.

Regards,

Yuksel AKCINAR