Question Re: How to create a list of SAP HANA parameters in Technology Q&A

How to create a list of SAP HANA parameters

yasuda_shigeharu — Wed, 14 Aug 2024 05:35:10 GMT

I am creating a list of SAP HANA parameters.
It seemed like a good idea to use the SYS.M_INIFILE_CONTENTS view to reference all the currently set HANA parameters at once.

This SYS.M_INIFILE_CONTENTS view exists in both systemDB and TenantDB, and each contains different information.

For example, if you search for LAYER_NAME = 'SYSTEM' in the SYS.M_INIFILE_CONTENTS view in TenantDB, several parameters will be found, and if you similarly search the SYS.M_INIFILE_CONTENTS view in SystemDB, several different parameters will be found.

Also, if you search the SYS.M_INIFILE_CONTENTS view by narrowing down the KEY to one, data for the three LAYER_NAMEs "DEFAULT", "SYSTEM", and "DATABASE" will be returned as results.

When creating a parameter list for SAP HANA, how should I organize the SYS.M_INIFILE_CONTENTS views in systemDB and TenantDB?

Re: How to create a list of SAP HANA parameters

Laszlo_Thoma — Thu, 15 Aug 2024 05:51:06 GMT

Can you please check following SAP Knowledge Base Article:

2186744 - FAQ: SAP HANA Parameters

Regards,
Laszlo

Re: How to create a list of SAP HANA parameters

yasuda_shigeharu — Wed, 21 Aug 2024 01:37:35 GMT

Thank you for your reply. I checked Note.2186744, but it's difficult for me to understand. Example) I executed the following SQL statement in SystemDB and TenantDB. hdbsql SYSTEMDB=> select * from SYS.M_INIFILE_CONTENTS where FILE_NAME = 'global.ini' and KEY = 'global_auditing_state' FILE_NAME,LAYER_NAME,TENANT_NAME,HOST,SECTION,KEY,VALUE "global.ini","DEFAULT","","","auditing configuration","global_auditing_state"," FALSE" hdbsql TH1=> select * from SYS.M_INIFILE_CONTENTS where FILE_NAME = 'global.ini' and KEY = 'global_auditing_state' FILE_NAME,LAYER_NAME,TENANT_NAME,HOST,SECTION,KEY,VALUE "global.ini","SYSTEM","","","auditing configuration","global_auditing_state","true" "global.ini","DATABASE","","","auditing configuration","global_auditing_state","true" "global.ini","DEFAULT","","","auditing configuration","global_auditing_state","FALSE"

Re: How to create a list of SAP HANA parameters

yasuda_shigeharu — Wed, 21 Aug 2024 01:51:40 GMT

Thank you for your reply.

I checked Note.2186744, but it's difficult for me to understand.

Example)
I executed the following SQL statement in SystemDB and TenantDB.

hdbsql SYSTEMDB=> select * from SYS.M_INIFILE_CONTENTS where FILE_NAME = 'global.ini' and KEY = 'global_auditing_state' FILE_NAME,LAYER_NAME,TENANT_NAME,HOST,SECTION,KEY,VALUE "global.ini","DEFAULT","","","auditing configuration","global_auditing_state"," FALSE"

hdbsql TH1=> select * from SYS.M_INIFILE_CONTENTS where FILE_NAME = 'global.ini' and KEY = 'global_auditing_state' FILE_NAME,LAYER_NAME,TENANT_NAME,HOST,SECTION,KEY,VALUE "global.ini","SYSTEM","","","auditing configuration","global_auditing_state","true" "global.ini","DATABASE","","","auditing configuration","global_auditing_state","true" "global.ini","DEFAULT","","","auditing configuration","global_auditing_state","FALSE"

In the above case, how should we think about the parameters of each database?

If the LAYER_NAME in the SQL output of TenantDB is 'SYSTEMDB', will it be the parameter applied to systemDB?

If the LAYER_NAME in the SQL output of TenantDB is 'DATABASE', will it be the parameter applied to TenantDB?

The value 'DEFAULT' is output for LAYER_NAME in the SQL output of both SystemDB and TenantDB, but shouldn't they basically be the same?

Also, if there is a parameter with LAYER_NAME registered as 'SYSTEMDB' in both systemDB and TenantDB, which DB's parameter set will be valid for systemDB

Re: How to create a list of SAP HANA parameters

Laszlo_Thoma — Wed, 21 Aug 2024 05:24:06 GMT

Can you please check following SAP Knowledge Base Article:

2186744 - FAQ: SAP HANA Parameters - - > 3. Can parameters be set on different layers?

As an example:

2101244 - FAQ: SAP HANA Multitenant Database Containers (MDC) - - > 19. Is there global allocation limit per tenant?

Also please check:

2600030 - Parameter Recommendations in SAP HANA Environments

Regards,
Laszlo