SAP Netweaver Business Intelligence BI / BW

BWA 7.00: Optimal settings for Revision 50 or later

June 30, 2009 at 10:03 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,...
BIA Revision with Polestar Compatibility with BI SPSymptom You want to know which revisions of BWA-Polestar are...
Using RSDDTREX_SINGLE_TABLE_INDEXSymptom The program or function module RSDDTREX_SINGLE_TABLE_INDEX can be used...

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.