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 |
|---|---|---|---|---|
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 |