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

Server Tier Architecture

Application servers

Business Objects recommends using the -server option at the end of the Java Heap line (-Xmx1024m -server) on operating systems that support this option (all UNIX platforms except AIX).

Updating security permissions

In the server.policy file, add the following lines:

grant {

permission java.util.PropertyPermission "*",

"read,write"; permission java.net.SocketPermission "*", "accept"; permission java.io.FilePermission "/<TEMP_DIR>/-",

};

"read,write,delete";

WebSphere application server

Environment

Environment details

WebSphere 5.1.1.1

Note: You need to install the following patch: PK12027 (memory leak in

invocation cache after applying cumulative fix). The Express version is not supported.

WebSphere 6.0.0.1

Note: On UNIX platforms, WebSphere application server is supported in 32-

bit mode only.

Parameters

Parameter Location Recommended setting/ value

Initial Java heap size

Maximum Java heap size

Note: The /tmp size needs to be set to 500 MB.

30 Recommended Settings for Business Objects Deployments

Web Admin Console Application Server > server1 > Process definition

64 MB

1024 MB

WebLogic application server

Environment

Environment details

WebLogic 8.1 Service Pack 4 with JDK 1.4.2_06 If installed on HP-UX, the following patches must be

installed:

• PHNE_30367 Cumulative STREAMS patch

• PHNE_31247 Cumulative ARPA Transport patch

For information, refer to:

http://e-docs.bea.com/wls/certifications/index.html

Parameters

General parameters

The following WebLogic administration parameters apply to all platforms:

Parameter Recommended setting/ value

Thread Count 45 Socket Readers 50 Stuck Thread Max Time Set this value to the Maximum active time

Stuck Thread Timer Interval 60 Threads Increase 5

Server Tier Architecture

Application servers

specified for the Web Intelligence cluster.

Recommended Settings for Business Objects Deployments 31

Server Tier Architecture

Application servers

UNIX-specific parameters

The following parameters apply to all UNIX platforms:

Parameter Recommended setting/

value

JAVA_OPTIONS *

• in startWebLogic.sh on UNIX platforms

• -Xms1024m

• -Xmx1024m

• in startwls.cmd on Windows platforms

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

-Xmx1024m -server) on operating systems that support this

-server option at the end of the

HP-UX specific parameters

If you are deploying WebLogic on HP-UX 11i, the following parameter settings are recommended as minimum values. Set these values within the HP-UX environment:

Parameter Role of Parameter Recommended

setting/ value

max_thread_proc Maximum threads per process 1024 maxfiles Soft file limit per process 1024 maxusers Influences other parameters 256 nkthread Number of threads total on the system 3635 Nproc Maximum number of processes 2068 ncallout Number of pending timeouts 2084 maxdsiz Maximum datasegment size 268 MB

Set the ulimit parameters as follows:

ulimit parameter name Recommended value

data segment unlimited file size unlimited nofiles 16384 stack size 8192 memory unlimited time unlimited

32 Recommended Settings for Business Objects Deployments

Oracle application server

Environment

Environment details

Oracle Application Server 10.1.2 Release 2

Parameters

Parameter Recommended setting/ value

Java Heap size

SAP application server

Environment

Environment details

SAP Netweaver 6.40

• -Xms1024m

• -Xmx1024m

Server Tier Architecture

Application servers

Parameters

Parameter Recommended setting/ value

Java heap size

• -Xms64m

• -Xmx1024m

Recommended Settings for Business Objects Deployments 33

Server Tier Architecture

Application server and w eb s erv er connectors

Application server and web ser ver connectors

Connecting Apache and Tomcat

The following are prerequisites for connecting Apache and Tomcat:

• Set the JAVA_HOME variable to the path of the J2SE SDK directory (on

Windows, create a new system variable called JAVA_HOME).

• Ensure that the server hosting Apache and Tomcat has a fixed IP

address.

• Download the corresponding connector.

• On Windows platforms, install both Apache and Tomcat as services. For

Apache, define the service “for all users”. Define Tomcat as an "NT service.”

The following table lists the recommended connector per configuration:

Web server Application server Connector

Apache 2.0.55 Tomcat 5.0.27 and

later versions

org.apache.coyote.tomcat4. CoyoteConnector

located in server.xml. JK 1.2.4 or Later (Protocol AJP

1.3 )

For information and to download these connectors, refer to:

http://apache.crihan.fr/dist/jakarta/tomcat-connectors/jk/binaries/

34 Recommended Settings for Business Objects Deployments

LDAP server

The following LDAP servers are presented in this section:

• “Microsoft Active Directory” on page 35

• “Sun Java Enterprise System (SunOne) Directory Server” on page 36

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

same machine as a Business Objects node.

Microsoft Active Directory

Environment

Environment details

Microsoft Active Directory Server 2000 SP4 Microsoft Active Directory Server 2003 SP1

There are no specific recommendations in terms of hardware or parameters.

Server Tier Architecture

LDAP server

Recommended Settings for Business Objects Deployments 35

Server Tier Architecture

LDAP server

Sun Java Enterprise System (SunOn e) Directory Server

Environment

Environment details

SunOne Directory Server 5.1 SunOne Directory Server 5.2

Hardware requirements

Hardware component

Disk size 2 GB of free disk space Disk

requirements for directory databases

Recommendation

Use the following recommendations to size the following files (loaded with default indexing and configuration):

• 10,000 user ldif file - 8220215 bytes

• 100,000 user ldif file - 82200215 bytes

• 1,000,000 user ldif file - 822000215 bytes

Entries are of type inetOrgPerson, fully populated without a certificate. Each attribute varies in content, but is fixed in size. The resulting directory size, including all database files and transaction logs for these imports were as follows:

• the 10,000 user ldif file generated files of approximately

80 MB

• the 100,000 user ldif file generated files of

approximately 250 MB

• The 1,000,000 user ldif file generated files of

approximately 2 GB

36 Recommended Settings for Business Objects Deployments

Additional disk requirements

These recommendations are approximate; you must determine how your deployment of the directory impacts the disk requirements generated by eac h of the following elements:

Logging

Size estimates for log files depend on:

• the load on the server

• log types

• the logging level

• log rotation strategy

Logs, particularly audit logs, require an increasing amount of disk space as server load increases. The following strategies may help you handle increasing log file size:

• Depending on the planned future server load, you may plan for extra disk

space to accommodate log files.

• Increase your log disk capacity if you intend to use debug logging.

Consider dedicating disks to logging in high volume situations.

• You may be able to decrease disk requirements by establishing an

efficient log rotation and a higher Rsystem. Use the server’s log rotation capabilities to rotate logs often, and automate the migration of older files on to a less expensive storage medium such as tape or cheaper disk clusters.

Server Tier Architecture

LDAP server

Transaction Logs

Transaction logs are dependent on peak write loads in the directory server. If they write in bursts, allocate more space than if the write load is constant throughout the day.

Changelog Database

The changelog depends on how much write activity there is on the system and what kind of changelog trimming is deployed. Allow extra space during periods of high modification rates.

Backups and LDIF files

Like logging, backups can consume a great deal of disk space. The required space is predictable, since the size of backups is equal to the size of your database files.

Recommended Settings for Business Objects Deployments 37

Server Tier Architecture

LDAP server

LDIF files and backups are generally fixed in size. Plan for cap acity of s everal times your normal database size to accommodate several backups. Migrate backups progressively to cheaper storage.

If you use replication, plan for additional space for initialization LDIF files.

/tmp

On Solaris systems, the db_home directory can be used for cache files on a tmpfs partition. /tmp is part of the filesystem and could be used by a num ber of other applications in addition to the directory server. Plan for sufficient space in this directory, because when memory is low, tmpfs is paged to the disk dedicated to your swap partition.

Miscellaneous

There should be enough extra room for miscellaneous data like scripts for monitoring memory or CPU usage. Allow extra room for normal usage and work performed by system and directory administrators. Allow room for extra information such as the base server installation, the "o=NetscapeRoot" branch, the configuration file overhead for each instance, and overhead for other iPlanet products.

Core files

Allow room for core files, which are stored with the error log. Allow enough space in the {server- A root}/ FT bin/slapd/server directory for a core file, since the directory server stores it there if it crashes during startup.

38 Recommended Settings for Business Objects Deployments

Server Tier Architecture

BusinessObjects Enterprise Server ope rating system

BusinessObjects Enterprise Server operating system

Windows 2000 Server and Advanced Server

Environment

Windows 2000 Server Service Pack 4 Windows 2000 Advanced Server Service Pack 4 Windows 2000 Datacenter Service Pack 4 MDAC 2.8 is required on this operating system. JDK 1.4.2 must be installed, JDK 1.4.2.05 or later recommended

Hardware

Parameters

Hardware component Value

Number of CPU’s 4 Type of CPU xeon PIV 1.5GHz minimum Memory 4GB minimum is recommended Disk (Size) 4GB minimum of free space+ Storage File System Type NTFS Swap Space default Disk (Type) SCSI Network Client to Middle Tier 100 Mbps Network Card Type Ethernet Network Card Number 1

Parameter Value

Index Server Activation Disabled TCP/IP configuration Fixed IP

Recommended Settings for Business Objects Deployments 39

Server Tier Architecture

BusinessObjects Enter pr is e Ser ver operating system

Windows 2003 Server

Environment

Windows 2003 Server Service Pack 1 Windows 2003 WebServer Service Pack 1 Windows 2003 Enterprise Service Pack 1 Windows 2003 Datacenter Service Pack 1 MDAC 2.8 is required on this operating system. JDK 1.4.2 must be installed, JDK 1.4.2.05 or later recommended Acrobat Reader 7.0

Hardware

Hardware component Value

40 Recommended Settings for Business Objects Deployments

Solaris

Environment

Server Tier Architecture

BusinessObjects Enterprise Server ope rating system

Environment

Solaris 8 minimum installation with the following patchs:

• SUNWgzip (The GNU Zip (gzip) compression utility)

• SUNWzlib (The Zip compression library)

• SUNWscpu (Source compatibility)

• SUNWbash (GNU Bourne-Again shell (bash))

• SUNWbcp (SunOS 4.x Binary Compatibility)

• SUNWxcu4 XCU4 utilities

• SUNWxwfnt (W Window System required fonts)

• SUNWxwplt (X Window System platform software)

• SUNWlibC (Sun Workshop Compilers Bundled libC)

• SUNWuiu8 Iconv modules for UTF-8 Locale

• SUNWulcf UTF-8 Locale Environment Common Files

• SUNWmfrun (Motif RunTime Kit)

• SUNWxwice (ICE package)

Note: These patches are the required minimum.

Business Objects also recommends:

• 108528-24 (kernel patch)

• 108434-13 (C++ run-time)

• 109147-26 (linker patch)

• 109778-13 (Misc loc have errors in CTYPE and lv colln monetary)

• 112668-01 (gzip patch)

• 112611-02 (libz patch)

• 110951-04 (tar patch)

• 109324-05 (sh family patch)

• 114059-02 (en_UTF-8 patch)

• 108993-32 (thread, c and other library patch)

Note: Patches 109147-36 through 109147-39 (linker patch) should not be

installed as they generate core dumps in the liblovconvertor .so livbrary. This is a known Sun OS problem.

Recommended Settings for Business Objects Deployments 41

Server Tier Architecture

BusinessObjects Enter pr is e Ser ver operating system

Environment

Solaris 9 minimum installation with the following patchs:

• SUNWgzip (The GNU Zip (gzip) compression utility)

• SUNWzlib (The Zip compression library)

• SUNWscpu (Source compatibility)

• SUNWbash (GNU Bourne-Again shell (bash))

• SUNWbcp (SunOS 4.x Binary Compatibility)

• SUNWxcu4 XCU4 utilities

• SUNWxwfnt (W Window System required fonts)

• SUNWxwplt (X Window System platform software)

• SUNWlibC (Sun Workshop Compilers Bundled libC)

• SUNWuiu8 Iconv modules for UTF-8 Locale

• SUNWulcf UTF-8 Locale Environment Common Files

• SUNWmfrun (Motif RunTime Kit)

• SUNWxwice (ICE package)

Note: These patches are the required minimum.

Business Objects also recommends:

• 108528-24 (kernel patch)

• 112874-16 (libc)

• 111711-06 (C++ run-time)

• 112963-17 (linker patch)

• 115754-02 (zlib patch)

Note: Patches 112963-21 through 112963-21 (linker patch) should not be

installed as they generate core dumps in the liblovconvertor.so livbrary. This is a known Sun OS problem.

42 Recommended Settings for Business Objects Deployments

Server Tier Architecture

BusinessObjects Enterprise Server ope rating system

Environment

Solaris 10 minimum installation with the following patchs:

• SUNWgzip (The GNU Zip (gzip) compression utility)

• SUNWzlib (The Zip compression library)

• SUNWscpu (Source compatibility)

• SUNWbash (GNU Bourne-Again shell (bash))

• SUNWbcp (SunOS 4.x Binary Compatibility)

• SUNWxcu4 XCU4 utilities

• SUNWxwfnt (W Window System required fonts)

• SUNWxwplt (X Window System platform software)

• SUNWlibC (Sun Workshop Compilers Bundled libC)

• SUNWuiu8 Iconv modules for UTF-8 Locale

• SUNWulcf UTF-8 Locale Environment Common Files

• SUNWmfrun (Motif RunTime Kit)

• SUNWxwice (ICE package)

Use J2SE SDK 1.4.2 (1.4.2.02 or later is recommended). bash installed To check the OS version, use the following command:

uname -a

To check the patch level, use the following command:

showrev -p| egrep "108528|108827|108434|109147"

Hardware

Graphical Card Value

Number of CPU’s 4 Type of CPU U-III+ (900Mhz/1GHz minimum) Memory 8 GB recommended minimum Disk (Size) 6.5 GB minimum of free space+ Storage

500 MB for /tmp/ Business Objects recommends 1 disk dedicated to

the system, plus 2 striped disks dedicated to application and user data.

Disk (Type) SCSI

Recommended Settings for Business Objects Deployments 43

Server Tier Architecture

BusinessObjects Enter pr is e Ser ver operating system

Graphical Card Value

File System Type UFS Swap Space 4 GB Network Client to

Middle Tier Network Card Number 1 Network Card Type Ethernet Graphical Card No

Parameters

Parameter Value

Shell /bin/sh or /bin/ksh or bash User account Recommended use of a non-root, dedicated user

user setting (limit, ulimit)

LD_LIBRARY_PATH LD_LIBRARY_PATH should be empty to avoid

PATH PATH should be restricted to /usr/bin to avoid

100Mbps (LAN)

account for Administration tasks.

• data segment unlimited

• file size unlimited

• open file = 1024

• stack size = 8192

• virtual memory unlimited

• cpu time unlimited

conflicts with Business Objects server settings (defined in the MyWebiEnv.sh file).

44 Recommended Settings for Business Objects Deployments

AIX 5L

Environment

Server Tier Architecture

BusinessObjects Enterprise Server ope rating system

Environment

AIX 5L, version 5.2 with the following patches:

• AIX maintenance release 5.2.0.0-05

• bos.rte.libc:5.2.0.60 (libc library)

• Fix realloc_fx.90479.746.000.epkg.Z (size: 3215437 bytes)

• August 2004 C++ Runtime PTF (xlC.aix50.rte 6.0.0.14) or September

2005 C++ Runtime PTF (xlC.aix50.rte:7.0.0.6)

Note: Installing this PTF requires a prior installation of Runtime Level

6.0.0.0.

Note: These patches are the required minimum. Business Objects also

supports more recent patches. AIX 5L, version 5.3, with the following patches:

• AIX maintenance release 5.3.0.0-01

• August 2004 C++ Runtime PTF (xlC.aix50.rte 6.0.0.14) or September

2005 C++ Runtime PTF (xlC.aix50.rte:7.0.0.6)

To verify the patch level for C++ runtime, use the following command:

lslpp -l| grep xlC.aix50.rte

To check the OS level, use the following command:

oslevel -r

bash installed

Recommended Settings for Business Objects Deployments 45

Server Tier Architecture

BusinessObjects Enter pr is e Ser ver operating system

Hardware

Hardware component Value

Number of CPUs 4 Type of CPU Processor: Power4 (1GHz) or Power5 (with AIX

Memory 8 GB recommended minimum Disk (Size) 6.5 GB minimum of free space + storage

Disk (Type) Ultra SCSI striped is recommended File System Type UFS Swap Space 8 GB Network Client to

Middle Tier Network Card Type Ethernet Network Card Number 1

5.2 ML4 or 5.3) Clock rate: 1 GHz+

500 MB for /tmp/ Business Objects recommends 1 disk dedicated to

the system, plus 2 striped disks dedicated to application and user data, and 1 disk for swap.

100MB

46 Recommended Settings for Business Objects Deployments

Parameters

Server Tier Architecture

BusinessObjects Enterprise Server ope rating system

Parameter Value

Shell /bin/sh or /bin/ksh or bash User account Recommended use of a dedicated non-root user account

for Administration tasks. In

user setting

limit,

(

ulimit)

/etc/security/limits, create a user type, then

specify the following settings for the user type (Business Objects recommends leaving settings not mentioned here at the default values):

• data segment unlimited

• file size unlimited

• no files = 2000

• stack size unlimited

• memory unlimited

• cpu time unlimited

Use the following syntax to change these values:

fsize = -1 cpu = -1 data = -1 rss = -1 stack = -1 nofiles = 2000

Note: You must be a root user to modify this file, and you

must reboot the system for changes to be applied. Use

ulimit -a to verify your ulimit settings.

LIBPATH LIBPATH should be empty to avoid conflicts with

BusinessObjects Enterprise server settings (defined in the

MyWebiEnv.sh file).

PATH PATH should be restricted to

sbin/:/usr/ucb:/usr/bin/X11:/sbin

conflicts with BusinessObjects Enterprise server settings (defined in the

JAVA_HOME Do not define

in the application server settings.

AIXTHREAD_ SCOPE

Set the thread scope to the process level (default):

AIXTHREAD_SCOPE=P

MyWebiEnv.sh file).

JAVA_HOME in the AIX environment. Define it

/usr/bin/:/etc/:/usr/

to avoid

Recommended Settings for Business Objects Deployments 47

Server Tier Architecture

BusinessObjects Enter pr is e Ser ver operating system

HP-UX 11i

Environment

HP-UX 11i PA-RISC, version 11.11, with Quality Pack June 2004 (B.11.11.0406.5) and the following patches:

• PHCO_29960 Pthread enhancement and fixes

• PHKL_30288 Thread Abort

• PHKL_28238 VxVM, EMC, Psets&vPar, slpq1, earlyKRS, CDUMP

• PHSS_30966 ld(1) and linker tools cumulative patch

• PHSS_28435 linker startup code / SLLIC ELF support (install after

PHSS_30966)

HP-UX 11i PA-RISC, version 11.23, with:

• Quality Pack September 2004 (B.11.23.0409.3)

• HP-UX Foundation Operating Environment Component (HPUX11i-OE

B.11.23.0409)

Use the J2SE SDK 1.4.2.06 or later.

Note: The following patches must be installed to correctly support JDK

1.4.2_06: PHNE_30367, PHNE_31247. bash installed To check which quality pack is installed, use:

swlist | grep GOLDBASE

To check which patch is installed, use:

swlist -l patch | egrep "PHCO"

Hardware

Hardware component Value

Number of CPU’s 4 Type of CPU rx4640 or rx5670 Memory 8 GB recommended minimum

48 Recommended Settings for Business Objects Deployments

Parameters

Server Tier Architecture

BusinessObjects Enterprise Server ope rating system

Hardware component Value

Disk (Size) 6.5 GB minimum of free space+ Storage

500 MB for /tmp/ Business Objects recommends 1 disk dedicated to

the system, 2 striped disks dedicated to application

and user data and 1 disk for swap. Disk (Type) SCSI Network 100Mbps Network Card Type Ethernet Network Card Number 1 File System Type UFS Swap Space 4 GB

Parameter Value

Shell /bin/sh, /bin/ksh, or bash User account Recommended use of a dedicated user account for

Administration tasks that is not root.

user setting (limit, ulimit)

• data segment: unlimited

• file size: unlimited

• nofiles = 16384

• stack size = 8192

• memory: unlimited

• time: unlimited

SHLIB_PATH

PATH

SHLIB_PATH should be empty to avoid conflicts with

Business Objects server settings (defined in the

MyWebiEnv.sh file).

PATH should be restricted to /usr/bin/:/etc/:/usr/

sbin/:/usr/ucb:/usr/dt/bin:/usr/bin/X11:/ sbin:/usr/local/bin

to avoid conflicts with Business Objects server settings (defined in the

MyWebiEnv.sh file).

Recommended Settings for Business Objects Deployments 49

Server Tier Architecture

BusinessObjects Enter pr is e Ser ver operating system

Kernel parameters

To verify the kernel parameter settings:

1. Login as root.

2. Start sam.

The Configurable Parameters section under Kernel Configuration lists the Kernel parameters.

3. Optionally, use the command kmtune to display the list of kernel

parameters.

Note: Many parameters in the following list are interrelated; changing one

value may automatically change another. The following are examples of possible minimum settings for the kernel parameters on HP-UX 11i. If you have already configured the kernel parameters for your specific deployment, you may choose to leave them at their current values:

Kernel parameter Value

maxusers dbc min pct dbc max pct default disk ir maxfiles maxfiles_lim maxssize (=maxssize_64bit) maxdsiz (= maxdsiz_64bit) maxswapchunks nproc nfile max_thread_proc nkthread npty nstrpty nstrtel shmmax shmseg swapmem on

512 10 10 1 16384 16384 8 MB (x800000) 2 GB (x80000000) (maximum value) 10000 2068 16384 1024 3635 256 256 256 256 MB (x10000000) 32 0

50 Recommended Settings for Business Objects Deployments

Kernel parameter Value

swchunk timeslice

Linux Red Hat Distribution

Environment

RHEL AS for x86, RHEL ES for x86, RHEL WS for x86, version 3.0 update 4 RHEL AS for x86, RHEL ES for x86, RHEL WS for x86, version 4.0, 4.1, 4.2 Windows Manager: KDE & Gnome installed Services to enable/configure for any system user: at, auth, autofs, cron,

gpm, irqbalance, netfs, network, nfs, nfslock, portmap, sendmail, smb, sshd, syslog, sysstat, vsftpd, xinetd

bash installed Windows Manager: KDE & Gnome installed The firewall must be deactivated on the server and not filtering the ports. The NFS server must be enabled and work for any active user. If the machine has only one processor, the default kernel will be the st andard

monoprocessor kernel (both kernels will be available). If the machine has more than 1 CPU or if the hyperthreading option is

activated, the default kernel will be the kernel-smp (both kernels will be available).

Server Tier Architecture

BusinessObjects Enterprise Server ope rating system

4096 10

Hardware

Hardware component Value

Number of CPU’s 4 Type of CPU xeon PIV 1.5G Hz Memory 4 GB recommended minimum Disk (Size) 6.5 GB minimum of free space+ Storage

500 MB for /tmp/ Network 100Mbps Network Card Type Ethernet

Recommended Settings for Business Objects Deployments 51

Server Tier Architecture

BusinessObjects Enter pr is e Ser ver operating system

Hardware component Value

Network Card Number 1 Swap Space 4 GB

Parameters

Parameter Value

Shell /bin/sh, /bin/ksh, or bash User account Recommended use of a dedicated user account for

Administration tasks that is not root.

user setting (limit, ulimit)

• data segment: unlimited

• file size: unlimited

• nofiles = 1024

• pipe size = 8

• stack size = 8192

• memory: unlimited

• time: unlimited

• maximum user processes = 1535

LD_LIBRARY _PATH

PATH

LD_LIBRARY_PATH should be empty within the Unix user account environment to ensure no conflict with XI R2 settings.

PATH should be restricted to /usr/local/bin:/bin:/ usr/bin:/usr/X11R6/bin

environment to ensure no conflict with XI R2 settings.

within the Unix user account

52 Recommended Settings for Business Objects Deployments

Linux SuSE Distribution

Environment

SuSE Linux Enterprise Server for x86 (SLES for x86) version 9.0 SuSE Linux Enterprise Server for x86 (SLES for x86) version 9.0 SP1 Windows Manager: KDE & Gnome installed The following packages:

• XFree86-4.3.99.902-43.22 (XFree86)

• XFree86-libs-4.3.99.902-43.22 (XFree86 Libs)

These packages are available at the following location:

http://www.novell.com/products/linuxpackages/enterpriseserver/i386/ index_group.html

bash installed

Hardware

Server Tier Architecture

BusinessObjects Enterprise Server ope rating system

Hardware component Value

Number of CPU’s 4 Type of CPU xeon PIV 1.5G Hz Memory 4 GB recommended minimum Disk (Size) 6.5 GB minimum of free space + storage, 500 MB

for /tmp/ Network 100Mbps Network Card Type Ethernet Network Card Number 1 Swap Space 4 GB

Recommended Settings for Business Objects Deployments 53

Server Tier Architecture

BusinessObjects Enter pr is e Ser ver operating system

Parameters

Parameter Value

Shell /bin/sh, /bin/ksh, or bash User account Recommended use of a dedicated user account for

Administration tasks that is not root.

user setting (limit, ulimit)

• data segment: unlimited

• file size: unlimited

• nofiles = 1024

• pipe size = 8

• stack size = 8192

• memory: unlimited

• time: unlimited

• maximum user processes = 1535

LD_LIBRARY _PATH

PATH

LD_LIBRARY_PATH should be empty within the Unix user account environment to ensure no conflict with XI R2 settings.

PATH should be restricted to /usr/local/bin:/bin:/ usr/bin:/usr/X11R6/bin

environment to ensure no conflict with BO XI R2 settings.

within the Unix user account

54 Recommended Settings for Business Objects Deployments

Recommended Settings for Business Objects Deployments

Database Tier Architecture

chapter

Database Tier Architecture

Overview

This chapter provides recommendations on the following elements:

• “RDBMS server” on page 56

• “RDBMS client” on page 70

• “OLAP server” on page 75

• “OLAP client” on page 81

Each section is separated into the following sub-sections:

• Environment

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

• Hardware requirements

This section describes the required hardware in terms of CPU, disks, memory and network cards.

• Parameters

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

RDBMS server

This section presents recommendations on the following supported RDBMS servers:

• “Oracle” on page 57

• “IBM DB2 UDB” on page 60

• “IBM Informix Dynamic Server” on page 62

• “IBM Red Brick Decision Server” on page 64

• “Microsoft SQL Server” on page 66

• “Teradata” on page 67

• “Sybase” on page 68

• “MySQL” on page 69

Tip: We strongly recommend that you do not host the database server on the

same machine as a BusinessObjects Enterprise cluster node.

56 Recommended Settings for Business Objects Deployments

Oracle

Environment

Version

OracleServer 9.2.06 Enterprise Edition OracleServer 10.1.0.3 Enterprise Edition For AIX 5L, the following patches are required:

AIX 5L release 5.1 ML01+ IY22854, IY26778, IY28766, IY28949, IY29965, IY30150

http://www-03.ibm.com/servers/eserver/support/

Hardware requiremen ts

Hardware recommendations are divided into Windows and UNIX platforms.

Windows 2000 hardware requirements

Hardware component Value

Number of CPU’s 2 Type of CPU PIII 1.2 GHz

Memory 2GB Disk (Size) 18 GB x 3 Disk (Type)

Note: This specific configuration

of disk controllers is not required. It is an example of how to configure your disks.

Network (middle-tier to database) 100Mbps File System Type NTFS Swap Space default Network Card Type Ethernet Network Card Number 1

Database Tier Architecture

RDBMS server

system bus: 133 Mhz min

SCSI controller #1: Operating system, database server software, paging file

SCSI controller #2: Database server journal files

SCSI controller #3: All other database server datafiles

Additional information is available on the Oracle Technet web site:

http://www.oracle.com/technology/documentation/index.html

Recommended Settings for Business Objects Deployments 57

Database Tier Architecture

RDBMS server

AIX, HP-UX, and Solaris hardware requ ireme nts

Hardware component Value

Number of CPU’s 4 Type of CPU 750 MHz minimum

System bus: 150Mhz min Memory 4 GB Disk (Size) 18 GB x 8 Disk (Type)

Note: This specific

configuration of disk controllers is not required. It is an example of how to configure your disks.

Network (middle-tier to database)

File System Type RAW Swap Space 4GB Network Card Type Ethernet Network Card Number 1

SCSI controller #1: Operating system, database

server software, paging file

SCSI controller #2: Database server journal files

SCSI controller #3: Dedicated to CMS tables

SCSI controller #4: Dedicated to CMS tables

SCSI controller #5: Dedicated to Data source

SCSI controller #6: Dedicated to Data source

SCSI controller #7: Dedicated to Database server

dictionary, undo information and sort space

SCSI controller #8: Dedicated to Database server

dictionary, undo information and sort space

100 Mbps

Additional information is available on the Oracle Technet web site:

http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/ A96167_01/html/pre.htm#sthref104

58 Recommended Settings for Business Objects Deployments

Parameters

Database Tier Architecture

RDBMS server

Parameter Definition Oracle 9

Value

db_block_size db_block_buffers db_file_multiblo

ck_read_count shared_pool_size

log_checkpoint_ interval

Processes

log_buffer sort_area_size TCP/IP Port sga_target pga_aggregate_

target undo_management undo_tablespace

These parameters set the RDBMS cache size

Facilitates the “full table scan”

Storage area for parsed SQL

Accelerates log 10000 n/a

Maximum number of clients

Accelerates log 163840 n/a

183500 n/a 64 n/a

67108864 n/a

3 MB n/a 1521 n/a n/a 384 MB n/a 128 MB

n/a Undo n/a Undo

Oracle 10 value

8192

512

Recommended Settings for Business Objects Deployments 59

Database Tier Architecture

RDBMS server

IBM DB2 UDB

Environment

Version

DB2 UDB version 8.1 with DB Client 8.1 DB2 UDB version 8.2 with DB Client 8.2 DB2 UDB zSeries 8 with DB2 Cient/DB2-Connect 8.2 DB2 UDB zSeries 7 with DB2 Client/DB2-Connect 8.1 DB2 UDB iSeries V5R2 with DB2 Connect 8.1 DB2 UDB iSeries V5R3 with DB2 Connect 8.2 JRE is required to run the DB2 tools. The minimum version of the JRE is

1.1.8. Detailed information at:

http://www-306.ibm.com/software/data/db2/udb/support/

Hardware requirements

Hardware recommendations are divided into Windows and UNIX platforms. Additional information is available at:

http://www-306.ibm.com/software/data/db2/udb/support/?fn=db2v7i6intro.htm

Windows 2000 hardware requirements

Hardware component Value

Number of CPU’s 2 Type of CPU PIII 1.2 GHz

System bus: 133 Mhz min Memory 2GB Disk (Size) 18GB x 3 Disk (Type)

Note: This specific configuration

of disk controllers is not required. It is an example of how to configure your disks.

Network (middle-tier to database) 100Mbps File System Type NTFS

60 Recommended Settings for Business Objects Deployments

SCSI controller #1: Operating system,

database server software, paging file

SCSI controller #2: Database server

journal files

SCSI controller #3: All other database

server datafiles

Database Tier Architecture

Hardware component Value

Swap Space default Network Card Type Ethernet Network Card Number 1

AIX, HP-UX, and Solaris hardware requirements

RDBMS server

Hardware component

Number of CPU’s 4 Type of CPU 750MHz minimum

Memory 4 GB Disk (Size) 18 GB x 8 Disk (Type)

Note: This specific

configuration of disk controllers is not required. It is an example of how to configure your disks.

Network (middle-tier to database)

File System Type RAW Swap Space 4GB Network Card Type Ethernet 1 Gbps Network Card

Number

Value

Type of system bus 150Mhz min

SCSI controller #1: Operating system, database server software, paging file

SCSI controller #2: Database server journal files SCSI controller #3: Dedicated to CMS tables SCSI controller #4: Dedicated to CMS tables SCSI controller #5: Dedicated to Data source SCSI controller #6: Dedicated to Data source SCSI controller #7: Dedicated to Database server

dictionary, undo information and sort space SCSI controller #8: Dedicated to Database server

dictionary, undo information and sort space 100 Mbps

Recommended Settings for Business Objects Deployments 61

Database Tier Architecture

RDBMS server

IBM Informix Dynamic Server

Environment

Version

IBM Informix Dynamic Server 2000 version 9.40 IBM Informix Dynamic Server 2000 version 10.0 IBM Informix Dynamic Server 2000 version 7.31 IBM Informix XPS 8.40 IBM Informix XPS 8.50

Hardware requirements

Hardware recommendations are divided into Windows and UNIX platforms.

Windows 2000 hardware requirements

Hardware component Value

Number of CPU’s 2 Type of CPU PIII 1.2 GHz

Memory 2GB Disk (Size) 18GB x 3 Disk (Type)

Note: This specific configuration

of disk controllers is not required. It is an example of how to configure your disks.

Network (middle-tier to database) 100Mbps File System Type NTFS Swap Space default Network Card Type Ethernet Network Card Number 1

system bus: 133 Mhz min

SCSI controller #1: Operating system, database server software, paging file

SCSI controller #2: Database server journal files

SCSI controller #3: All other database server datafiles

62 Recommended Settings for Business Objects Deployments

Database Tier Architecture

AIX 5L, HP 11i, and Solaris 8 hardware requirements

Hardware component Value

Number of CPU’s 4 Type of CPU 750 MHz minimum

Type of system bus 150Mhz min Memory 4 GB Disk (Size) 18 GB x 8 Disk (Type)

Note: This specific

configuration of disk controllers is not required. It is an example of how to configure your disks.

Network (middle-tier to database)

File System Type RAW Swap Space 4GB Network Card Type Ethernet 1 Gbps Network Card Number 1

SCSI controller #1: Operating system, database

server software, paging file

SCSI controller #2: Database server journal files

SCSI controller #3: Dedicated to CMS tables

SCSI controller #4: Dedicated to CMS tables

SCSI controller #5: Dedicated to Data source

SCSI controller #6: Dedicated to Data source

SCSI controller #7: Dedicated to Database server

dictionary, undo information and sort space

SCSI controller #8: Dedicated to Database server

dictionary, undo information and sort space

100 Mbps

RDBMS server

Recommended Settings for Business Objects Deployments 63

Database Tier Architecture

RDBMS server

IBM Red Brick Decision Server

Environment

Version

IBM Red Brick Decision Server version 6.30

Hardware requirements

Hardware recommendations are divided into Windows and UNIX platforms.

Windows 2000 hardware requirements

Hardware component Value

Number of CPU’s 2 Type of CPU PIII 1.2 GHz

Memory 2GB Disk (Size) 18GB x 3 Disk (Type)

Note: This specific configuration

of disk controllers is not required. It is an example of how to configure your disks.

Network (middle-tier to database) 100Mbps File System Type NTFS Swap Space default Network Card Type Ethernet Network Card Number 1

system bus: 133 Mhz min

SCSI controller #1: Operating system, database server software, paging file

SCSI controller #2: Database server journal files

SCSI controller #3: All other database server datafiles

64 Recommended Settings for Business Objects Deployments

Database Tier Architecture

AIX 5L, HP 11i, and Solaris 8 hardware requirements

Hardware component Value

Number of CPU’s 4 Type of CPU 750 MHz minimum

System bus: 150 Mhz min Memory 4 GB Disk (Size) 18 GB x 8 Disk (Type)

Note: This specific

configuration of disk controllers is not required. It is an example of how to configure your disks.

Network (middle-tier to database)

File System Type RAW Swap Space 4GB Network Card Type Ethernet 1 Gbps Network Card Number 1

SCSI controller #1: Operating system, database

server software, paging file

SCSI controller #2: Database server journal files

SCSI controller #3: Dedicated to CMS tables

SCSI controller #4: Dedicated to CMS tables

SCSI controller #5: Dedicated to Data source

SCSI controller #6: Dedicated to Data source

SCSI controller #7: Dedicated to Database server

dictionary, undo information and sort space

SCSI controller #8: Dedicated to Database server

dictionary, undo information and sort space

100 Mbps

RDBMS server

Recommended Settings for Business Objects Deployments 65

Database Tier Architecture

RDBMS server

Microsoft SQL Server

Environment

Version

MS SQL Server 7.0 SP4 MS SQL Server 2000 SP3a Enterprise Edition MS SQL Server 2000 SP4 Enterprise Edition MS SQL Server 2005 Enterprise Edition

Hardware requirements

Hardware component Value

Number of CPU’s 2 Type of CPU PIII 1.2 GHz

Memory 2 GB Disk (Size) 18 GB x 3 Disk (Type)

Note: This specific configuration

of disk controllers is not required. It is an example of how to configure your disks.

Network (middle-tier to database) 100Mbps File System Type NTFS Swap Space default Network Card Type Ethernet Network Card Number 1

System bus: 133 Mhz min

SCSI controller #1: Operating system, database server software, paging file

SCSI controller #2: Database server journal files

SCSI controller #3: All other database server datafiles

66 Recommended Settings for Business Objects Deployments

Parameters

Parameter Value

Authentication mode SQL Server Authentication Dynamically Configure

SQL Server memory Use a fixed memory size Cannot be activated if “Dynamically Configure

Teradata

Environment

Version

Teradata versions V2R5, V2R5 SP1, V2R6

Windows hardware requirements

Database Tier Architecture

RDBMS server

Cannot be activated if “Use a fixed memory size” is activated.

SQL Server memory” is activated.

Hardware component Value

Number of CPU’s 2 Type of CPU PIII 1.2 GHz

system bus: 133 Mhz min Memory 2GB Disk (Size) 18GB x 3 Disk (Type)

Note: This specific configuration

of disk controllers is not required. It is an example of how to configure your disks.

Network (middle-tier to database) 100Mbps File System Type NTFS Swap Space default Network Card Type Ethernet Network Card Number 1

Recommended Settings for Business Objects Deployments 67

SCSI controller #1: Operating system,

database server software, paging file

SCSI controller #2: Database server

journal files

SCSI controller #3: All other database

server datafiles

Database Tier Architecture

RDBMS server

Sybase

Environment

Version

Sybase Adaptive Server 12.0 with Open Client 12.00 Sybase Adaptive Server 12.5.3 with Sybase ODBC 12.5 (3) Sybase ASE IQ 12.5 with ASIQ ODBC 7.00 Sybase ASE IQ 12.6 with ASIQ ODBC 9.00

Windows hardware requirements

Hardware component Value

Number of CPU’s 2 Type of CPU PIII 1.2 GHz

Memory 2 GB Disk (Size) 18 GB x 3 Disk (Type)

Note: This specific configuration

of disk controllers is not required. It is an example of how to configure your disks.

Network (middle-tier to database) 100Mbps File System Type NTFS Swap Space default Network Card Type Ethernet Network Card Number 1

System bus: 133 Mhz min

SCSI controller #1: Operating system, database server software, paging file

SCSI controller #2: Database server journal files

SCSI controller #3: All other database server datafi les

68 Recommended Settings for Business Objects Deployments

MySQL

Environment

Version

MySQL 4.1.9 with MySQL AB JDBC Connector or C API

Windows hardware requirements

Hardware component Value

Number of CPU’s 2 Type of CPU PIII 1.2 GHz

Memory 2 GB Disk (Size) 18 GB x 3 Disk (Type)

Note: This specific configuration

of disk controllers is not required. It is an example of how to configure your disks.

Network (middle-tier to database) 100Mbps File System Type NTFS Swap Space default Network Card Type Ethernet Network Card Number 1

Database Tier Architecture

RDBMS server

System bus: 133 Mhz min

SCSI controller #1: Operating system,

database server software, paging file

SCSI controller #2: Database server

journal files

SCSI controller #3: All other database

server datafiles

Recommended Settings for Business Objects Deployments 69

Database Tier Architecture

RDBMS client

This section presents recommendations on the following supported RDBMS clients:

• “ODBC” on page 70

• “Oracle Net” on page 71

• “DB2 Client” on page 72

• “Informix Connect” on page 72

• “Red Brick ODBC” on page 73

• “Teradata ODBC” on page 73

• “Sybase Open Client” on page 74

Business Objects supports RDBMS clients in 32-bit mode only.

ODBC

Environment

Version

ODBC Driver MDAC (GA 09/05) for MS SQL Server 2005 ODBC Driver MDAC 2.8 RTM for MS SQL Server 2000 SP3a & MS Access

2003 ODBC Driver MDAC 2.7 SP1 for MS SQL Server 7.0 SP4 OLEDB Provider MDAC 2.8 RTM for SQL Server 2000 SP3a OLEDB Provider MDAC 2.7 SP1 for MS SQL Server 7.0 SP4

Parameters

Use default parameters for this configuration.

70 Recommended Settings for Business Objects Deployments

Oracle Net

Environment

Parameters

Database Tier Architecture

RDBMS client

Version

Oracle Net9 version 9.2.0.6 Oracle Net 10.1.0.3

Note: The p4153257 patch is required if you want to install 10.1.0.3 with

RHEL 4. Oracle Net 10g R2 On UNIX platforms, install the

shared library.

Note: Oracle Net 10.x is supported on AIX 5.3 but the Oracle installer was

not corrected properly to recognize this version. You need to add the following parameter while executing the Oracle installer on AIX 5.3:

./runInstaller -ignoreSysPrereqs

You need to set the NLS_LANG environment variable as follows:

language_territory.charset

where:

checkoracle utility to create a link to the

this argument specifies

language the language used for Oracle messages , day names , and

month names. Each supported language has a unique name. The language argument specifies default values for the territory and character set arguments, so either (or both) territory or charset can be omitted. If language is not specified, the value defaults to American.

territory the default date format and decimal character used for

numbers. Each supported territory has a unique name. If territory is not specified, the value defaults to America.

charset the character set used by the client application. Each

supported character set has a unique acronym. Each language is associated with a default character set.

For more information, refer to:

http://www.oracle.com/technology/index.html

Recommended Settings for Business Objects Deployments 71

Database Tier Architecture

RDBMS client

DB2 Client

Environment

Version

DB2 Client 8.2 DB2 Client 8.1 Fix Pack 3

Hardware requirements

For more information, refer to:

http://www-306.ibm.com/software/data/db2/udb/support/?fn=db2v7i6intro.htm

Parameters

Use default parameters for this configuration.

Informix Connect

Environment

Version

Informix Connect SDK 2.81 Informix Connect SDK 2.90 tc1

Hardware requirements

There are no specific hardware requirements related to this configuration.

Parameters

Use default parameters for this configuration.

72 Recommended Settings for Business Objects Deployments

Red Brick ODBC

Environment

Version

Red Brick ODBC version 6

Hardware requiremen ts

There are no specific hardware requirements related to this configuration.

Parameters

Use default parameters for this configuration.

Teradata ODBC

Environment

Version

Teradata ODBC 3.03 Teradata ODBC 3.04 Teradata ODBC 3.04.01

Database Tier Architecture

RDBMS client

Hardware requiremen ts

There are no specific hardware requirements related to this configuration.

Parameters

Use default parameters for this configuration.

Recommended Settings for Business Objects Deployments 73

Database Tier Architecture

RDBMS client

Sybase Open Client

Environment

Version

Sybase Open Client 12.5.3 Sybase Open Client 12.0 ASIQ ODBC 9.0 with Sybase ASE IQ 12.6 ASIQ ODBC 7.0 with Sybase ASE IQ 12.5

Hardware requirements

There are no specific hardware requirements related to this configuration.

Parameters

Use default parameters for this configuration.

74 Recommended Settings for Business Objects Deployments

OLAP server

This section presents recommendations on the following supported OLAP servers:

• “SAP BW” on page 75

• “Microsoft OLAP” on page 76

• “Essbase” on page 77

• “IBM DB2 OLAP” on page79

SAP BW

Environment

Version

SAP BW 2.0b, patch 25 SAP BW 2.1c, patch 17 SAP BW 3.0b patch 10

Database Tier Architecture

OLAP server

Hardware requiremen ts

There are no specific hardware requirements related to this configuration.

Parameters

Use default parameters for this configuration.

Recommended Settings for Business Objects Deployments 75

Database Tier Architecture

OLAP server

Microsoft OLAP

Environment

Version

MS SQL Server Analysis Services 2005 MS SQL Server Analysis Services 2000 SP3

Hardware requirements

Hardware component Value

Number of CPU’s 2 Type of CPU PIII 1.2 GHz Memory 2GB Disk (Size) 18GB x 3 Disk (Type)

Note: This specific configuration

of disk controllers is not required. It is an example of how to configure your disks.

Network (middle-tier to database) 100Mbps File System Type NTFS Swap Space default Network Card Type Ethernet Network Card Number 1

SCSI controller #1: Operating system, database server software, paging file

SCSI controller #2: Database server journal files

SCSI controller #3: All other database server datafi les

Parameters

Use default parameters for this configuration.

76 Recommended Settings for Business Objects Deployments

Essbase

Environment

Version

ESSBASE 7.0 ESSBASE 7.1

Hardware requiremen ts

Hardware recommendations are divided into Windows and UNIX platforms.

Windows 2000 hardware requirements

Hardware component Value

Number of CPU’s 2 Type of CPU PIII 1.2 GHz Memory 2 GB Disk (Size) 18 GB x 3 Disk (Type)

Note: This specific configuration

of disk controllers is not required. It is an example of how to configure your disks.

Network (middle-tier to database) 100Mbps File System Type NTFS Swap Space default Network Card Type Ethernet Network Card Number 1

Database Tier Architecture

OLAP server

SCSI controller #1: Operating system, database server software, paging file

SCSI controller #2: Database server journal files

SCSI controller #3: All other database server datafiles

Recommended Settings for Business Objects Deployments 77

Database Tier Architecture

OLAP server

UNIX hardware requirements

Hardware component Value

Number of CPU’s 4 Type of CPU 750 MHz minimum

System bus: 150 Mhz minimum Memory 4 GB Disk (Size) 18GB x 8 Disk (Type)

Note: This specific

configuration of disk controllers is not required. It is an example of how to configure your disks.

Network (middle-tier to database)

File System Type RAW Swap Space 4 GB Network Card Type Ethernet 1Gbps

SCSI controller #1: Operating system, database

server software, paging file

SCSI controller #2: Database server journal files

SCSI controller #3: Dedicated to CMS tables

SCSI controller #4: Dedicated to CMS tables

SCSI controller #5: Dedicated to Data source

SCSI controller #6: Dedicated to Data source

SCSI controller #7 and #8: Dedicated to

Database server dictionary , undo information and

sort space

100 Mbps

Parameters

Parameter Value

AGENTDELAY 35 AGENTTHREADS 55 SERVERTHREADS 60 __SM__BUFFERED_IO TRUE

78 Recommended Settings for Business Objects Deployments

IBM DB2 OLAP

Environment

Version

IBM DB2 OLAP 8.13 with IBM DB2 OLAP API 8.1 IBM DB2 OLAP 8.2

Hardware requiremen ts

Hardware recommendations are divided into Windows and UNIX platforms.

Windows 2000 hardware requirements

Hardware component Value

Number of CPU’s 2 Type of CPU PIII 1.2 GHz Memory 2 GB Disk (Size) 18 GB x 3 Disk (Type)

Note: This specific configuration

of disk controllers is not required. It is an example of how to configure your disks.

Network (middle-tier to database) 100 Mbps File System Type NTFS Swap Space default Network Card Type Ethernet Network Card Number 1

Database Tier Architecture

OLAP server

SCSI controller #1: Operating system, database server software, paging file

SCSI controller #2: Database server journal files

SCSI controller #3: All other database server datafiles

Recommended Settings for Business Objects Deployments 79

Database Tier Architecture

OLAP server

AIX, HP-UX, Solaris hardware requirements

Hardware component Value

Number of CPU’s 4 Type of CPU 750 MHz minimum

System bus: 150 Mhz minimum Memory 4 GB Disk (Size) 18 GB x 8 Disk (Type)

Note: This specific

configuration of disk controllers is not required. It is an example of how to configure your disks.

Network (middle-tier to database)

File System Type RAW Swap Space 4 GB Network Card Type Ethernet 1 Gbps

SCSI controller #1: Operating system, database

server software, paging file

SCSI controller #2: Database server journal files

SCSI controller #3: Dedicated to CMS tables

SCSI controller #4: Dedicated to CMS tables

SCSI controller #5: Dedicated to Data source

SCSI controller #6: Dedicated to Data source

SCSI controller #7 and #8: Dedicated to

Database server dictionary , undo information and

sort space

100 Mbps

Parameters

Use default parameters for this configuration.

80 Recommended Settings for Business Objects Deployments

OLAP client

This section presents recommendations on the following supported OLAP clients:

• “SAP BW” on page 81

• “Microsoft OLAP” on page 81

• “Essbase” on page 82

• “IBM DB2 OLAP” on page82

SAP BW

Environment

Version

SAP BW front end 3.1 SAP BW front end 3.5

Hardware requiremen ts

There are no specific hardware requirements related to this configuration.

Database Tier Architecture

OLAP client

Parameters

Use default parameters for this configuration.

Microsoft OLAP

Environment

Version

MS SQL Server OLAP Client 2000 SP3 with MDAC 2.7 MS SQL Server OLAP Client 7 version 2005

Hardware requiremen ts

There are no specific hardware requirements related to this configuration.

Parameters

Use default parameters for this configuration.

Recommended Settings for Business Objects Deployments 81

Database Tier Architecture

OLAP client

Essbase

Environment

Version

Essbase 7.0 Essbase middleware run-time must be installed. Essbase middleware

versions are not backwards compatible.

Hardware requirements

There are no specific hardware requirements related to this configuration.

Parameters

Use default parameters for this configuration.

IBM DB2 OLAP

Environment

Version

IBM DB2 OLAP 8.2 IBM DB2 OLAP 8.1.3

Hardware requirements

There are no specific hardware requirements related to this configuration.

Parameters

Use default parameters for this configuration.

82 Recommended Settings for Business Objects Deployments

Recommended Settings for Business Objects Deployments

Network Recommendations

chapter

Network Recommendations

Network requirements

LAN (Local Area Network) requirements

Parameter Recommended value

Network speed 100 Mbps Duplexing Full duplex Latency time < 10 ms

WAN (Wide Area Network) requirements

Network type Parameter Value

WAN Bandwidth

Direct RAS Asymmetric bandwidth 56 kbps / 33 kbps

VPN over ADSL Asymmetric bandwidth 512 Kbps/128 kbps

• 128 Kbps - 300 ms

• 1 Mbps - 200 ms

• 8 Mbps - 60 ms

120 ms

70 ms

Note: You can customize your deployment to reduce network transfer

volume and the number of network round-trips on low-bandwidth, highlatency networks.

For example, you can:

• configure the "expires" header on the web server for static content to

avoid "cache check" round-trips

• enable web server HTTP compression

84 Recommended Settings for Business Objects Deployments

Business Objects Information Resources

appendix

Business Objects Information Resources

Documentation and infor m at i on services

Documentation and informatio n servi ces

Business Objects offers a full documentation set covering its products and their deployment. Additional support and services are also available to help maximize the return on your business intelligence investment. The following sections detail where to get Business Objects documentation and how to use the resources at Business Objects to meet your needs for technical support, education, and consulting.

Documentation

You can find answers to your questions on how to install, configure, deploy, and use Business Objects products from the documentation.

What’s in the documentation set?

View or download the Business Objects Documentation Roadmap, available with the product documentation at http://www.businessobjects.com/support/.

The Documentation Roadmap references all Business Objects guides and lets you see at a glance what information is available, from where, and in what format.

Where is the documentation?

You can access electronic documentation at any time from the product interface, the web, or from your product CD.

Documentation from the products

Online help and guides in Adobe PDF format are available from the product Help menus. Where only online help is provided, the online help file contains the entire contents of the PDF version of the guide.

Documentation on the web

The full electronic documentation set is available to customers on the web from support web site at: http://www.businessobjects.com/support/.

Documentation on the product CD

Look in the docs directory of your product CD for versions of guides in Adobe PDF format.

86 Recommended Settings for Business Objects Deployments

Business Ob j ects Infor m ation Resourc es

Customer support, cons ul t in g and training

Send us your feedback

Do you have a suggestion on how we can improve our documentation? Is there something you particularly like or have found useful? Drop us a line, and we will do our best to ensure that your suggestion is included in the next release of our documentation: documentation@businessobjects.com.

Note: If your issue concerns a Business Objects product and not the

documentation, please contact our Customer Support experts. For information about Customer Support visit: http://www.businessobjects.com/

support/.

Customer support, consulti ng and trai ning

A global network of Business Objects technology experts provides customer support, education, and consulting to ensure maximum business intelligence benefit to your business.

How can we support you?

Business Objects offers customer support plans to best suit the size and requirements of your deployment. We operate customer support centers in the following countries:

• USA

• Australia

• Canada

• United Kingdom

• Japan

Online Customer Support

The Business Objects Customer Support web site contains information about Customer Support programs and services. It also has links to a wide range of technical information including knowledgebase articles, downloads, and support forums.

http://www.businessobjects.com/support/

Recommended Settings for Business Objects Deployments 87

Business Objects Information Resources

Customer support, consulting and training

Looking for the best deployment solution for your company ?

Business Objects consultants can accompany you from the initial analysis stage to the delivery of your deployment project. Expertise is available in relational and multidimensional databases, in connectivities, database design tools, customized embedding technology, and more.

For more information, contact your local sales office, or contact us at:

http://www.businessobjects.com/services/consulting/

Looking for training options?

From traditional classroom learning to targeted e-learning seminars, we can offer a training package to suit your learning needs and preferred learning style. Find more information on the Business Objects Education web site:

http://www.businessobjects.com/services/training

88 Recommended Settings for Business Objects Deployments

Useful addresses at a glance

Address Content

Business Objects product information

http://www.businessobjects.com

Product documentation

http://www.businessobjects.com/ support

Business Objects Documentation mailbox

documentation@businessobjects.com

Online Customer Support

http://www.businessobjects.com/ support/

Business Objects Consulting Services

http://www.businessobjects.com/ services/consulting/

Business Objects Education Services

http://www.businessobjects.com/ services/training

Business Ob j ects Infor m ation Resourc es

Useful addresses at a glance

Information about the full range of Business Objects products.

Business Objects product documentation, including the Business Objects Documentation Roadmap.

Send us feedback or questions about documentation.

Information on Customer Support programs, as well as links to technical articles, downloads, and online forums.

Information on how Business Objects can help maximize your business intelligence investment.

Information on Business Objects training options and modules.

Recommended Settings for Business Objects Deployments 89

Business Objects Information Resources

Useful addresses at a gl ance

90 Recommended Settings for Business Objects Deployments

Index

AIX 5L 45 Apache 20

connecting with Tomc at 34

applicat i on servers

Microsoft Internet Information Server 25 Oracle 33 SAP 33 Sun Java System (formerl y SunOne) 29 Tomcat 26 WebLogic 31 Websphere 30

browsers

FireFox 15 Internet Explorer 14 Mozilla 15 Safari 15

Business Objects

consulting services 88, 89 support services 87 training services 88, 89, 89

consultants, Busines s O bj ec t s 88 customer support 87

DB2 Client 72 documentation

feedback on 87 on product C D 86 on the web 86 roadmap 86

education. See training Essbase

OLAP client 82 OLAP server 77

feedback, on docum ent a tion 87 FireFox 15

HP-UX 11i 48

IBM DB2 OLAP

OLAP client 82

OLAP server 79 IBM DB2 UDB 60 IBM HTTP Server 23 IBM Informix Dynamic Server 62 IBM Red Brick Decision Server 64 information resources 85, 86 Informix Connect 72 Internet Explorer 14

LAN requirements 84 LDAP servers 35

Microsoft Active Directory 35

Sun Java Enterprise (SunOne) 36 Linux Red Hat Distribution 51 Linux SuSE Distribution 53

Microsoft Active Directo ry 35 Microsoft Internet Information Server 19, 25

Recommended Settings for Business Objects Deployments 91

Index

Microsoft OLAP

OLAP client 81

OLAP server 76 Microsoft SQL Server 66 Mozilla 15 MySQL 69

ODBC 70 OLAP client

Essbase 82

IBM DB2 OLAP 82

Microsoft OLAP 81

SAP BW 81 OLAP server

Essbase 77

IBM DB2 OLAP 79

Microsoft OLAP 76

SAP BW 75 Online Customer Support 87 operating systems

AIX 5L 45

HP-UX 11i 48

Linux Red Hat Distribu tion 51

Linux SuSE Distribution 53

Solaris 41

Windows 2000 and Advanced Servers 39

Windows 2000 Professi onal 11

Windows 2003 Server 40

Windows XP Profession al 12 Oracle 33, 57 Oracle HTTP Server 24 Oracle Net 71

RDBMS client

DB2 Client 72

Informix Connect 72

ODBC 70

Oracle Net 71

Red Brick ODBC 73

Sybase Open Client 74

Teradata ODBC 73 RDBMS server

IBM DB2 UDB 60 IBM Informix Dynamic Server 62 IBM Red Brick Decision Server 64 Microsoft SQL Server 66 My SQL 69 Oracle 57 Sybase 68

Teradata 67 Red Brick ODBC 73 resources 85, 86

Safari 15 SAP 33 SAP BW

OLAP client 81

OLAP server 75 Solaris 41 Sun Java Enterprise System (SunOne) Directory

Server 36 Sun Java System (formerl y SunOne) 29 support

customer 87 locations 87 technical 87

web site 87 Sybase 68 Sybase Open Client 74

technical support 87 Teradata 67 Teradata ODBC 73 Tomcat 26

connecting with Apache 34 training, on Business Objects products 88

WAN requirements 84 web

customer support 87

getting documentation via 86

useful addresses 89 web servers

92 Recommended Settings for Business Objects Deployments

Apache 20 IBM HTTP Server 23 Microsoft Internet Information Server 19 Oracle HTTP Server 24 WebLogic Web Serve r 23

web sites

support 87

training 88 WebLogic 31 WebLogic Web Server 23 WebSphere 30 Windows 2000 and Advanced Servers 39 Windows 2000 Pro fe ss io nal 11 Windows 2003 Ser ver 40 Windows XP Professional 12

Index

Recommended Settings for Business Objects Deployments 93

Index

94 Recommended Settings for Business Objects Deployments

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

Specifications and Main Features

Frequently Asked Questions

User Manual

Contents

Introduction

Overview

Purpose of this docum ent

Client Tier Architecture

Overview

Desktop operating systems on 2-tier clients

Browsers on 3-tier clients

Server Tier Architecture

Overview

Web servers

Application servers

Application server and w eb s erv er connectors

LDAP server

BusinessObjects Enterprise Server ope rating system

Database Tier Architecture

Overview

RDBMS server

RDBMS client

OLAP server

OLAP client

Network Recommendations

Network requirements

Business Objects Information Resources

Documentation and infor m at i on services

Documentation

Customer support, cons ul t in g and training

Useful addresses at a glance

Index