Manage Database Configuration [Hands-On]
Overview:
Manage DB Configurations:
Database Configuration
From the Database Overview, you can select the Manage Database Configuration app to manage configuration (*.ini) files.
Every SAP HANA service has its own configuration file (for example, indexserver.ini, which may also be referred to generically as <service>.ini). For service-independent properties, there is also a global.ini file. Configuration files are divided into sections which group all parameters related to a specific functional area.
SAP HANA uses a layered configuration framework. The first layer is the default layer where the default value for all properties is defined, the database layer holds the current configured value for your database. The default value applies unless a change has been made in the database layer. A system layer also exists which can only be maintained by SAP administrators.
Features available to manage database configuration properties include the use of snapshots and comparison tools which can be used to compare different databases. For traceability purposes changes to configuration values are logged and you can review the change history within cockpit.
To open the Database Configuration page, on the Database Overview page, with the Administration or All view selected, click the Manage Database Configuration link on the Database Administration card.
You can filter by Configuration File, Section, and (in multi-host systems) by Host in order to display specific configuration file contents. You can then edit the value of a parameter by overriding the default as described in the sections which follow. While most parameters can be changed when the database is running, changes to some parameters require a database restart to take effect. An online configuration parameter reference is available in the SAP Help Portal which includes details of each parameter and also indicates if a restart is required after a value has been changed.
In general, SAP recommends that you do not change the default values of parameters unless the documentation suggests it or you are instructed to do so by SAP Support.
Example parameter customization:
Configure System Usage Type
You can configure the usage type of your database (for example, production, test, development) by changing the usage system property. This setting is used by SAP HANA cockpit to alter behavior.
Prerequisites
You have the system privilege INIFILE ADMIN.
Context
The system usage type governs to which resource group (production, test, development) the system is assigned in SAP HANA cockpit.
Procedure
Set a value for the parameter in the system_information section of the global.ini file by executing the ALTER CONFIGURATION command. For example:
You can enter any value but the following values are recognized in cockpit to alter behavior. For example, this may trigger a warning to users working on production systems when they are about to perform critical operations such as execute SQL statements, stop or restart the system, perform a data backup, and so on.
production
test
development
custom (default)
Last updated