Thursday, September 1, 2016

How to list and export all HANA configuration parameters

Requirement : You want to export all SAP HANA system parameter to a HTML/text file.

Prerequisite :  You need CATALOG READ or DATA admin role  or SELECT access on SYS schema.

Sometime you need to export all parameters so that you can do a quick compare between Dev , QA and Production system settings. We will use HANA SYSTEM view M_INIFILE_CONTENTS to list down and export all HANA parameters, It's like RSPARAM or RSPFPAR of SAP ABAP system.

Steps:

Open HANA Studio Administrative perspective and go to Catalog > SYS > Views > M_INIFILE_CONTENTS and select "Open Data Preview" from context menu.

This will list down all HANA parameters ,use  the 'SAVE' option to export the content as HTML or other file format.
.

SAP HANA M_INIFILE_CONTENTS

HANA parameters can be viewed and changed in the "Configuration" tab of HANA Studio.

HANA Parameter Configuration Tab


1 comment: