Skip to Content
avatar image
Former Member

Objects location in hana

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Dec 23, 2016 at 12:37 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Jan 13, 2017 at 11:40 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 18, 2017 at 03:24 PM

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

    -Sharadha

    Add comment
    10|10000 characters needed characters exceeded