In the upcoming days and weeks, we will be publishing new tutorial videos about what’s new and changed for SAP HANA Cloud. The focus of this series is on system administration with SAP HANA cockpit.
For the overview blog about What’s New with SAP HANA Cloud Administration, see
Any good? Post a comment, share on social media, and/or give a like. Thanks!
In this video tutorial, we show you how to configure system parameters using the System Configuration app using the SAP HANA cockpit for SAP HANA Cloud.
What’s New and Changed?
Compared to the SAP HANA platform and express editions (on-premise)
- Configuration file templates (not available); with templates you can clone system configuration from one system to another. As SAP HANA Cloud is a single tenant database environment, this is not applicable.
- Significant reduction of the number of system parameters (see below)
SAP HANA Cloud – SAP HANA Cockpit: System Configuration
SAP HANA systems are configured with system parameters. This is file-based with one file for each service plus some additional config files. These files have the INI extension and are commonly referenced as INI files. Indexserver service configuration is stored in the indexserver.ini, nameserver service configuration in nameserver.ini, etc. Although editable, the recommended and supported way of changing system parameters is with the SQL interface. SAP HANA cockpit (and other tools) provide a graphical interface for this activity. Changing system parameters requires the INIFILE ADMIN system privilege.
To change system parameters for SAP HANA Cloud, we can use the System Configuration app in the SAP HANA cockpit or the SQL Console of the SAP HANA database explorer.
System parameters come with a default value which can be overruled at the SYSTEM, HOST, and DATABASE layer. For SAP HANA Cloud, the host layer does not apply as it is a single host system. Parameters at the system level are managed by SAP (configured in the system database) and this includes for example the restricted features described in the previous post about backups. This leaves only database layer configurable (where permitted).
As a consequence, the number of configurable system parameters for SAP HANA Cloud has been considerably reduced. The latest SAP HANA, express edition (SPS 04) contains 1810 and 1000 parameters for the system and default tenant database respectively. The System Configuration app in SAP HANA cockpit for SAP HANA Cloud displays 109 parameters of which 81 are documented in the Configuration Parameter Reference.
For the documentation, see
- System Configuration, SAP HANA Cockpit
- Configuring SAP HANA System Properties (INI Files), SAP HANA Cloud Administration Guide
- SAP HANA Cloud Configuration Parameter Reference
Recommended KBA for general information about SAP HANA system parameters (but not specific and not always relevant to SAP HANA Cloud).
The System Configuration app includes a search bar and filter for configuration file and section (host can be ignored).
The following (tenant database) services are configurable but not all parameters (109) editable.
- indexserver (56)
- global (29)
- computeserver (10)
- scriptserver (12)
- dpserver (2)
- statisticsserver (2)
Global applies to the system as a whole, for example auditing, authorization, and authentication. The indexserver configures the tenant database, computeserver the SQL compiler, scriptserver for function library (AFL/PAL, currently not available), dpserver for Data Provisioning, and statistics server for statistics.
The following INI files are also listed but currently do not contain any parameters
System Configuration provides the following functionality
- Change (overrule) parameters
- Add new parameters (plus) and sections (Add Section) – sections serve to organize parameters
- Create a snapshot of the current configuration (all files)
- Compare a parameter to a snapshot value
- View the change history of parameters
System Configuration – Change history
System Configuration – Compare
System Configuration – Snapshot
SAP HANA Database Explorer
System Monitoring Views
The information displayed in the System Configuration app comes from the system monitoring views which you can query in the SQL Console of the SAP HANA Database Explorer.
For “online” documentation, see the view CONFIGURATION_PARAMETER_PROPERTIES. Alternatively, check the SAP HANA Cloud Configuration Parameter Reference.
SQL Console – Configuration Parameter Properties
INIFILE System Monitoring Views
To change system parameters, use the ALTER SYSTEM ALTER CONFIGURATION statement.
ALTER SYSTEM ALTER CONFIGURATION ('indexserver.ini', 'SYSTEM') SET ('password policy', 'force_first_password_change') = 'false' WITH RECONFIGURE;
For the documentation, see
- ALTER SYSTEM ALTER CONFIGURATION Statement (System Management), SAP HANA Cloud SQL Reference Guide
Although not specific to SAP HANA Cloud, the Statement Library of the SAP HANA Database Explorer also contains several scripts related to system parameters.
For the documentation, see
- Use the Statement Library to Administer Your Database, SAP Cloud Platform, SAP HANA Service (not yet available for SAP HANA Cloud)
Learned Something New?
Post a comment, share on social media, and/or give a like. That’s how the community works. Thanks.
If you would like to receive updates, connect with me on
Denys van Kempen