on 07-31-2015 1:43 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.