SAP Business objects Enterprise XI R2 Recommended Settings for Business Objects Deployments

Recommended Settings for Business Objects Deployments

BusinessObjects Enterprise XI R2

Windows and UNIX

Patents

Business Objects owns the following U.S. patents, which may cover products that are offered and sold by Business Objects: 5,555,403, 6,247,008 B1, 6,578,027 B2, 6,490,593 and 6,289,352.

Trademarks

Third-party contributors

Business Objects, the Business Objects logo, Crystal Reports, and Crystal Enterprise are trademarks or registered trademarks of Business Objects SA or its affiliated companies in the United States and other countries. All other names mentioned herein may be trademarks of their respective owners.

Business Objects products in this release may contain redistributions of software licensed from third-party contributors. Some of these individual components may also be available under alternative licenses. A partial listing of third-party contributors that have requested or permitted acknowledgments, as well as required notices, can be found at:

http://www.businessobjects.com/thirdparty

Chapter 1 Introduction 5

Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6

Purpose of this document . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7

Chapter 2 Client Tier Architecture 9

Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10

Desktop operating systems on 2-tier clients . . . . . . . . . . . . . . . . . . . . . . . 10

Browsers on 3-tier clients . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13

Chapter 3 Server Tier Architecture 17

Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18

Web servers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18

Application servers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25

Application server and web server connectors . . . . . . . . . . . . . . . . . . . . . 34

LDAP server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35

BusinessObjects Enterprise Server operating system . . . . . . . . . . . . . . . 39

Chapter 4 Database Tier Architecture 55

Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56

RDBMS server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56

RDBMS client . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70

OLAP server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 75

OLAP client . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 81

Recommended Settings for Business Objects Deployments 3

Contents

Chapter 5 Network Recommendations 83

Network requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .84

Appendix A Business Objects Information Resources 85

Documentation and information services . . . . . . . . . . . . . . . . . . . . . . . . . .86

Documentation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .86

Customer support, consulting and training . . . . . . . . . . . . . . . . . . . . . . . . .87

Useful addresses at a glance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 89

Index 91

4 Recommended Settings for Business Objects Deployments

Recommended Settings for Business Objects Deployments

Introduction

chapter

Introduction

Overview

This document explains the configuration of different elements required to deploy the BusinessObjects XI R2 Business Intelligence query and analysis products.

This document presents recommendations and minimum requirements for application and web servers and BusinessObjects XI R2 administration tools necessary to deploy and BusinessObjects Enterprise XI R2.

Use this document in conjunction with the supported platforms documents, available at:

http://support.businessobjects.com/supported_platforms_xi_release2/

The supported platform documents provide information on the different deployment elements supported for each release of the BusinessObjects Enterprise suite. For details on supported deployment types, refer to the BusinessObjects Enterprise XI Release 2 Installation Guide, available at

www.techsupport.businessobjects.com.

6 Recommended Settings for Business Objects Deployments

Purpose of this docum ent

This document recommendation settings configurations required for the BusinessObjects Enterprise server to support a production or load-testing deployment. This document assumes that you have a thorough knowledge of the BusinessObjects Enterprise XI R2 installation processes, and does not explain how to set up or configure these products.

This guide provides a starting point for setting parameters in a production environment. Keep in mind that you may need to adjust parameters up or down depending upon the exact nature of the deployment (number of users, types of users, document complexity). This guide is not a substitute for ensuring that the product is properly installed, nor is it a substitute for having a good understanding of the product.

The recommendations in this guide are based on a multi-tier architecture.

Introduction

Purpose of this document

This document addresses the configuration of the different deployment elements in the above figure:

• client tier architecture (the client operating system, the browser)

• server tier elements (the web server, the application server)

• database tier elements

• the network

Recommended Settings for Business Objects Deployments 7

Introduction

Purpose of this document

Recommendations presented in this document optimize the supported deployment environments. Some parameter changes described in this document are required; when this is the case it is specified.

Requirements and recommendations described in this document are based on internal tests. Parameter values not described in this document were left at the default value.

8 Recommended Settings for Business Objects Deployments

Recommended Settings for Business Objects Deployments

Client Tier Architecture

chapter

Client Tier Architecture

Overview

This chapter presents recommendations on the client machine minimum configuration for the following scenarios:

• 2-tier products (Designer, Desktop Intelligence, Crystal Reports): refer to

“Desktop operating systems on 2-tier clients” on page 10

• client browsers used to access 3-tier products (InfoView, Desktop

Intelligence in 3-tier mode, Web Intelligence, performance management products): refer to “Browsers on 3-tier clients” on page 13

Note: Parameter values described in this chapter are recommended

minimum values. Your deployment may require increasing certain values

cited here.

Desktop operating systems on 2-tier clients

The following operating systems are supported for 2-tier deployments:

• “Windows 2000 Professional” on page 11

• “Windows XP Professional” on page 12

Refer to the supported platforms documentation for information on support per BusinessObjects Enterprise product.

The following sections describe each of the above operating systems i n terms of the following elements:

• Environment

This section describes the environment, including service pack and patches, per operating system described.

• Hardware requirements

This section describes the required hardware per operating system described.

• Parameters

10 Recommended Settings for Business Objects Deployments

Windows 2000 Professional

Environment

Windows 2000 Professional Service Pack 4

Note: It is highly recommended to update the security patch at least

monthly. You must have Windows update running. MDAC 2.8 required Acrobat Reader 7.0

Hardware

Hardware component Value

Number of CPU’s 1 Type of CPU Pentium III 733 MHz minimum Memory 256 MB recommended minimum Disk (Size) 3 GB of free space minimum, 30 GB for IDE Network Desktop to RDBMS 100Mbps Network Card Number 1 File System Type FAT32 or NTFS (Index Service must be

Swap Space Default

Client Tier Architecture

Desktop operating systems on 2-tier clients

disabled)

Recommended Settings for Business Objects Deployments 11

Client Tier Architecture

Desktop operating sys t ems on 2-tier clients

Windows XP Professional

Environment

Windows XP Professional Edition Service Pack 2 MDAC 2.8 is required. Acrobat Reader 7.0

Hardware requirements

Hardware component Value

Number of CPUs 1 Type of CPU Pentium III 733MHz minimum Memory 256 MB recommended minimum Disk (Size) 3 GB of free space minimum, 30 GB for IDE Network Desktop to RDBMS 100Mbps Network Card Type Ethernet Network Card Number 1 File System Type FAT32 or NTFS Swap Space Default

12 Recommended Settings for Business Objects Deployments

Browsers on 3-tier clients

The following sections describe settings applicable to supported browsers for 3-tier products:

• “Internet Explorer” on page 14

• “Mozilla - Firefox” on page 15

• “Safari” on page 15

Each section is divided into information on the following elements:

• Environment

• Parameters

For information on the hardware of the client machine hosting the browser, refer to “Desktop operating systems on 2-tier clients” on page 10.

Client Tier Architecture

Browsers on 3-tier clients

Recommended Settings for Business Objects Deployments 13

Client Tier Architecture

Browsers on 3-tier clients

Internet Explorer

Environment

Parameters

Version Java Virtual Machine Comment

Internet Explorer 6.0 SP1

Internet Explorer 6.0 SP2

SUN Java Runtime Environment 1.4.2.05

No Microsoft JVM supported.

Security Settings

To access the Security Settings in Internet Explorer:

1. Select Tools > Internet Options > Security.

2. Click Custom Level.

3. In the Security Settings box, set the following parameters:

Parameter Value

Cookies > Allow per-session cookies (not stored) Enable Miscellaneous > Submit nonencrypted form data Enable Scripting > Active scripting Enable

Advanced Settings

To access the Advanced Settings in Internet Explorer:

1. Select Tools > Internet Options > Advanced.

2. Select the following options:

• Under Printing, select Print background colors and images.

• Under Browsing, select Always send URLs as UTF-8 (requires

restart).

14 Recommended Settings for Business Objects Deployments

Mozilla - Firefox

Environment

Version

Mozilla 1.7.5 Firefox 1.0.4

Safari

Environment

Version Java Virtual Machine

Safari 1.3 Apple 1.4.2.05

Client Tier Architecture

Browsers on 3-tier clients

Recommended Settings for Business Objects Deployments 15

Client Tier Architecture

Browsers on 3-tier clients

16 Recommended Settings for Business Objects Deployments

Recommended Settings for Business Objects Deployments

Server Tier Architecture

chapter

Server Tier Architecture

Overview

This chapter presents recommendations on configuring the following elements of the server tier:

• “Web servers” on page 18

• “Application servers” on page 25

• “Application server and web server connectors” on page 34

• “LDAP server” on page 35

• “BusinessObjects Enterprise Server operating system” on page 39

Each section is dedicated to a supported server, and is separated into the following sub-sections:

• Environment

This section describes the environment, including service pack and patches.

• Parameters

This section describes specific parameters and their recommend minimum values. Recommend values for parameters not described in these sections are left at default.

Note: Parameter values described in this chapter are recommended

minimum values. Your deployment may require increasing certain values

cited here.

Web servers

This section covers recommendations concerning the following web servers:

• “Microsoft Internet Information Server” on page 19

• “Apache” on page 20

• “IBM HTTP Server” on page 23

• “WebLogic Web Server” on page 23

• “Oracle HTTP Server” on page 24

Tip: Business Objects recommends that you do not host your web server on

the same machine as a cluster node.

18 Recommended Settings for Business Objects Deployments

Microsoft Internet Information Server

Environment

Version Comment

IIS 5.0 Service Pack 4 You can only use IIS for an ASP deployment. IIS 6.0 You can only use IIS for an ASP deployment.

Parameters

Parameter Value

Process Throttling Disabled Bandwidth throttling

(limitation) TCP Port 80 Number of times

accessed daily Application

Protection Log rotation Daily Log Type W3C log file format HTTP Keep-Alive Enabled Connections Unlimited Connection Timeout 900 seconds ASP script Timeout This parameter is the maximum wait time for the

Disabled

>100,000

Medium (pooled)

execution of one ASP action. The value of this parameter impacts the maximum duration of an interactive refresh. Consider the maximum duration of a document refresh before setting this value.

To allow a maximum ASP timeout of 20 minutes, for example, set this value to 1200 (seconds).This parameter should be less than one hour (3600 seconds) which is the maximum time Internet Explorer will wait for a response.

Server Tier Architecture

Web servers

Recommended Settings for Business Objects Deployments 19

Server Tier Architecture

Web servers

Apache

Environment

Parameters

Version Comment

Apache 2.0.50 Except for HP-UX HP-UX Apache WS 1.0.06.01 For HP-UX only

• Business Objects recommends deactivating IIS if you deploy Apache on

a Windows server. This is not required, but enables you to prevent extraneous processes running on the server.

• If you are deploying Apache on a Windows platform, start the Apache

server as a service, but only start the Apache service after the Tomcat service. Refer to the BusinessObjects Enterprise XI Release 2 Installation Guide for instructions.

• On UNIX platforms, Business Objects recommends that you do not use

port 80 for Apache traffic for security reasons.

The following parameters are located in the httpd.conf file unless specified otherwise.

Parameter Value

KeepAlive On MaxKeepAliverequests 100 KeepAliveTimeout 15 MaxRequestsPerChild 0

Note: Windows platform only.

ThreadsPerChild This value depends on the deployment size. A

recommended value is 200, but you may need to adjust this value depending on the number of peak concurrent users your deployment needs to support.

Note: Windows platforms only.

HARD_SERVER_LIMIT If

20 Recommended Settings for Business Objects Deployments

MaxSpareServers exceeds 256, set

HARD_SERVER_LIMIT to the maximum value

before compilation.

Note: Unix platforms only, located in

httpd.h.

Server Tier Architecture

Web servers

Parameter Value

MinSpareServers Default = 5

Note: Unix platforms only. Refer to Apache

documentation for recommendations: http://

httpd.apache.org/docs/2.0

MaxSpareServers Default = 10

This parameter specifies the desired maximum number of idle child server processes. If there are more idle processes than this value, the parent process kills the excess processes.

Note: Unix platforms only. Refer to Apache

documentation for recommendations: http://

httpd.apache.org/docs/2.0

StartServers Default = 5

This parameter specifies the number of child server processes created on startup. The number of processes is dynamically controlled depending on the load.

Note: Unix platforms only. Refer to Apache

documentation for recommendations: http://

httpd.apache.org/docs/2.0

MaxClients This value depends on the deployment size. A

recommended value is 200, but you may need to adjust this value depending on the number of peak concurrent users your deployment needs to support. The maximum value is 256.

MaxClients exceeds 256, set

HARD_SERVER_LIMIT to the maximum value

before compilation.

Note: Unix platforms only.

Timeout 300 seconds Listen TCP Port number (> 1024) Log rotation Set using the following syntax:

rotatelogs <archive location> <rotation

time in seconds>

Log Type

• access_log: use common format

• error_log: activated

• jk_log: activated (located in TOMCAT_HOME/

conf/mod_jk.conf)

TCP Port > 1024

Recommended Settings for Business Objects Deployments 21

Server Tier Architecture

Web servers

Parameter Value

Load connector

• UNIX

LoadModule jk_module modules/mod_jk.so JkWorkersFile "conf/workers.properties" JkLogFile logs/jk.log JkLogLevel info JkMount /examples/* ajp13 JkMount /*.jsp ajp13

• Windows

mod_jk-2.0.47.dll

User/ Group Set these values to the user name and group

name, respectively, under which Apache will run. This is particularly important if you use the root

user to launch Apache; if you are logged in as the root user to launch Apache and the User/Group are incorrectly defined, Apache may fail to start. Set these parameters in: httpd.conf (located in <apache install dir>/conf) making sure that the user and group names are both valid.

Note: Unix platforms only.

AddDefaultCharset off

Note: If you are using Apache.

AcceptMutx AcceptMutex flock

Note: Linux platforms only.

22 Recommended Settings for Business Objects Deployments

IBM HTTP Server

Environment

Version

IBM HTTP Server 2.0.42.2 IBM HTTP Server 2.0.47

Note: Must be installed under /usr/HTTPServer as root.

Parameters

Refer to “Apache” on page 20 for recommended settings.

Configuring the EdgeSide Include Cache

The default value of the Connector Cache can be too small to cache calls to the BOManager for large Desktop Intelligence documents. To avoid this problem, you can disable the cache, or increase its maximum size by updating parameters in

WebSpherePluginConfig/usr/u/qaunix/appservers/

WebSphere_5.0.2/config/cells/

To disable the cache:

To increase the MaxCacheSize:

where the value depends on the size required for the cache. In the above example, this value is 65536.

plugin-cgf.xml file, located at:

Server Tier Architecture

Web servers

WebLogic Web Server

Environment

Version

WebLogic 8.1 Service Pack 4 WebLogic 9

Parameters

Refer to “WebLogic application server” on page 31 for recommendations.

Recommended Settings for Business Objects Deployments 23

Server Tier Architecture

Web servers

Oracle HTTP Server

Environment

Version

Oracle HTTP Server 10.1.2

Parameters

• The Oracle HTTP Server runs on Windows 2000, AIX, SOLARIS and HP-

• It runs by default on 7777 port.

• When using WebCache, the port number is incremented by 1.

UX.

24 Recommended Settings for Business Objects Deployments

Application servers

This section covers recommendations concerning the following application servers:

• “Microsoft Internet Information Server” on page 25

• “Tomcat” on page 26

• “Sun Java System (formerly SunOne) application server” on page 29

• “WebSphere application server” on page 30

• “WebLogic application server” on page 31

• “Oracle application server” on page 33

• “SAP application server” on page 33

Tip: We strongly recommend that you do not host your application server on

the same machine as a Business Objects cluster node.

Microsoft Internet Information Server

Environment

Server Tier Architecture

Application servers

Environment Comment

IIS 5.0 Service Pack 4 You can only use IIS for an ASP deployment. IIS 6.0 Service Pack 1 You can only use IIS for an ASP deployment.

Note: IIS application server is supported in standalone mode. For

recommended parameter settings, refer to “Microsoft Internet Information

Server” on page 19.

Recommended Settings for Business Objects Deployments 25

Server Tier Architecture

Application servers

Tomcat

Environment

Tomcat version 5.0.2.7 Tomcat version 5.0.2.8 Tomcat version 5.5

• JDK 1.4.2 (Business Objects recommends version 1.4.2.05 or later).

• JDK 1.5 for Tomcat 5.5

If you do a standard installation of BO XI R2, the JDK is configured automatically. If you perform a manual installation and configuration, configure the JDK as follows:

1. Install and configure the system.

2. In

<tomcat_installdir>/common/endorsed/directory, rename

xercesImpl.jar as xercesImpl.jar.old.

3. In the

4. Copy these files to the following directory:

5. Restart Tomcat.

On Windows platforms, install Tomcat as a service. Start the Tomcat service before the Apache service.

<tomcat_installdir>/webapps/wijsp/WEB-INF/lib/

directory, copy the following files:

xalan.jar, xercesImpl.jar, and xml-apis.jar

<tomcat_installdir>/common/endorsed/

Connectors

Web Server Connector

Apache 2.0.55 JK 1.2.4 or Later (Protocol AJP 1.3 )

26 Recommended Settings for Business Objects Deployments

Parameters

Server Tier Architecture

Application servers

Parameter Located in Recommended

setting

JAVA Heap Memory Refer to “Setting the Java Heap Memory” on page 28. maxProcessors server.xml

Set

maxProcessors in the

section of corresponds to the web server connector you deploy (refer to “Application server

and web server connectors” on page 34).

minProcessors server.xml

Set section of corresponds to the web server connector you deploy (refer to “Application server

and web server connectors”

on page 34).

maxActiveSessions server.xml -1 minIdleSwap server.xml -1 acceptCount server.xml

Set

section of

corresponds to the web

server connector you deploy

(refer to “Application server

and web server connectors”

on page 34).

URIEncoding server.xml UTF-8 useBodyEncoding

ForURI

server.xml true ( f or double byte

server.xml that

minProcessors in the

server.xml which

acceptCount in the

server.xml that

150 This value depends

depends on the deployment size. You may need to adjust this value depending on the specific needs of your deployment.

20 This value depends

depends on the deployment size. You may need to adjust this value depending on the specific needs of your deployment. An increase in this parameter should be proportional to any increase in the maxProcessors parameter.

characters)

Recommended Settings for Business Objects Deployments 27

Server Tier Architecture

Application servers

Setting the Java Heap Memory

To set the Java Heap Memory, set the parameter to:

-Xmx1024m

If your deployment includes large Desktop Intelligence documents (*.rep), Business Objects recommends setting the Java Heap Memory limit to 1024 MB if the server has at least 2 GB of memory. Increasing the Java Heap Memory prevents “out of memory” exceptions.

Business Objects recommends using the Java Heap line ( option (all UNIX platforms except AIX).

Note: It is important to configure the Java Heap Memory correctly. Failure to

do so may result in Java “out of memory” exceptions.

-Xmx1024m -server) on operating systems that support this

-server option at the end of the

Location of the parameter

On UNIX platforms, this parameter is located in:

<TomCat_dir>/bin/setclasspath.sh

On Windows platforms, if Tomcat is installed as an application, set the parameter in:

<TomCat_dir>/bin/setclasspath.bat

On Windows platforms, if Tomcat is configured to run as a service, change the parameter in the Windows registry in the following location:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\

Apache Tomcat\Parameters

28 Recommended Settings for Business Objects Deployments

Server Tier Architecture

Application servers

Sun Java System (formerly SunOne) application server

Environment

Version Comment

Parameters

Sun Java System AppServer

8.1 (2005Q1)

Parameter Located in Recommended setting

JAVA Heap Memory

Parallel Garbage collection parameters (for JVM 1.4.x only)

JAVA_HOME In Administration

KeepAlive Timeout

In Administration Console > JVM settings > JVM Options (or with

asadmin command

the as explained below)

In Administration Console > JVM settings > JVM Options

Console > JVM settings /usr/SUNWappserver7/

domains/domain1/ server1/config/init.conf

Default JDK is 1.5, but the version supported for BusinessObjects Enterprise XI R2 is 1.4.2_06+.

• -Xms1024m

• -Xmx1024m

• -XX:MaxNewSize=1024m

• -XX:NewSize=1024m

• -XX:+UseParNewGC

• -XX:+UseConcMarkSweepGC

The path of the J2SE SDK

1.4.2.05 instance. 300

Updating the Java Heap si ze ma nu ally

Y ou can change the Java Heap size in the Administration Console (see above table) or using the asadmin command. For example, if you wanted to increase the size to 1024, you would use the following syntax:

asadmin create-jvm-options --user <admin-username> --

password <admin-password> --instance <app-serverinstance-name> -- "-Xmx1024m"

Then run the reconfigure command as follows to apply this change:

asadmin reconfig --user <user-name> --password <admin-

password> <app-server-instance-name>

Recommended Settings for Business Objects Deployments 29

+ 65 hidden pages