SAP Hana - Services (Process)

> Database > SAP HANA Database (hdb)

1 - About

An SAP HANA system consists of multiple services

Advertising

3 - Savepoint

In order to persist data to disk, each SAP HANA service (that persist data ie nameserver, indexserver, xsengine) has its own separate savepoints.

4 - List

5 - Management

5.1 - Data Dictionary

SELECT * FROM "SYS_DATABASES"."M_SERVICE_MEMORY"
-- Not the same as
SELECT * FROM "PUBLIC"."M_SERVICE_MEMORY"

5.2 - Monitoring

  • Hana Studio: Administration > Landscape. Columns may be added with the “Configure Viewer” icon.

  • Sql can also be used.

See also service

Advertising

5.3 - Stop a service

ALTER SYSTEM STOP SERVICE (host,port)

5.4 - Kill a service

ALTER SYSTEM KILL SERVICE (host,port) [WITH COREFILE]

5.5 - Reconfigure a service

ALTER SYSTEM RECONFIGURE SERVICE ('service', 'host', port)

Depending on service, host, port, different services can be reconfigured. See M_SERVICES

6 - Documentation / Reference

db/hana/process.txt · Last modified: 2017/09/06 19:33 by gerardnico