techiehub.in

SAP HANA: Change Configuration Parameters

Posted On October 27, 2024 | By techdebugger.zg@gmail.com | Category: SAP HANA

Overview

Often there are situations where a change in one of the DB configuration parameters is required. Some of the common scenarios (but not limited to) are:

  • Adjusting the connection timeout due to the nature of the application.
  • Adjusting the total number of concurrent connections the database can accept.
  • Adjust the frequency of archive log generation.
  • Adjust the max file size of archive log files.

The requirement to adjust these parameters calls for an understanding of the items below:

  • Where can you find the list of available configuration parameters?
  • Documentation of these configuration parameters?
  • Which files could these changes take place in?
  • How to change these values?
  • How to validate that the change is in effect?

This article addresses each item from the above list.

Change Configuration Parameters

This official HANA database document provides the list of configuration parameters.

Let’s consider the example below. We would like to change the idle connection timeout value for the HANA database. Figure 1 shows the related parameter when searched for in the text box under “Key”.

Figure 1: Shows the HANA reference document when searching for a parameter

Click on one of the listed keys to find more details about the parameter as shown in Figure 2. Key information to note:

  • File name -> Files where the parameter can be amended or added.
  • Value Restrictions -> Range of permissible values.
  • Restart Required -> If the change requires a database restart to be in effect.
Figure 2: Shows the details about idle_connection_timeout from the HANA reference document

After identifying the correct parameter and the value with which this parameter is to be updated, follow the below steps:

  • Login to the HANA machine.
  • Switch to HANA admin user. The default username is hxeadm (but could differ based on the installation).
  • Locate the file indexserver.ini (it can be any other file as well like global.ini, based on the parameter) using locate or find command.
  • Open the file in vim or emacs editor.
  • Add the property as per below in the file (If it’s already present, then simply edit the value of the parameter). In our example, we will assign a value of 60.
[session]
idle_connection_timeout = 60
  • Restart the system if required (this can be determined from the reference document of the parameter, please refer to Figure 2)

Validate Configuration Parameter

To validate that the property has taken effect, execute the below query with an SQL client connected to the HANA database.

SELECT * FROM SYS.M_INIFILE_CONTENTS WHERE KEY='<key-name>';
-- For e.g. 
SELECT * FROM SYS.M_INIFILE_CONTENTS WHERE KEY='idle_connection_timeout';

Conclusion

In this article, we have covered, how to identify, amend, and validate the change for a given configuration parameter for the HANA database.

Categories