SAP Basis Tech Supports

BWA 7.00: Optimal settings for Revision 50 or later

June 30, 2009 at 9:56 am

[Accelerator] [applocale revision] [BIA] [BWA] [explorer] [major revision] [optimal] [optimization] [parameters] [revision] [up6pen revision]

BWA 7.00: Revision 52Symptom Update to BIA 7.00 Revision 52 Other terms Update,...
BWA 7.00: Optimal settings for Intel Xeon 5570 CPUsSymptom You want to configure optimal settings for Intel Xeon...
BIA 7.00: reduce amount of parallel queriesSymptom You experience a high memory consumption on some or...
BWA 7.00: Sizing figureSymptom You want to find out whether your BWA sizing...
BWA 7.00: Indexing fails due to GPFS issueSymptom Filling, rollup or changerun of BWA indexes fails Other...
BWA 7.00: Analyzing write performanceSymptom You find that indexing in SAP NetWeaver BW Accelerator...
SAP BusinessObjects Explorer Performance & ReliabilitySymptom SAP Note 1366180 “SAP BusinessObjects Explorer PERFORMANCE & RELIABILITY”...
BWA 7.00: Restricted Use of OCFS2Symptom If you observe one or more of the following...

Symptom

You want to apply the optimal settings for SAP NetWeaver BW Accelerator Revision 50 or later.
Other terms

BIA, BWA, Accelerator, optimization, optimal parameters, explorer
Reason and Prerequisites

Prerequisite:
You have updated your BW Accelerator from Revision 49 or earlier to Revision 50 or later.
Reason:
As the update procedure does not change any existing parameter settings, there may be scope for improvement if you change some of your settings.
Solution

Ensure that the following settings are in place:
TREXExecutor.ini:
[global]
use_old_trace_format = off
stop_net_fail = 1
# stop_net_fail 0 ~ continue, 1 ~ stop local, 2 ~ stop remote

TREXIndexServer.ini:
[global]
extensions =
report_syntax = on
usesse = auto

[thread_limit]
threads_aggregate =
timeout_aggregate = 0
threads_aggregate_calls =
threads_bw_merge_reftables =
timeout_bw_merge_reftables = 0

[indexing]
tmpx_threads =
use_old_cell_table = no

To activate the changes, you need to restart all TREX index servers.