cancel
Showing results for 
Search instead for 
Did you mean: 

HANA table distribution and table partitioning

Former Member
0 Kudos

Hi Folks,

We are thinking of running the table distribution and table partitioning.

Rather than using HANA studio, we are thinking of using the command line.

Wanted to see how to identify the control flow.

Below are the steps i am thinking of :

--> Generate the plan for the table distribution

--> Execute the plan

--> Monitor the table distribution
--> Verify the table distribution

--> Generate the plan for the table partitioning

--> Execute the plan

--> Monitor the table partitioning

--> Verify the table partitioning

Folks what do you think.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi p517710

It is recommended that you execute one of the available redistribution operations, e.g. via Studio, as opposed to doing large scale redistributions manually.  I'd also add to the list you have that it would be useful to save your current table distribution (details of how to do this are in the SAP HANA Administration Guide) so that you can restore the saved table distribution at a later point in time if necessary.

Ruth

Former Member
0 Kudos


Hi Ruth,

Thanks a ton for the response.

Would you mind please letting me know as to where the recomendation is coming from ?

Regarding to be executed from HANA studio.

Regarding saving the current plan would do so before executing the distribution plan.

Former Member
0 Kudos

No problem!  It's a recommendation re manual distribution, it's detailed in the Admin Guide, in the section "Modify Table Distribution Manually".  Also if it's BW the following may be useful:

2143736 - FAQ: SAP HANA Table Distribution for BW
1908075 - BW on SAP HANA: Table placement and landscape redistribution

Cheers

Former Member
0 Kudos

Hi Ruth,

I dont want to amend the plan, it was just that we wanted to run it from command line. Rather than executing from HANA studio.

Former Member
0 Kudos

Ah ok thanks for the clarification, in that case I'd only really add the step to save the original table distribution in case you want to restore it after monitoring.