IBM Support

Detailed System Requirements for components of InfoSphere Optim 8.1

Product Documentation


Abstract

This techdoc provides information about prerequisites for IBM InfoSphere Optim and its features and components. It also summarizes the platforms and data sources supported by Optim.

Content

Hardware Considerations
The following are minimum requirements, actual hardware capacity for acceptable performance depends on many factors, including but not limited to: data volume; service level agreement; and access to non-relational data, as well as the number of open dialogs, number of database tables that are active, and memory demands from other active applications and services.

Minimum hardware requirements for an Optim workstation, including an Optim workstation with Optim designer, are:


  • Intel Pentium or newer (for example, Intel Celeron dual core, or Intel Core i3)
  • 1 – 2 Cores
  • 1.5 GHz minimum or faster
  • 1 - 2 GB RAM
  • 1 GB disk for Optim Software installation
  • 10BaseT or 100BaseT network connection

Minimum hardware requirements for an Optim server are:

AIX® Operating System

  • IBM Power5 or newer (for example, Power6 or Power7), or IBM Blade (Dual or Quad Core)
  • 2 Cores
  • 2.0 GHz minimum or faster
  • 2 – 4 GB RAM
  • 1 GB disk for Optim Software installation
  • 1 - 100 Mbit Network Interface Card or faster

HP-UX, HP-Itanium Operating System
  • PA-RISC or newer (for example, HP Integrity Superdome), or HP BladeSystem (Dual or Quad Core)
  • 2 Cores
  • 2.0 GHz minimum or faster
  • 2 – 4 GB RAM
  • 1 GB disk for Optim Software installation
  • 1 - 100 Mbit Network Interface Card or faster

Linux Operating System
  • Intel Xeon or newer, AMD Opteron, (Dual Core or Quad Core)
  • 2 Cores
  • 2.0 GHz minimum or faster
  • 2 – 4 GB RAM
  • 1 GB disk for Optim Software installation
  • 1 - 100 Mbit Network Interface Card or faster

Solaris Operating System
  • Sun SPARC Enterprise or newer, or Sun Blade (Dual or Quad Core)
  • 2 Cores
  • 2.0 GHz minimum or faster
  • 2 – 4 GB RAM
  • GB disk for Optim Software installation
  • 1 - 100 Mbit Network Interface Card or faster

Windows Operating System
  • Intel Xeon or newer, AMD Opteron, (Dual Core or Quad Core)
  • 2 Cores
  • 2.0 GHz minimum or faster
  • 2 – 4 GB RAM
  • 1 GB disk for Optim Software installation
  • 1 - 100 Mbit Network Interface Card or faster

Software Requirements
Unless installing the Optim server (or absent the server, the workstation) on the database server, client software for the database management system is required. Optim is a 32-bit application, and requires 32-bit DBMS clients. Install Optim on a 32-bit platform or on a 64-bit platform that supports 32-bit applications.

Platform Considerations
Supported Platforms
Platform and Version
Optim Server
Optim Work station
Comments
AIX 5.3Yes No
AIX 6.1Yes No
HP-UX 11i v2Yes No
HP-UX 11i v3Yes No
HP-UX 11iv2 on ItaniumYes NoSupported for DB2 and Oracle databases
HP-UX 11iv3 on ItaniumYes NoSupported for DB2 and Oracle databases
Red Hat Enterprise Linux 3Yes No
Red Hat Enterprise Linux 4Yes No
Red Hat Enterprise Linux 5Yes No
SUSE Linux Enterprise Server 9Yes NoOpen Data Manager is not supported on this platform.
SUSE Linux Enterprise Server 10Yes NoOpen Data Manager is not supported on this platform.
Solaris 83Yes No
Solaris 9Yes No
Solaris 10Yes No
Windows XP ProfessionalYesYesAt least one workstation2 is required for each Optim implementation.
Windows Server 2003YesYesAt least one workstation2 is required for each Optim implementation.
Windows 2003 R2YesYesAt least one workstation2 is required for each Optim implementation.
Windows Vista1YesYesAt least one workstation2 is required for each Optim implementation
Windows 71YesYesAt least one workstation2 is required for each Optim implementation
Windows Server 20081 YesYesAt least one workstation2 is required for each Optim implementation
Windows Server 2008 R21YesYesAt least one workstation2 is required for each Optim implementation

1New features in Windows Kernel Version 6.0 (Windows Vista and Windows 2008) and Version 6.1 (Windows 7 and Windows 2008 R2) restrict the installation of Optim so that it can only be installed under full Windows Administrator authority. Special installation instructions for these platforms is provided at http://www.ibm.com/support/docview.wss?rs=3473&uid=swg21439335
2Version of Optim software on the workstation and on connecting Optim servers must match.
3Optim 8.1 will be the last Optim release to support Solaris 8 in conjunction with the end of service life for Solaris 8 on March 31, 2012.

Setup considerations for Teradata
The following Teradata client components must be installed on the Optim Server as well as the Optim Windows client:

    • Shared ICU Libraries
    • Teradata GSS
    • CLIv2 interface
    • Teradata Pre-processor (PP2)
  • Optim support for native Teradata loaders (optional) may require the following components, depending on your Optim configuration:
    • MultiLoad
    • FastLoad
    • BTEQ
    • Named Pipe Access Module
    • PIOM (Data Connector)
  • Optim support for Teradata Parallel Transport (optional) requires the following components:
    • TPT Export Operator
    • TPT API
    • TPT Infrastructure
    • TPT Operator Support Library (V12, part of TPT Infrastructure in V13)
    • TPT ICU Libraries (V12, part of TPT Infrastructure in V13)
  • When using Open Data Manager (ODM), archived data and online data from the Teradata system can be combined (UNION or JOIN) through the use of Infosphere Federation Server, which is also provided. Using a Teradata wrapper along with an ODBC wrapper, DB2 queries can be written with references to nicknamed objects from both wrappers. In addition, your applications can connect to ODM through ODBC or JDBC in order to access archived data directly.
  • Optim for Teradata is not supported on the HP-Itanium platform.
  • Optim for Teradata supports the following minimum version levels of the Teradata Server software:
    • V2.6.2
    • V12.0.2.38
    • V12.0.3.1
    • V13.0.0.18
    • V13.0.1.1
    • V13.10.0.1
  • Executing Optim against any supported versions of Teradata on Windows requires a minimum Teradata client level of TTU version 8.2 or above on the Optim Server.
  • Executing Optim against any supported versions of Teradata on AIX requires a minimum Teradata client level of TTU version 12 or above on the Optim Server.
  • Executing Optim against any supported versions of Teradata on the Solaris, RHEL or HP-UX platforms requires a minimum Teradata client level of TTU version 13 or above on the Optim Server. In addition, the following patch levels are required for specific client components:
    • TTU version 13 client, with CLIv2 patch 13.00.00.11 or above, available for download on the Teradata @ Your Service web site.
    • TTU version 13.10 client, with CLIv2 patch 13.10.00.10 or above, available for download on the Teradata @ Your Service web site.
    • TPT version 13.10 with papida00 patch 13.10.00.06 or above, available for download on the Teradata @ Your Service web site.
Setup considerations for UNIX
The following consideration applies when installing the Optim server on a UNIX platform:
  • If you are upgrading the Optim server on a UNIX platform, you must first shut down the server, following the steps in the Installation and Configuration Guide.
  • By default, the Optim setup program requires a connection that supports a graphical interface. In the absence of a graphical interface or for convenience, you may also install from the command line, running a file that provides a response to all prompts. Both methods are described in detail in the Installation and Configuration Guide as are troubleshooting tips for using a graphical interface.

Open Data Manager
An uncompress utility is a prerequisite to the installation of Open Data Manager on most platforms. Where required, the utility is in the /usr/bin directory in the following packages.

Package
Description
AIXbos.rte.archiveBase Operating System Runtime, Archive Commands
HP-UXOS-Core.CMDS-MIN and PHCO_26898.CMDS-MIN Minimum HP-UX commands with Patch (11.11)
Linux ncompressFast compression and decompression utilities
SolarisSUNWesuExtended System Utilities
Windowsnot required
When Open Data Manager is installed on Windows, it generally requires Microsoft .NET Framework 3.5 Service Pack 1 as a prerequisite. This software can be obtained at http://www.microsoft.com/downloads/details.aspx?FamilyID=ab99342f-5d1a-413d-8319-81da479ab0d7. For older installations on Windows Server 2000, version 2.0 of Microsoft .NET Framework is required.

Database considerations


Certain database support is available only as a fix or maintenance patch. Current fixes for Optim 8.1 are available at: http://www.ibm.com/support/fixcentral/swg/selectFixes?parent=ibm~Information+Management&product=ibm/Information+Management/Optim&release=8.1.0&platform=All&function=all. A readme file, describing the content of each fix is available at the same location.
Supported Databases
DBMS and Version
Support Level
DB2 for Linux, UNIX, and Windows 9.1Full support except for ASCII tables
DB2 for Linux, UNIX, and Windows 9.510Full support except for ASCII tables
DB2 for Linux, UNIX, and Windows 9.76Full support except for ASCII tables
DB2 for Linux, UNIX, and Windows 10.1Toleration support
DB2 for iSeries 5.34Full support
DB2 for iSeries 5.44Full support
DB2 for z/OS 8.19Full support
DB2 for z/OS 9.19Full support
DB2 for z/OS 10.19Full support
Informix 111Toleration support
Informix 11.51Toleration support
Informix IDS 11.7Toleration support
Oracle 8.1.72Full support
Oracle 9.2Full support
Oracle 10.111Full support
Oracle 10.211Full support
Oracle 11gR13 11Full support
Oracle 11gR23 11Full support
SQL Server 2000Full support
SQL Server 2005Full support
SQL Server 20085Full support
Sybase 15Full support
Sybase 15.5Toleration support
Teradata 2.54, 8Full support
Teradata 2.6.27, 8Full support
Teradata 127, 8Full support
Teradata 137, 8Toleration support
Teradata 13.107, 8Toleration support

1Version 2.9 and version 3.5 clients are supported. Version 3.5 client is required for support of BIGINT and BIGSERIAL. BIGINT and BIGSERIAL are not supported on SUSE and Redhat Linux.
2Optim 8.1 does not support the download of sample data to Oracle 8.1.7.
3In Optim 8.1, the DICOM Medical Image, 3D Spatial, and RFID tag data types are not supported.
4Packaged with IBM InfoSphere Federation Server for connectivity. For IBM InfoSphere Federation Server 9.7 SP3, use this link:
http://www.ibm.com/support/fixcentral. For Federation Server fix packs, select Product Group: Information Management, Product: InfoSphere Federation Server.
5SQL Server Loader does not support the GEOGRAPHY, GEOMETRY or HIERARCHYID data types.
6DB2 authorizations for group privileges changed in version 9.7. Optim customers that upgrade DB2 from version 9.5 to a subsequent version of DB2 should review http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com.ibm.db2.luw.wn.doc/doc/i0054534.html for information needed to ensure that Optim user account privileges remain valid.
7Optim provides native access support for these versions of Teradata.
8Extended objects are not supported.
9CLOB data is not supported.
10The DECFLOAT data type is not supported for editing or browsing. Also, for load, DECFLOAT is supported only in IXF loader file format.
11The Optim XML package installation requires installation of XDB. See http://www.ibm.com/support/docview.wss?rs=3473&uid=swg21461187 for further information. 


IBM Tivoli License Manager
If you use IBM Tivoli License Manager use the following manual process to activate it for data sources that do not reside on an Optim server or on a z/OS system:
  • Locate the set of *.sys2 files residing at: Optim Root\ETC\
  • Copy the *.sys2 files to:
    \\server root\IBM\Optim|ITLM
    on the server hosting the data source.
Supported Character Sets
Optim supports Unicode-type databases in all supported database management systems. Use this link for information about character sets for all supported databases. Published document will be at:
http://www.ibm.com/support/docview.wss?&uid=swg27021866

Optim v8.1 now includes IBM Mashup Center v3.0
IBM Mashup Center is an end-to-end enterprise mashup platform that enables the rapid creation, sharing, and discovery of reusable application building blocks (widgets, feeds, mashups) that can be easily assembled into new applications or leveraged within existing applications - delivering lower development costs, rapid ROI, quick delivery of applications, and greater productivity. Optim installation media includes Mashup Center 3.0. Use this link to upgrade to FixPack 3.0.0.1: http://www-10.lotus.com/ldd/mashupswiki.nsf/dx/fixpacks

Optim designer
Optim is packaged with the optional Optim designer, which can be used to build and discover models for Optim on distributed and z/OS platforms. You can also use Optim designer to run Optim processes on these platforms and to create interoperability services based on process requests that can be published to the Optim manager environment.

The Optim designer installation disc includes IBM Installation Manager and installation packages for designer, InfoSphere Data Architect, and the Optim shared libraries. Use the following link for Detailed System Requirements for Optim designer:
http://www.ibm.com/support/docview.wss?uid=swg27019157

To begin the installation process, run the launchpad executable file. You must use IBM Installation Manager to install Optim designer, InfoSphere Data Architect, and the Optim shared libraries. If the required version of Installation Manager is not installed, the installation process will install this component first.

InfoSphere Data Architect 7.5.3 is a prerequisite for designer. You can use Installation Manager to install InfoSphere Data Architect before or at the same time as the designer. The shared libraries are also a requirement for the designer.

Optim manager
Optim manager is a web application that you can use to configure, run, monitor, and manage services and to configure components that are used to run these services. Use the following link for Detailed System Requirements for Optim Manager:
http://www.ibm.com/support/docview.wss?uid=swg27019158

The Optim manager installation disc includes IBM Installation Manager and installation packages for manager, management server, proxy, Optim shared libraries, and IBM WebSphere® Application Server Community Edition.

To begin the installation process, run the launchpad executable file. You must use Installation Manager to install Optim Manager, management server, proxy, shared libraries, and IBM WebSphere Application Server Community Edition. If the required version of Installation Manager is not installed, the installation process will install this component first.

Optim manager and Optim management server each require a J2EE application server, and you can use the supplied IBM WebSphere Application Server Community Edition for this requirement.

The shared libraries are required for manager, management server, and proxy. To process interoperability services, the proxy computer must include an installation of your Optim Solution software.

For information about configuring and using the Optim manager environment, refer to the documentation location on the installation disc.

[{"Product":{"code":"SSMLQ4","label":"IBM InfoSphere Optim Test Data Management Solution"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Solution for Data Growth- Data Privacy- and Test Data Management","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
08 July 2021

UID

swg27021803

Page Feedback