IBM Information Server Version 8.0.1 system requirements

System requirements (Windows)

Before you install IBM Information Server in a Microsoft^® Windows^® environment, ensure that your computer meets the hardware and software requirements for the product modules and components that you want to install.

Platform requirements (Windows)

The client layer is supported on 32-bit versions of the following operating systems:

• Windows XP Service Pack 2
• Windows Vista
• Windows Server 2003 Service Pack 1 or Service Pack 2

Note: To use more than 4 GB of RAM, Windows Server 2003 Enterprise Edition with Service Pack 1 or Windows Server 2003 Datacenter Edition with Service Pack 1 is required.

For information about support for IBM software products running in a VMware environment, go to http://www.ibm.com/support/docview.wss?&uid=wws1e333ce0912f7b152852571f60074d175.

Client software requirements (Windows)

Ensure that your computer meets the client software requirements before you install the client layer.

IBM Information Server Web console

Microsoft Internet Explorer 6, Service Pack 2, or Microsoft Internet Explorer 7 is required for Web clients such as the Web console.

IBM WebSphere MetaBrokers and bridges

The following software must be installed on the computer where you install the clients before you install IBM WebSphere^® MetaBrokers and bridges. Some bridges might have additional requirements.

• Microsoft XML Core Services (MSXML) 4.0
  http://www.microsoft.com/downloads/details.aspx?FamilyID=3144b72b-b4f2-46da-b4b6-
  c5d7485f2b42&DisplayLang=en
• Depending on how you want to use the WebSphere MetaBrokers and bridges, you must install one of the following clients:
  • The IBM WebSphere DataStage^® and QualityStage^TM client must be installed on the same computer on which you install WebSphere MetaBrokers and bridges with IBM WebSphere DataStage.
  • IBM Rational^® Data Architect must be installed if you want to use WebSphere MetaBrokers and bridges with Rational Data Architect. You must also install the IBM Rational Data Architect MetaBroker^® when you install WebSphere MetaBrokers and bridges.
• A required component for WebSphere MetaBrokers and bridges is installed with the following clients, so at least one of the following clients must be installed on the computer to ensure that WebSphere MetaBrokers and bridges function properly:
  • WebSphere DataStage or WebSphere QualityStage
  • IBM WebSphere Information Analyzer
  • IBM WebSphere Information Services Director

Metadata repository and WebSphere Information Analyzer analysis database software requirements (Windows)

The following database servers are supported for use with the metadata repository:

• IBM DB2^® Enterprise Server Edition Version 9.1
• Microsoft SQL Server 2005 Enterprise Edition
• Oracle 10g Release 2

Note: The Oracle 10g Release 2 Advanced Security option is not supported.

Domain software requirements (Windows)

WebSphere Application Server, Version 6.0.2, Fix Pack 11 or later 6.0.2 fix packs, is required to host WebSphere Metadata Server. When you install the suite, you can install the application server, or you can use a preexisting installation.

If WebSphere Application Server is already installed, you must use a dedicated profile with the server name of server1.

Note: WebSphere Application Server Network Deployment and Extended Deployment are not supported.

Engine software requirements (Windows)

For the transform feature of the parallel canvas to function properly, a C++ compiler must be installed on the computer where you install the engine before you install the IBM Information Server suite. The parallel canvas requires that the compiler and SDK be installed in their default locations. Specify the compiler settings for each project. The following compilers are supported on Windows:

• Microsoft Visual C++ .NET 2003
  This compiler is available on Microsoft Developer Network library releases. You must change the APT_COMPILEOPT and APT_LINKOPT environment variables for this compiler after you install the suite.
  1. Run the Administrator for DataStage and QualityStage.
  2. Select Project > Properties > Environment.
  3. Edit the value field of Parallel > Compiler > APT_COMPILEOPT.
  4. Remove " -W/Zc:wchar_t-" from the end of the existing setting.
  5. Edit the value field of Parallel > Compiler > APT_LINKOPT.
  6. Remove " -W/Zc:wchar_t-" from the end of the existing setting.
• Microsoft Visual Studio 2005 Professional Edition C++
  This compiler is available for purchase from Microsoft. This compiler is the default compiler for the transform operator. No additional changes are required to run the parallel engine transforms when this compiler is installed before you install IBM Information Server.
• Microsoft Visual Studio .NET 2005 Express Edition C++
  This compiler is a free version of the .NET 2005 compiler with reduced functionality.
  You must also download the Microsoft Platform SDK for Microsoft Visual C++ 2005 Express for transforms to work. Download the compiler and the SDK from http://www.microsoft.com/express/.
  Before you use the Microsoft Visual Studio .NET 2005 Express Edition C++ compiler, you must update several environment variables to enable the compiler to find the SDK library and include files.
  1. From the control panel, select System > Advanced > Environment Variables > System variables.
  2. Set the LIB variable to the location of the lib directory for the SDK. A typical location is C:\Program Files\Microsoft Platform SDK for Windows Server 2003 R2\Lib.
  3. Set the INCLUDE variable to the location of the include directory for the SDK. A typical location is C:\Program Files\Microsoft Platform SDK for Windows Server 2003 R2\Include.
  4. Save the settings and restart the computer.

Documentation software requirements (Windows)

To access the PDF documentation that is installed with IBM Information Server, you must have Adobe^® Acrobat or a comparable PDF reader installed.

To access help and other topics in the information center, which is installed in the domain layer, you must have one of the following supported Web browsers configured as your default browser:

• Microsoft Internet Explorer 6 or Microsoft Internet Explorer 7
• Mozilla Firefox Version 1.7 or 2.0

Networking requirements (Windows)

The client, repository, domain, and engine layers must be able to communicate with each other over the network.

Memory requirements (Windows)

• The minimum amount of memory for installing the IBM Information Server client layer is 2 GB.
• The minimum amount of memory for installing the IBM Information Server domain and engine layers on the same computer, or on separate computers, is 3 GB.

Evaluate the following factors to determine the memory requirements for your system:

• Other software on the same server
• Performance requirements
• Size and complexity of your configuration
• Extent of activity and the number of concurrent clients that access your system
• Processing for the temporary tables and sorts that is performed by the servers to avoid disk input and output

Minimum disk space requirements (Windows)

Important: These installation disk space requirements are the minimum requirements for installation. Operational requirements are significantly larger than these minimum installation disk space requirements.

The installation of IBM Information Server requires the following minimum disk space:

• 1.3 GB for WebSphere Application Server
• 500 MB for DB2
• 1.4 GB for the IBM Information Server components
• 2 GB for the metadata repository database
• 1 GB for the WebSphere Information Analyzer analysis database
• 2 GB of temporary space during the installation

Table 1. Minimum disk space requirements for a client installation

Table 2. Minimum disk space requirements for the metadata repository installation

Table 3. Minimum disk space requirements for the domain installation

Table 4. Minimum disk space requirements for the engine installation

Table 5. Disk space requirements for the documentation installation

Before you install IBM Information Server in a Linux^® or UNIX^® environment, ensure that your computer meets the hardware and software requirements for the product modules and components that you want to install.

Platform requirements (Linux, UNIX)

The metadata repository, domain, and engine layers are supported on systems that run the following versions of Linux and UNIX.

Table 6. Platform requirements for 32-bit operating systems

Table 7. Platform requirements for 64-bit operating systems

¹IBM Information Server is supported on AIX logical partitions.
²IBM Information Server is supported on Solaris Zones and Solaris Containers.

Table 8. Additional requirements for operating systems

Note: IBM Information Server 8.0.1 is not supported on SUSE Linux Enterprise Server 10 or Red Hat Enterprise Linux Advanced Server 4 for Intel Itanium hardware.

For information about support for IBM software products running in a VMware environment, go to http://www.ibm.com/support/docview.wss?&uid=wws1e333ce0912f7b152852571f60074d175.

Metadata repository and WebSphere Information Analyzer analysis database software requirements (Linux, UNIX)

The following database servers are supported for use with the metadata repository:

• DB2 Enterprise Server Edition Version 9.1
• DB2 for z/OS Version 8 and Version 9.1
• Microsoft SQL Server 2005 Enterprise Edition
• Oracle 10g Release 2

• DB2 for z/OS Version 9.15 running in New Function Mode (NFM)
• Oracle 10g Release 2

You must have root access file permissions to install DB2 databases on UNIX and Linux operating systems. In addition to root access, the DB2 installation program requires write permission in several file systems, such as /var and /usr/local/bin. This requirement is not always satisfied when these directories are mounted from network file systems such as IBM AFS^®.

Table 9. Additional requirements for DB2

To use DB2 for the metadata repository on 64-bit SUSE Linux Enterprise Server 10 on AMD or Intel x86 and 64-bit Red Hat Enterprise Linux Advanced Server 4 on AMD or Intel x86, you must install DB2 Version 9.1 for 64-bit Linux before you install IBM Information Server.

• Download C13KTML from the IBM Passport Advantage Web site at www.ibm.com/software/passportadvantage.

WebSphere Information Analyzer analysis database requirements for IBM DB2 Version 9.1 for z/OS

The WebSphere Information Analyzer analysis database supports only DB2 Version 9.1 for z/OS ^®. The WebSphere Information Analyzer analysis database does not support DB2 Version 8.1 for z/OS.

The WebSphere Information Analyzer database creation scripts that support DB2 Version 9.1 for z/OS are provided on the installation media in the \InformationAnalyzer\DB2_zOS directory.

Stored procedures that are used during Foreign Key Analysis and Cross Domain Analysis are created dynamically in the analysis database by WebSphere Information Analyzer. DB2 Version 9.1 must be running in New Function Mode (NFM) for these stored procedures to work.

Domain software requirements (Linux, UNIX)

WebSphere Application Server, Version 6.0.2, Fix Pack 11 or later 6.0.2 fix packs, is required to host WebSphere Metadata Server. When you install the suite, you can install the application server, or you can use an existing installation.
If WebSphere Application Server is already installed, you must use a dedicated profile with the server name of server1.

HP-UX 11i v2 for Intel Itanium additional requirements

To use IBM Information Server on HP-UX 11i v2 for Intel Itanium, you must install WebSphere Application Server before you install IBM Information Server.

Table 10. Additional requirements for HP-UX 11i v2 for Intel Itanium

To use IBM Information Server on 64-bit Red Hat Enterprise Linux Advanced Server 4 on AMD or Intel x86 and 64-bit SUSE Linux Enterprise Server 10 on AMD or Intel x86, you must install WebSphere Application Server before you install IBM Information Server.

Table 11. Additional requirements for 64-bit SUSE Linux Enterprise Server 10 or 64-bit Red Hat Enterprise Linux Advanced Server 4

Engine software requirements (Linux, UNIX)

The following compilers are required for WebSphere DataStage and WebSphere QualityStage. The compilers must be installed on the computer where you install the engine. When you install a compiler, ensure that all the compiler packages are installed. The runtime components are required for AIX on systems where the compiler is not installed and you are running only compiled parallel jobs.

Table 12. Required C++ compilers and runtime libraries

Kernel parameter requirements
The kernel parameter requirements in this section apply to IBM Information Server. Additional kernel parameter requirements for DB2 are in the IBM DB2 Database for Linux, UNIX, and Windows Information Center at http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp.

Verify the settings of the kernel parameters. Make a backup copy of the /etc/system file before you modify it. Modify the kernel parameters with the suggested kernel parameters and values. Restart the system before you install IBM Information Server. Additional kernel parameter changes may be required.

Table 13. Kernel parameters

Documentation software requirements (Linux, UNIX)

To access the PDF documentation that is installed with IBM Information Server, you must have Adobe Acrobat or a comparable PDF reader installed.

To access help and other topics in the information center, which is installed in the domain layer, you must have one of the following supported Web browsers configured as your default browser:

• Microsoft Internet Explorer 6 or Microsoft Internet Explorer 7
• Mozilla Firefox Version 1.7 or 2.0

Networking requirements (Linux, UNIX)

The client, repository, domain, and engine layers must be able to communicate with each other over the network.

Memory requirements (Linux, UNIX)

The minimum amount of memory for installing the IBM Information Server domain and engine layers on the same computer, or on separate computers, is 4 GB.

A minimum 5 GB RAM is required for the following 64-bit operating systems:

• Red Hat Enterprise Linux 5 on IBM System z
• SUSE Linux Enterprise Server 10 for IBM System z

Evaluate the following factors to determine the memory requirements for your system:

• Other software on the same server
• Performance requirements
• Size and complexity of your configuration
• Extent of activity and the number of concurrent clients that access your system
• Processing for the temporary tables and sorts that are performed by the servers to avoid disk input and output

As with any configuration, actual memory requirements depend on the type of processing, amount of parallel processing, the size and number of simultaneously running WebSphere DataStage jobs, and memory requirements of the operating system and other applications (such as relational databases).

Minimum disk space requirements (Linux, UNIX)

Important: The following installation disk space requirements are the minimum installation disk space requirements. Operational requirements are significantly larger than these minimum requirements.

The installation of IBM Information Server requires the following minimum disk space:

• 1 GB for WebSphere Application Server
• 500 MB for DB2
• 1.4 GB for the IBM Information Server components
• 3 GB for the metadata repository and the WebSphere Information Analyzer analysis database
• 2 GB of temporary space during the installation

Table 14. Minimum disk space requirements for the metadata repository installation

Table 15. Minimum disk space requirements for the domain installation

Table 16. Minimum disk space requirements for the engine installation

Table 17. Disk space requirements for the documentation installation

Additional requirements

The following additional requirements also apply:

Supported platforms for mainframe jobs
The following systems are supported for compiling and running mainframe jobs:

• IBM OS/390^® 2.6 or later
• IBM z/OS^® 1.1 or later

• When using the Teradata connector on Red Hat Enterprise Linux Advanced Server 4, install the Teradata client version 8.2.0.2 before you install IBM Information Server 8.0.1.
• Download the papi8200.08.02.00.02 efix from www.ncr.com.
• During efix installation, select option 2 to install the library built with the gcc 3.3 compiler of the 32-bit Teradata PT API library. The Teradata connector requires the library that is installed by option 2.

• WebSphere MQ Version 6.0.2 is required to use WebSphere MQ Connector stage in WebSphere DataStage on SUSE Linux Enterprise Server version 10 on AMD or Intel x86.

• z/OS version 1.8 or higher
• DB2 for z/OS Version 9.1 or higher
• z/OS FTP server version 1.6 or higher
• DB2Connect must be installed:
  • DB2Connect version number must correspond to the version number of the DB2 for z/OS database
  • DB2Connect database must be cataloged for the DB2 for z/OS database
• To use BatchPipes^®, the following patches are required:
  • BatchPipes version 2.01 or higher (FMID = HACH301)
  • APAR PK37032 for the z/OS FTP server that includes the site subsys=xxxx command to direct data to a to a BatchPipes subsystem
• DB2 TEMPLATE utility statement that supports references to BatchPipes data streams:
  • DB2 for z/OS Version 8.1: PTF UK26290
  • DB2 for z/OS Version 9.1: PTF UK25291
• After IBM Information Server is installed, perform these post installation commands to use DB2Z stage in WebSphere DataStage.
  • On the server layer, type these commands to bind the executable to DB2:
    db2 connect to dbname user dbuser using dbpassword
    db2 bind db2zesql.bnd datetime iso blocking all
    db2 terminate
  • Use the DataStage Administrator on the DataStage client layer to add the sqllib/lib in the LIBPATH in .profile.

Supported data sources and ODBC drivers for WebSphere DataStage and WebSphere QualityStage

WebSphere DataStage and WebSphere QualityStage support numerous data sources through ODBC. DataDirect Connect for ODBC is installed with WebSphere DataStage and WebSphere QualityStage. The following tables list the ODBC drivers installed with WebSphere DataStage and WebSphere QualityStage, which databases they access, and which platforms they are available on.

Table 18. ODBC version 5.2 drivers

Table 19. ODBC version 5.3 drivers