SQLMD: Cross Node Joins Analysis

[Juwin]

When executing SQLMD for Cross Node Join analysis, the program needs an input file containing Tables and Nodes. 

How to generate this file using the data from HANA DB? Wherever I check in System tables/views, this field with Node information is marked as Internal Use only and always return empty result.

So, how to generate the file with Table & Node information required to execute SQLMD?

Thanks

[dirkhoffmann]

SQLM cross node joins refers to host as node. Node in M_CS_COLUMNS refers to the internal numa node architecture.

You need to check column host in M_CS_TABLES, then you can build a txt file like this:

Table Name Node
%DEFAULT% 1
tableA 2
tableB 2
...
USR21 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15

In this example, USR21 is located on all hosts via OSTR.