Skip to Content

Partitioning in Hana Database

Dear Guru’’s,

We have decided to partition table BSEG and FAGLFLEXA and we are doing it based on SAP Note : 2044468.

What does bulk_thread and split _thread does during partition phase.

If a value is set as 12 for bulk load thread and 48 is set for split thread. How it’s being splitted what makes the difference in values since split thread can be set up to 120. How it splits is it based on cpus and ram and how it splits. Our environment has 6TB and 120 CPU’s.

Thanks and Regards,

Mithran

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Aug 26, 2019 at 05:09 PM

    Hello mithran vel,

    I believe this is the SAP note for your answer

    2114710 - FAQ: SAP HANA Threads and Thread Samples

    Thank you

    Yogesh


    Add a comment
    10|10000 characters needed characters exceeded

    • Dear Yogesh Patel

      Thanks for replying my query and sorry for being late in response.

      setting the thread values does not change much in partition. so started in default values and ran in our test environment and it was successful.

      When we proceeded in our production system. Partition ended with error. FAGLFLEXA had 2 partitions earlier. now proceeded with 8 partitions and it got failed with error stating "split/merge failed". All parameters are correct.

      I am having a doubt whether before starting partition, HANA DB need to be restarted so all the connections will be removed?

      Thanks & Regards,

      Mithran

  • Posted on Oct 01, 2019 at 01:48 PM

    Hello mithran vel,

    That may be true, Can you give it try and see if it work..

    Restart DB + Close all connections

    Let me know if you still facing issue we can look in to it.

    Cheers,

    Yogesh

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.