on 04-22-2015 8:35 PM
Hi experts,
We have an existing sandbox system that is scaled out to 4 hosts, and we need to convert it to single-host.
We found SAP Note 2040346 where it says we need to mofify the following:
1. Adapt the table _SYS_RT.TABLE_PLACEMENT according to 1908075.
2. Use "remove host" from the Administration View in the SAP HANA Studio to unconfigure the database node that we want to remove.
What we dont understand is this phrase:
"you should use the landscape redistribution tool once the node is removed to redistribute the tables in accordance with the "new" rules in _SYS_RT.TABLE_PLACEMENT. To do this, ensure that the options "enable_merge" = true and "force_partnum_to_splitrule" = true are set in the indexserver.ini section [table_redist] before executing the plan generation."
What is landscape redistribution tool and how can we launch and use it? What is plan generation? Is there an SAP standard guide that describes the whole process of removing nodes? Please advise. Your inputs are highly appreciated. Thank you.
Regards,
ANG
Hello alphanancygolf,
As according to note 2040346 (this note just mentions delete nodes not to be only one node), in my view, landscape redistribution tool is mostly to be tab Landscape > redistribution in HANA studio to redistribute tables according to the new landscape.
And for plan generation, it is the execute plan to make the SQL more efficient.
Regards,
Ning
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
SAP Note 2093572 describes the necessary steps more in detail including screenshots.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi alpha,
one of the service traces (most likely the indexserver trace) of the respective host should contain a more detailed information why the reorg failed. Unfortunately, I don't know the exact trace component to look for, but searching for "reorg" in the trace should yield some information.
Best regards,
Stefan
I am getting the logs below:
LandscapeReorg Tables.cpp(01538) : requested TableInfo Object [SAPHANPRD:_SYS_SS_TBL_1561876_RET] not found. Returning 'Invalid'.
LandscapeReorg Tables.cpp(01163) : Found part info without table metadata! Ignoring this Entry. PartInfo: SAPHANPRD:_SYS_SS_TBL_1561876_RET~0; NumRows=0; NumRowsOfDeps=0; Size=0; SizeOfDeps=0;
LandscapeReorg PartInfo.cpp(01201) : general exception caught.
Actual counted 12 LOB-Files on hananode1:30003. Host is not empty.
What does this mean?
User | Count |
---|---|
80 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.