IBM Power Connect, learn, share, and engage with IBMPower. Join / Log in
An easy way to leverage the superiority of the IBM POWER processor to greatly speed up the table load process during a tenant database restart operation is to increase the tables_preloaded_in_parallel configuration parameter.For HANA v2 SPS05 rev56 or higher, the formula is the greater of 5 or (0.1 * CPU_THREADS); see SAP Note 3014176 - Applying System Size Dependent Resource Limits During Installation or Upgrade(https://launchpad.support.sap.com/#/notes/3014176).For all tenant databases (indexserver.ini) on HANA v2 on Power, increase the "tables_preloaded_in_parallel" configuration parameter in HANA Studio to be a percentage of the number of lcpu on the LPAR. One way to find lcpu allocation is the lparstat command (you may have to run this as root):