Skip to main content
Skip table of contents

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

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

CODE
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

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.