2186744 - FAQ: SAP HANA Parameters | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2186744 - FAQ: SAP HANA Parameters

Symptom

You have questions related to SAP HANA parameter settings.


Read more...

Environment

SAP HANA

Product

SAP HANA, platform edition all versions

Keywords

SAP HANA parameter configuration settings customization attributes.ini
daemon.ini
dpserver.ini
executor.ini
global.ini
indexserver.ini
multidb.ini
nameserver.ini
statisticsserver.ini
webdispatcher.ini
xsengine.ini application_container
auditing configuration
authentication
authorization
backint
backup
businessdb
cache
calcengine
cds
communication
cryptography
customer_usage
daemon
delta
distribution
execution
expensive_statement
global
httpserver
idattribute
import_export
indexing
inifile_checker
internal_hostname_resolution
joins
jsvm
landscape
limits
livecache
load_trace
lobhandling
mdx
memorymanager
memoryobjects
mergedog
metadata
multidb
olap
olap_parallel_result
optimize_compression
parallel
partitioning
password policy
performance_analyzer
persistence
planningengine
profile
public_hostname_resolution
pythontrace
queueserver
readonly_parameters
repository
resource_tracking
row_engine
saml
scheduler
search
session
sld
smart_data_access
sql
sql_client_network_io
sqlscript
sqltrace
statisticsserver
statisticsserver_general
statisticsserver_intervals
statisticsserver_view%
storage
system_information
system_replication
system_replication_communication
system_replication_hostname_resolution
table_consistency_check
table_placement
table_redist
threads
topology
trace
traceprofile%
transaction
unload_trace active
actual_mode
add_key_info
affinity
alert_audit_trail_type
all_moves_physical
allocationlimit
allow_dynamic_range_partitioning
allow_fox_table_type
allow_non_readonly_sqlscript
allowed_sender
application_list
async_free_target
async_free_threshold
auto_decision_func
auto_merge_decision_func
auto_merge_priority_func
balance_by_execution_count
balance_by_execution_time
balance_by_memuse
balance_by_memuse_weight
balance_by_part_id
balance_by_partnum
balance_by_partnum_weight
balance_by_rows
balance_by_rows_weight
balance_by_table_classification
balance_by_table_subclassification
basepath%
btree_cache_heavy_hitters
buffer_size
bulk_delete_threshold
bw_schema
cache_temp_translation_tables
calculation_view_unfolding
cch_reopening_enabled
ccl_fips_enabled
change_compression_threads
check_compression_no_automerge
check_duplicates_on_merge
check_global_trans_consistency
check_interval
check_max_concurrency
check_secondary_active_status
check_slave_on_master_restart
checksum_algorithm
client_ciphersuites
client_distribution_mode
client_sni_enabled
collect_leaked_pages_at_startup
configpath
connection_history_lifetime
connection_history_maximum_size
consistency_check_at_startup
content_vendor
core
cpu_time_measurement_mode
critical_audit_trail_type
critical_merge_decision_func
csv_import_path_filter
data_backup_max_chunk_size
data_backup_savepoint_lock_timeout
datashipping_logsize_threshold
datashipping_min_time_interval
datashipping_snapshot_max_retention_time
debug_export_detail
default_application_path
default_audit_trail_path
default_audit_trail_type
default_connections_pool_max_size
default_read_timeout
default_stack_size_kb
default_statement_concurrency_limit
delta_merge_statistics_record_limit
detailed_error_on_connect
differ
disable_plan_simplification
disable_string_length_checks
disj_filter_into_union_threshold
display_sql_statement_parameters_in_dump
dynamic_parallel_insert_max_workers
dynamic_range_check_time_interval_sec
dynamic_range_default_threshold
early_garbage_collection_interval
early_garbage_collection_threshold
editing
embedded
emergency_audit_trail_type
enable
enable_auto_log_backup
enable_convert_es_to_row_tables
enable_csv_import_path_filter
enable_data_compression
enable_full_sync
enable_log_compression
enable_merge
enable_old_update_from_behavior
enable_remote_cache
enable_repartitioning_with_gcd
enable_select_into_scalar_udf
enable_single_value_caching
enable_ssl
enable_tracking
enabled
ensure_backup_history
environment
estimate_compression_threads
exclusion_%
fda_enabled
force_first_password_change
force_partnum_to_splitrule
force_turning_on_metadata_separation
garbage_collect_interval_s
garbage_lob_file_handler_enabled
garbage_lob_file_handler_interval
gc_unused_memory_threshold_abs
gc_unused_memory_threshold_rel
get_candidates_threads
global_allocation_limit
global_auditing_state
ha_fc%
ha_fujitsu%
ha_provider%
hard_merge_priority_func
hash
icm/HTTP/logging_n
icm/HTTP/mod_15
idle_connection_timeout
idle_connection_timeout_application_%
idle_cursor_alert_timeout
idle_cursor_lifetime
inactive_at_service_start
initial_partitions
initial_partitions_bw_cube
initial_partitions_bw_dso
initial_partitions_bw_psa
instances
instancids
internal
internal_check_max_concurrency
internal_network
internal_support_user_limit
interval_purgehistory
inverted_index_verification_after_load
join_relocation
keep_old_style_alert
keep_shared_memory_over_restart
keep_shared_memory_over_restart_timeout
keypositions_maxsize
late_materialization_threshold
late_materialization_threshold_for_insert
listeninterface
listenport
lmstructurepath
load_balancing_func
load_monitor_granularity
load_monitor_max_samples
lock_table_array_size
lock_wait_timeout
log_backup_timeout_s
log_backup_using_backint
log_buffer_count
log_buffer_size_kb
log_mode
log_segment_size_mb
logshipping_async_buffer_size
logshipping_async_wait_on_buffer_full
logshipping_timeout
max_cache_size_kb
max_chunk_size_for_delete
max_chunk_size_for_insert
max_chunk_size_for_update
max_concurrency
max_concurrency_hint
max_early_garbage_collection_jobs
max_gc_parallelity
max_log_backup_group_size
max_output_batch_rows
max_recovery_backint_channels
max_request_runtime
max_result_entry
max_result_entry_per_entity
max_runtime_bytes
max_sql_executors
max_versions_per_record_alert_threshold
max_versions_per_table_alert_threshold
maxchannels
maximum_connections
maximum_external_connections
maximum_unused_inital_password_lifetime
maxthreads
memory_tracking
method
min_hours_since_last_merge_of_part
mincid_table_truncation_interval
minimal_password_length
mode
multi_container_enabled
mvcc_aged_checker_timeout
nested_trigger_check_in_ddl_time
nested_trigger_limit
num_cores
num_exec_threads
number_versions_alert_threshold
oom_dump_time_delta
optimize_cardinality
optimize_combine_filter_multiple_consumer_new
optimize_convex_hull_fems_filter_new
optimize_filter_remove_attributes
optimize_metamodel
optimize_value_id_search
page_compaction_enable
page_compaction_max_pages
page_loadable_columns_limit
page_loadable_columns_min_size
parallel_batch_insert_threshold
parallel_query_execution
parallel_threshold
partition_row_count_threshold
partition_row_count_threshold_bw_cube
partition_row_count_threshold_bw_dso
partition_row_count_threshold_bw_psa
partitioning_threshold
partitioning_threshold_bw_cube
partitioning_threshold_bw_dso
partitioning_threshold_bw_psa
password_expire_warning_time
password_lock_for_system_user
plan_cache_enabled
plan_cache_parameter_enabled
plan_cache_parameter_for_lob_enabled
plan_cache_parameter_sum_threshold
plan_cache_parameter_threshold
plan_cache_size
planviz_enable
poolsize
prefer_multi_column_in_threshold
prefix
preload_column_tables
prepare_threads
private_log_buffer_size_kb
prune_cached_plans
qo_optimize_valuevec_limit
qo_top_1_optimization
reconnect_time_interval
reload_tables
remote_cache_validity
remote_check_timeout
reserve_object_name_prefix
reserved_connections
reserved_instance_numbers
resultcache_clear_config
resultcache_enabled
resultcache_maximum_value_size_in_bytes
resultcache_minimum_query_execution_time_in_milliseconds
resultcache_request_timeout_in_milliseconds
resultcache_white_list
reuse_shared_memory_for_restart
reuse_shared_memory_for_restart_timeout
row_order_optimizer_threads
runtime_structure_persistence
runtimedump_for_blocked_savepoint_timeout
same_num_partitions
saml_service_provider_name
saplogonticketenabledfornewusers
saplogontickettruststore
savepoint_interval_s
savepoint_max_pre_critical_flush_duration
savepoint_pre_critical_flush_retry_threshold
semi_join_virtual_table_threshold
service_thread_sampling_monitor_max_sample_lifetime
service_thread_sampling_monitor_max_samples
service_thread_sampling_monitor_sample_interval
service_thread_sampling_monitor_thread_detail_enabled
sessiontimeout
sign_authn_request
site_id
site_name
size
smart_decision_func
smart_merge_decision_func
smart_merge_enabled
smart_merge_priority_func
socket_keepalive
split_batch_commands
split_history_parallel
split_threads
sql_executors
ssfs_key_file_path
ssl%
sslkeystore
statement_memory_limit
statement_memory_limit_threshold
subplan_sharing
tablepreload_write_interval
tables_preloaded_in_parallel
tcp_keepalive_intvl
tcp_keepalive_probes
tcp_keepalive_time
threadpool
threshold_duration
token_per_table
transaction_history_record_limit
transaction_history_size_limit
translate_ce_datasource_to_select_stmt
translator_cache_size
translator_hashmap_max_size
translator_hashmap_min_size
treat_null_as_zero
tt_complete_fill_threshold
typecheck_procedure_input_param
uncommitted_write_transaction_alert_timeout
unload_lower_bound
unused_retention_period
unused_retention_period_check_interval
usage
use_compact_column
use_fox_loop_caching
use_in_memory_tracing
use_jobex_index_rebuild
use_mountpoints
use_startup_timezone
use_statement_memory_tracking
version_space_partitions
version_threshold
virtual_table_default_cardinality
virtual_table_format
wdisp/system_10
worker_stack_size_kb
workerpoolsize
xmlpath , KBA , HAN-DB , SAP HANA Database , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.