Solution : https://service.sap.com/sap/support/notes/1899817 (SAP Service marketplace login required)
Summary :
For SAP Business Suite systems using a distributed SAP HANA database (scale-out) from Revision 69 and above, table distribution across the HANA landscape requires specific configuration. Firstly, modification of the global.ini and indexserver.ini files in the relevant sections to adjust table placement and redistribution settings is necessary. Secondly, entries in the table _SYS_RT.TABLE_PLACEMENT must be maintained as outlined, ensuring schema names are correctly replaced with actual database schema names. This setup assists in optimal data management during installation or migration phases handled through SWPM, where the specified parameter file should be used. Additional permissions for table access are mandatory for database users.
Key words :
customer component han-db sap hana database priority recommendations / additional info category installation information validity software componentfrom rel, iniin section [table_placement]- partitioning_threshold- initial_partitions- partition_row_count_threshold header data released, sap notes 1958216 hana landscape redistribution configuration 1908075 bw, iniin section [table_redist]balance_by_execution_time=true indexserver, iniin section [table_redist]balance_by_execution_count=true indexserver, iniin section [table_placement]same_num_partitions=false indexserver, iniin section [table_redist]balance_by_execution_time_weight=1 indexserver, iniin section [table_placement]method=2 global, hana sp5 parameters automatically lose, swpm attachments file namefile size
Related Notes :
| 1958216 | HANA landscape redistribution configuration |
| 1908075 | BW on SAP HANA: Table placement and landscape redistribution |
| 1900822 | |
| 1781986 | |
| 1885758 | Table redistribution for Business Suite on SAP HANA Scale Out |