How to create a list of SAP HANA parameters

[yasuda_shigeharu]

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?

[yasuda_shigeharu]

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"

[Laszlo_Thoma]

Can you please check following SAP Knowledge Base Article:

2186744 - FAQ: SAP HANA Parameters

Regards,
Laszlo