Solution : https://service.sap.com/sap/support/notes/1908075 (SAP Service marketplace login required)
Summary :
This SAP Note addresses the correct partitioning and distribution of tables in a BW system using a SAP Hana database, guiding users on utilizing landscape redistribution for scale-out systems. Before initiating redistribution or installing/migrating with SWPM or DMO, it's crucial to prepare by maintaining table placement according to the detailed steps provided. Specific SQL files for configuring system parameters are included, ensuring proper setup for single-node and multi-node (scale-out) configurations. There's also a focus on ensuring adequate user authorizations and addressing table classifications. Follow the given steps carefully to ensure system integrity and performance.
Key words :
1 index server master+ 1 active index server slave 1 index server master+ 2 active index server slaves 1 index server master+ 3, monitoring priority recommendations / additional info category consulting validity software componentfrom rel, customer component han-db-eng-bw sap hana bw engine, components han-std-adm-dba sap hana database administration, hana - handling big data tables attachments file namefile size, active index server slaves, terms landscape reorg landscape reorganization reason, section [table_placement]method = 2same_num_partitions = true note, sap hana sps05 parameters automatically lose, -memory/blog/2013/09/03/sap-hana-landscape-redistribution-
Related Notes :
| 1702409 | HANA DB: Optimal number of scale out nodes for BW on HANA |
| 1958216 | HANA landscape redistribution configuration |
| 1937062 | Usage of RSDU_TABLE_CONSISTENCY |
| 1908073 | BW on SAP HANA: Table distribution and table partitioning |
| 2029271 | SAP HANA SPS 07 Database Maintenance Revision 74.02 |
| 1819123 | BW on SAP HANA SP5: landscape redistribution |
| 1900822 | |
| 1899817 | SAP Business Suite on distributed SAP HANA database (scaleout): Landscape redistribution |
| 2041412 | Error during initial landscape redistribution during migration via SWPM |
| 2040346 | Changes required when deleting nodes from a scale-out SAP HANA database |
| 1751237 | |
| 2019973 | BW on HANA - Handling BIG data tables |