SAP Hana - Data and Log Volume (File)

Sap Hana Architecture

About

Each volume contains one file (datavolume_0000.dat) in which data is organized into pages, ranging in size from 4KB to 16MB (page size class).

Directory

During the installation process, the following default directories are created as the storage locations for data and log volumes:

  • /usr/sap/<SID>/SYS/global/hdb/data
  • usr/sap/<SID>/SYS/global/hdb/log

Type

Data

The data volume contains the data from the last completed savepoint.

Log

The log volume contains all changes on the data volume since the last completed savepoint.

Each log volume contains the file logsegment_<partition_ID>_directory.dat and one or more log segment files (logsegment_<partition_ID>_<segment_number>.dat).

Currently only one log partition is supported for each service, so the default file names are:

  • logsegment_000_directory.dat
  • and logsegment_000_00000000.dat, logsegment_000_00000001.dat, logsegment_000_00000002.dat
  • and so on.

Log segment files are cyclically overwritten depending on the log mode. The log mode determines how logs are backed up. Log volumes only grow if there are no more segment files available for overwriting.

Service

The services that persist data and therefore have volumes are the following:

  • nameserver Only the nameserver service on the active master host persists data. Slave namesever hosts communicate with the master, but do not persist data.
  • indexserver. The indexserver service on all hosts except standby hosts persists data.
  • xsengine (if running). The xsengine service persists data on any host on which it is running.

Management

Reclaim log

Log segment files that are available for overwriting have been backed up and are not required for a database restart. If necessary you can remove these files to free up space in your file system by executing the SQL statement ALTER SYSTEM RECLAIM LOG.

Data Dictionary

Configuration

Default directories

The default directories are defined in the parameters basepath_datavolumes and basepath_logvolmes in the persistence section of the global.ini file.

Documentation / Reference





Discover More
Sap Hana Architecture
SAP Hana - Database Start/Stop/Restart

The data belonging to a savepoint represents a consistent state of the data on disk and remains so until the next savepoint operation has completed. Redo log entries are written to the log volumes for...
Sap Hana Architecture
Sap Hana - (Redo) Log

Redo log entries (in-memory) are written to the log volumes consistently for all changes to persistent data. While logging is disabled no log entries will be persisted, only the data area will...
Sap Hana Architecture
Sap Hana - Data Persistence

SAP HANA persists in-memory data by using savepoints operation in data volume (file). Whenever a Savepoint or a Snapshot is created or a delta merge is performed, data is persisted from memory to the...



Share this page:
Follow us:
Task Runner