Objects location in hana

[Former Member]

Hi,

I would like to know how we can obtain object location (residing on which node) information from HANA. I can get details for tables from M_TABLE_LOCATIONS or M_TABLE_PERSISTENCE_LOCATIONS , but is there a way to find out index or any related objects location as well?

Is it like table residing in on node will have dependent objects in same node?

Thanks,

Shaheer

[Sharadha1]

Check the table - PACKAGE_CATALOG under _SYS_REPO schema. might be helpful.

-Sharadha

[Former Member]

Hi Sharada - I'll take a look and reply. Thanks!

[lbreddemann]

What other objects do you have in mind?

In SAP HANA tables are the only objects that actually save any data.

Indexes defined on those tables are created on the same node (and cannot be moved to another node).

[Former Member]

Hi Lars,

We plan to move tables to the other node. Does the dependent objects will also be moved along with the tables?

[lbreddemann]

Again: what other dependent objects? There are no other objects than tables, that you possibly could move. Dependent tables, e.g. via foreign key constraint, won't be moved automatically.

[bpawanchand]

Hi ,

I am not sure what exactly you mean by node. The different possible places where you can get access to your development artifacts are from Modeler and Development perspective. Catalog: Basically helps you to get to know about the schema and Public synonyms. Additionally you also have a possibility to filter the list by using the filter option from the context menu.

To get you know about the information views the best place to find them in repository. navigate to your package and use the same filter option to exactly display on the package on which you are working.

Thanks

Pavan

[Former Member]

Hi Pavan,

Seems like you're referring to developer point of view. This is hana database core stuff and would like to know the persistence location of the objects (we can get for tables, but need to know for other objects)

Regards,

Shaheer