Skip to Content
0

Objects location in hana

Dec 14, 2016 at 07:56 AM

253

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Pavan Bhamidipati Dec 23, 2016 at 12:37 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0
Lars Breddemann
Jan 13, 2017 at 11:40 AM
0

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).

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Lars,

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

0

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.

0
Sharadha K Jan 18, 2017 at 03:24 PM
0

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

-Sharadha

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0