SAP Netweaver Business Intelligence BI / BW

Symptom

AS/400: Setting system values for R/3 and BW operation on AS/400.

Other terms

AS/400, OS/400, performance, WRKSYSSTS, WRKSYSVAL, iSeries

Reason and Prerequisites

You want to adjust your system AS/400 for R/3 operation.

Solution

The goal of sensible management of the available main memory should be to provide the operating system with the required main memory and the BW system with the maximum possible main memory.
The following recommendations provide a basis for configuring the BW system as well as possible without a more detailed analysis. However, do not implement these settings before you have completely installed the system.
1. Deactivate the automatic memory setting with the following CL command:
CHGSYSVAL SYSVAL(QPFRADJ) VALUE(’0′)2. Check the configuration of the main memory with the commandWRKSYSSTS. You should see the following screen:
System Pool Reserved Max DB Non-DB
Pool Size (K) Size (K) Active Fault Pages Fault Pages
1 101648 35408 +++ .0 .0 .0 .0
2 416000 0 50 .0 .0 .0 .0
3 256 0 1 .0 .0 .0 .0
4 6384 0 4 .0 .0 .0 .0
Now make the following changes:a) System Pool 1 (QMCHPOOL): Assign sufficient memory to this pool to keep the number of faults as low as possible. For details, refer to the IBM guide ‘IBM OS/400 Work Management’.b) Reduce the size of all remaining pools (pools 3 and 4 in the example) to the absolute minimum to increase the capacity of system pool 2 (QBASPOOL). SAP BW runs in this pool, as do the normal R/3 systems, and then profits the most from the existing main memory.3. Also activate the expert cache. For this, use the command WRKSHRPOOL to display all pools. Ensure that for the base pool (*BASE) the paging option is set to *CALC so that the system can adjust the paging characteristic. You can also use the command WRKSYSSTS to change this option.4. Regularly check the message queue of the system operator QSYSOPR, and ensure error-free operation of the entire system.

Note: These settings apply to a running R/3 system. Do not make these settings until you have successfully completed installation.