SAP HANA Plugins Pack

Document created by Kota Saito on Jun 10, 2016Last modified by Kota Saito on Aug 23, 2016
Version 5Show Document
  • View in full screen mode


Overview

 

The service templates are for SAP HANA services management (e.g. monitor, restart, alert), and database management (e.g. monitor, compress, delta merge).

There are some different service templates for each use case. See below for detail.

 

Service TemplateDescription
SAP HANA Monitor HDB Services And Restart Failed Services Service Template

This service template assumes the following servers:

SAP HANA Server

1) This is the Linux Server where SAP HANA is installed and running.

 

The following provides an overview of the processing:

1) Monitors the status of the HANA Services.

2) If all the HANA services are Running and Green, then the templates waits for 15 minutes before monitoring the status of the HANA Services again.

3) If any of the HANA services are not Running, then the following actions are performed

  i) The template captures the CPU utilization, trace files of the failed services as well as the runtime dump/full system dump of the system in specific files

  ii) If any lock files are present for the failed HANA services, then these lock files are removed

  iii) The failed HANA services are restarted

  iv) Triggers an email to a user specified ID specifying the details of the HANA server such as IP, SID and Instance number as well as the location of the files where CPU utilization, runtime dump and traces have been stored.

 

The template then waits for 15 minutes before monitoring the status of the HANA services again.

SAP HANA Monitor Delta Merge Service Template

This service template retrieves the tables where raw record count is greater than 3.5 billion and delta memory size is greater than the user specified value.

The following provides an overview of the processing.

(1) Retrieves the tables where raw record count is greater than 3.5 billion and delta memory size is greater than the user specified value.

(2) If the number of rows are greater than zero, sent an email to the admin.

(3) Validate the delta memory usage. If the delta memory usage is greater than the main memory usage, sent an alert to the admin.

(4) Repeat the template continuously for every 15 minutes.

SAP HANA Trigger Delta Merge Template

This service template triggers delta merge for the specified tables according to the action to perform specified (hard, smart, forced or memory) and output the status to the CSV file and send an alert e-mail.

The following provides an overview of the processing.

(1) Triggers delta merge for the specified tables and output the status to the CSV file and send an alert/warning e-mail.

SAP HANA Monitor Data Compression Service Template

This service template retrieves the list of column store tables where the data compression ratio is less than a user specified value, or a default compression ratio of 70%.

 

Following provides an overview of the processing

1. Obtains the list of column store tables here the data compression ratio is less than a user specified value, or a default compression ratio of 70% as well as the delta merge status for these tables.

2. If no records are returned, then the service template exits the execution. If any records matching the specified criteria are returned, the results are stored in the CSV file and the location of the CSV file is sent via email to the user.

3. Steps 1 and 2 are repeated at regular intervals of 15 mins.

SAP HANA Trigger Compression Optimization Service Template

This service template triggers the data compression for the specified table name by the user and returns the result post compression.

 

Following provides an overview of the processing

1. Trigger the compression optimizations on the tables specified by the user and check the status post optimization.

2. Compression status , either successful or failed, output post compression is stored in the CSV file and an email notification is sent to the user. If compression is failed on all the tables due to incorrect schema name or table name, the service template exits.

 

Download

 

SAP HANA Monitor HDB Services And Restart Failed Services Service Template

VersionFileDescriptionTemplate IDVendor IDNotes
01.00.01DownloadInitial ImplementationSAPHANAMonitorHDBServicesAndRestartFailedServicesServiceTemplatesample.hitachi.software.dna.cts.sap.hanaDetail Information

 

SAP HANA Monitor Delta Merge Service Template

VersionFileDescriptionTemplate IDVendor IDNotes
01.00.00DownloadInitial ImplementationSAPHANAMonitorDeltaMergeServiceTemplatesample.hitachi.software.dna.cts.sap.hanaDetail Information

 

SAP HANA Trigger Delta Merge Template

VersionFileDescriptionTemplate IDVendor IDNotes
01.00.00DownloadInitial ImplementationSAPHANATriggerDeltaMergeServiceTemplatesample.hitachi.software.dna.cts.sap.hanaDetail Information

 

 

SAP HANA Monitor Data Compression Service Template

VersionFileDescriptionTemplate IDVendor IDNotes
01.00.00DownloadInitial ImplementationSAPHANAMonitorDataCompressionServiceTemplatesample.hitachi.software.dna.cts.sap.hanaDetail Information

 

 

SAP HANA Trigger Compression Optimization Service Template

VersionFileDescriptionTemplate IDVendor IDNotes
01.00.00DownloadInitial ImplementationSAPHANATriggerCompressionOptimizationServiceTemplatesample.hitachi.software.dna.cts.sap.hanaDetail Information

 

 

How to use

 

See spec documentation (xlsx) for detail of each plug-ins such as input/output properties and error code.

Outcomes