Skip to Content

HANA table distribution and table partitioning / BW on HANA

Hi Folks,

After adding 2 new notes we are thinking of running the table distribution and table partitioning.

Now we have a large 8+1 (2TB nodes) Scala Out system.

Below are the steps we are thinking of :

  • Is there anybody , with redistribution know how on large scale out systems (8+1) ?
  • We need information about the estimated runtime . Over all size is 8TB.
  • Is redistribution only possible during downtime ?
  • Is it possible to stop a redistribution, if we are running out of time ?
  • So with another run on the following weekend, we can redistribute the other tables ?
  • What ist the difference between “Redistribution tables after adding host’s “ and Optimize Table distribution” ?
  • If the status of the redistribution run is “failed”. What are the next steps ? Restore whole system or Restore distribution or analyze the reason ?
  • Who is the right person to run the redistribution ( SAP Administrator , database Administrator or BW Administrator) ? Folks what do you think ?

Any information would be highly appreciated

Thanks for your time

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers