Skip to Content

HANA 2.0 SP1 - MDC - View SYS_DATABASES.M_LICENSE mssing

Dear all,

as per SAPs documentation there should be a View within the SYSTEMDB (for HANA MDC Setups) called

SYS_DATABASES.M_LICENSE

However it seems as if some HANAs do have this view and others do not. Has anybody come across this issue?

HANA1

version: 2.00.020.00.1500920972

SELECT VIEW_NAME FROM VIEWS WHERE SCHEMA_NAME = 'SYS_DATABASES' and VIEW_NAME LIKE '%LICENSE%'
VIEW_NAME
"M_LICENSE"
"M_LICENSES"
"M_LICENSE_MEASUREMENTS"
"M_LICENSE_MEASUREMENT_STATISTICS"

HANA2

version 2.00.010.00.1491294693

SELECT VIEW_NAME FROM VIEWS WHERE SCHEMA_NAME = 'SYS_DATABASES' and VIEW_NAME LIKE '%LICENSE%'
"M_LICENSE_MEASUREMENTS"
"M
_LICENSE_MEASUREMENT_STATISTICS"

Is it possible that this view is only available with SP2?

Cheers and thanks in advance,

Jochen

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 28, 2017 at 09:37 PM

    When looking for views/tables in the SYS_DATABASES schema you look for information about the tenant databases.

    The feature to provide each tenant database its own license had only been added in HANA 2 SPS 02, which made it necessary to provide the views in the SYS_DATABASES schema.

    So, yes, it’s not just possible but actually the case that these views in this schema only exist as of HANA SPS02.

    For systems with an older software version, the views are available in the SYS schema.

    Add comment
    10|10000 characters needed characters exceeded