PowerConnect for SAP HANA DB Agent Configuration

Configuration Steps

The agent is configured using a properties file located in the PowerConnect installation directory under the conf folder e.g.

/opt/powerconnect/conf/powerconnect-hana-db.properties

The license_key is needed for the agent to start
To configure an outbound connection follow the configuration guide for the target platform

An example configuration file is show below which enables os metrics and audit log collection:

license_key="XXX-XXX-XXX-XXX"
cpu_monitoring_enabled="true"
memory_monitoring_enabled="true"
disk_space_monitoring_enabled="true"
audit_log_db_system_monitoring_enabled="true"
db_system_host="localhost"
db_system_port="35015"
db_system_user="powerconnect"
db_system_password="mysecretpassword"
splunk_hec_url="http://1.1.1.1:8088"
splunk_hec_key="123-456-789-1011-1213"
splunk_index="sap"

Configuration Options

Configuration	Description	Required	Default Value	Comments

Configuration	Description	Required	Default Value	Comments
license_key	License key for the agent	True
db_system_host	Hostname of SAP HANA DB	False	localhost	Agent by default connects to SAP HANA DB running on the localhost
db_system_port	Port of SAP HANA DB	False	30015
db_system_user	Username used to connect to SAP HANA DB	Only for audit log collection
db_system_password	Password for user to connect to SAP HANA DB	Only for audit log collection
cpu_monitoring_enabled	Enable operating system CPU monitoring		false
cpu_monitoring_interval	How often to collect CPU metrics (ms)		60000
memory_monitoring_enabled	Enable operating system memory monitoring		false
memory_monitoring_interval	How often to collect memory metrics (ms)		60000
os_process_monitoring_enabled	Enable operating system process monitoring		false
os_process_monitoring_interval	How often to collect process metrics (ms)		60000
disk_monitoring_enabled	Enable disk iops monitoring		false
disk_monitoring_interval	How often to collect disk iops metrics (ms)		60000
disk_space_monitoring_enabled	Enable disk space monitoring		false
disk_space_monitoring_interval	How often to collect disk space metrics (ms)		60000
network_monitoring_enabled	Enable network interface monitoring	False	false
network_monitoring_interval	How often to collect network interface metrics (ms)	False	60000
oom_trace_monitoring_enabled	Enable SAP HANA out of memory trace file monitoring	False	false
oom_trace_monitoring_directory	Directory where out of memory trace files are generated	False	$retrieval-path$/trace
oom_trace_monitoring_filefilter	File pattern to match for oom trace files	False	compileserver_.*\\.oom\\.trc
audit_log_db_system_monitoring_enabled	Enable audit log collection for system database	False	false
audit_log_db_system_monitoring_interval	How often to collect audit log data (ms)	False	60000
audit_log_db_system_monitoring_lag	Lag setting for audit log collection (ms)	False	60000	This setting is to deal with scenarios where there is a lag between the data being written to the database and its availability for query (usually high load)
audit_log_db_system_monitoring_table	Audit log table name	False	ALL_AUDIT_LOG