Server hardware and software requirements

Table 4 contains a summary of the system requirements of the server components of DB2 OLAP Server and DB2 OLAP Integration Server:

Table 4. Summary of server requirements
Server Operating Systems Supported Versions
Microsoft Windows

See Table 5 for more details.

Pentium(R) or later computers for the following versions of Windows:

  • Windows 2000, SP3 or later
  • Windows 2003
  • Windows XP (for DB2 OLAP Server Personal Edition, and DB2 OLAP Integration Server, only)
Solaris Operating System

See Table 6 for more details.

Sun SPARC or ULTRASPARC computers for Sun Solaris 8 and Sun Solaris 9 (Sun OS 5.8 and 5.9)
AIX(R)

See Table 7 for more details.

PowerPC(R) computers, including RS/6000(R) for AIX 5L(TM) (V5.1 and V5.2).

AIX 5L ML1 and ML4 are not supported.

HP-UX

See Table 8 for more details.

HP PA-RISC for HP-UX 11.0 and 11i

On HP-UX, DB2 OLAP Integration Server is a 32-bit application.

Linux(TM)

See Table 9 for more details.

Intel(TM) computers for Red Hat Linux AS 2.1

Windows server requirements

DB2 OLAP Server for Windows platforms requires a system that meets specific requirements. These requirements are described in Table 5.

Table 5. Windows system requirements
Component Requirements
Microprocessor Pentium or higher
RAM 64 MB or greater

Member Load formula for DB2 OLAP Integration Server: 10 MB + (700 Bytes x number of members)

Microsoft Windows version
  • Windows XP (for DB2 OLAP Server Personal Edition, and DB2 OLAP Integration Server, only)
  • Windows 2003
  • Windows 2000, SP3 and later
Disk space For DB2 OLAP Server, approximately 260 MB for the server software and the sample applications.

For DB2 OLAP Integration Server:

  • 105 MB total (without Hybrid Analysis or Unicode sample application)
  • 125 MB total (after Hybrid Analysis sample data is loaded)
  • 155 MB total (after Hybrid Analysis and Unicode sample data is loaded)

105 to 200 MB for the documentation, depending on your language

11 MB for DataDirect ODBC drivers and associated documentation

Network protocol TCP/IP
Java platform For DB2 OLAP Server and DB2 OLAP Integration Server: Java Runtime Environment version 1.4.1 (installed by default)

Solaris Operating System server requirements

DB2 OLAP server for the Solaris Operating System requires a system with the minimal hardware and software requirements shown in Table 6.

Table 6. Solaris system requirements
Component Requirement
Server platform Sun SPARC or ULTRASPARC machines
Solaris Operating System version Sun Solaris Operating System 8 and 9 (SUN OS 5.8, and 5.9)
RAM For DB2 OLAP Server: 128 MB RAM (256 or more MB recommended, especially for large databases)

For DB2 OLAP Integration Server:

  • 256 MB for the server software
  • The minimum ulimit settings are: Stack 50 MB; Data 100 MB; Memory 100 MB
  • Member Load formula: 50 MB + (700 Bytes x number of members)
Swap space At least two times the amount of physical memory is recommended when physical memory is less than .5 GB. Contact your system administrator or hardware vendor for optimum swap configuration.
Disk space For DB2 OLAP Server: 306 MB:
  • 188 MB for server software
  • 118 MB for sample applications

For DB2 OLAP Integration Server:

  • 105 MB total (without Hybrid Analysis or Unicode sample application)
  • 125 MB total (after Hybrid Analysis sample data is loaded)
  • 155 MB total (after Hybrid Analysis and Unicode sample data is loaded)

11 MB for DataDirect ODBC drivers and associated documentation

Network protocol TCP/IP (included with Solaris)
Thread type POSIX Kernel Threads (included with Solaris)
Java platform For DB2 OLAP Server and DB2 OLAP Integration Server: Java Runtime Environment version 1.4.1 (installed by default)

AIX server requirements

The OLAP server for AIX requires a system with the minimal hardware and software requirements shown in Table 7.

Table 7. AIX system requirements
Component Requirement
Server platform RS 6000 PowerPC machines
AIX version AIX 5L (V5.1 and AIX V5.2 ), excluding ML1 and ML4
RAM For DB2 OLAP Server: 128 MB RAM (256 or more MB recommended) Larger databases have greater memory requirements.

For DB2 OLAP Integration Server

  • 256 MB for the server software
  • The minimum ulimit settings are: Stack 50 MB; Data 100 MB; Memory 100 MB
  • Member Load formula: 50 MB + (700 Bytes x number of members)
Swap space At least two times the amount of physical memory is recommended when physical memory is less than .5 GB. Contact your system administrator or hardware vendor for optimum swap configuration.
Disk space For DB2 OLAP Server: 310 MB:
  • 192 MB for server software
  • 118 MB for sample applications

For DB2 OLAP Integration Server:

  • 105 MB total (without Hybrid Analysis or Unicode sample application)
  • 125 MB total (after Hybrid Analysis sample data is loaded)
  • 155 MB total (after Hybrid Analysis and Unicode sample data is loaded)

11 MB for DataDirect ODBC drivers and associated documentation

Network protocol TCP/IP (included with AIX)
Thread type POSIX Kernel Threads (included with AIX)
Java platform For DB2 OLAP Server: Java Runtime Environment version 1.4.1

For DB2 OLAP Integration Server: Java Runtime Environment version 1.3.1 (installed by default)

HP-UX server requirements

The OLAP server for HP-UX requires a system with the minimal hardware and software requirements shown in Table 8.

Table 8. HP-UX system requirements
Component Requirement
Server platform PA-RISC machines
HP-UX version 11.0 and 11i
RAM For DB2 OLAP Server: 128 MB RAM (256 or more MB recommended) Larger databases have greater memory requirements.

For DB2 OLAP Integration Server

  • 256 MB for the server software
  • The minimum ulimit settings are: Stack 50 MB; Data 100 MB; Memory 100 MB
  • Member Load formula: 50 MB + (700 Bytes x number of members)
Swap space At least two times the amount of physical memory is recommended when physical memory is less than 0.5 GB (500 MB). Contact your system administrator or hardware vendor for optimum swap configuration.
Disk space For DB2 OLAP Server: 665 MB
  • 600 MB for server software
  • 65 MB for sample applications as shipped

For DB2 OLAP Integration Server:

  • 105 MB total (without Hybrid Analysis or Unicode sample application)
  • 125 MB total (after Hybrid Analysis sample data is loaded)
  • 155 MB total (after Hybrid Analysis and Unicode sample data is loaded)

11 MB for DataDirect ODBC drivers and associated documentation

Network protocol TCP/IP (included with HP-UX)
Thread type POSIX Kernel Threads (included with HP-UX)
Java platform For DB2 OLAP Server and DB2 OLAP Integration Server: Java Runtime Environment version 1.4.1 (installed by default)

Linux server requirements

The OLAP server for Linux requires a system with the minimal hardware and software requirements shown in Table 9.

Table 9. Linux system requirements
Component Requirement
Server platform Intel computers
Linux version Red Hat Enterprise Linux AS 2.1 for Intel Microprocessor based computers
RAM For DB2 OLAP Server: 128 MB RAM (256 or more MB recommended) Larger databases have greater memory requirements.

For DB2 OLAP Integration Server

  • 256 MB for the server software
  • The minimum ulimit settings are: Stack 50 MB; Data 100 MB; Memory 100 MB
  • Member Load formula: 50 MB + (700 Bytes x number of members)
Swap space At least two times the amount of physical memory is recommended when physical memory is less than 0.5 GB (500 MB). Contact your system administrator or hardware vendor for optimum swap configuration.
Disk space For DB2 OLAP Server: 375 MB
  • 310 MB for server software
  • 65 MB for sample applications as shipped

For DB2 OLAP Integration Server:

  • 105 MB total (without Hybrid Analysis or Unicode sample application)
  • 125 MB total (after Hybrid Analysis sample data is loaded)
  • 155 MB total (after Hybrid Analysis and Unicode sample data is loaded)

11 MB for DataDirect ODBC drivers and associated documentation

Network protocol TCP/IP (included with Linux)
Thread type POSIX Kernel Threads (included with Linux)
Java platform For DB2 OLAP Server and DB2 OLAP Integration Server: Java Runtime Environment version 1.4.1 (installed by default)