Detailed System Requirements for components of IBM Optim 7.2

Product documentation


Abstract

This techdoc provides information about prerequisites for IBM Optim and its features, and components. It also summarizes the platforms and data sources supported by IBM 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 (e.g. 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 (e.g. Power6 or Power7), or IBM Blade (Dual or Quad Core)
  • 2 Cores
  • 2.0 GH minimum or faster
  • 2 – 4 GB RAM
  • 1 GB disk for Optim Software installation
  • 1 - 100 Mbit Network Interface Card or faster

HP/UX Operating System

  • PA-RISC or newer (e.g. HP Integrity Superdome), or HP BladeSystem (Dual or Quad Core)
  • 2 Cores
  • 2.0 GH 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 GH 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 GH minimum or faster
  • 2 – 4 GB RAM
  • 1 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 GH 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. Optim should be installed 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.2 Yes No
AIX 5.3 Yes No
AIX 6.1 Yes No
HP-UX 11.11 Yes No
HP-UX 11.23(PA-RISC)1 Yes No
HP-UX 11.30(PA-RISC)1 Yes No
Red Hat Enterprise Linux 3 Yes No
Red Hat Enterprise Linux 4 Yes No
Red Hat Enterprise Linux 5 Yes No
SUSE Linux Enterprise 9 Yes No Open Data Manager is not supported on this platform.
SUSE Linux Enterprise 10 Yes No Open Data Manager is not supported on this platform.
Solaris 8 Yes No
Solaris 9 Yes No
Solaris 10 Yes No
Windows 2000 Yes Yes At least one workstation4 is required for each Optim implementation.
Windows XP Professional Yes Yes At least one workstation4 is required for each Optim implementation.
Windows Server 2003 Yes Yes At least one workstation4 is required for each Optim implementation.
Windows Vista3 Yes Yes At least one workstation4 is required for each Optim implementation
Windows 723 Yes Yes At least one workstation4 is required for each Optim implementation
Windows Server 2008 R223 Yes Yes At least one workstation4 is required for each Optim implementation
Windows Server 200823 Yes Yes At least one workstation4 is required for each Optim implementation
1Optim supports the HP-UX Itanium® architecture if running the PA-RISC emulator. You must perform special installation steps to run Optim using the PA-RISC emulator. Currently only Oracle is supported in this environment.
2Support for these platforms is added in Version 7.2.2.
3 New 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
4Version of Optim software on the workstation must match that of the Optim software on any connecting Optim servers.
5DB2 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 accounts remain valid.

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 installation of Open Data Manager on most platforms. Where required, the utility is in the /usr/bin directory in the following packages.
Package
Description
AIX bos.rte.archive Base Operating System Runtime, Archive Commands
HP-UX OS-Core.CMDS-MIN and PHCO_26898.CMDS-MIN Minimum HPUX commands with Patch (11.11)
Linux ncompress Fast compression and decompression utilities
Solaris SUNWesu Extended System Utilities
Windows not required
When Open Data Manager is installed, 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. Open Data Manager cannot be used to federate archived data with data in Oracle 11g.

Database considerations


Supported Databases
DBMS and Version
Support Level
DB2 for Linux, UNIX, and Windows 7.2 Full support
DB2 for Linux, UNIX, and Windows 8.1 Full support
DB2 for Linux, UNIX, and Windows 8.2 Full support
DB2 for Linux, UNIX, and Windows 9.1 Full support
DB2 for Linux, UNIX, and Windows 9.5 Toleration support
DB2 for Linux, UNIX, and Windows 9.74 Toleration support
DB2 for iSeries 5.3 Native support for iSeries LOAD. Additional toleration support for iSeries requires add'l programs, services, or both.
DB2 for iSeries 5.4 Native support for iSeries LOAD. Additional toleration support for iSeries requires add'l programs, services, or both.
DB2 for z/OS® 7.1 Toleration support
DB2 for z/OS 8.1 Full support
DB2 for z/OS 9.1 Toleration support
Informix® 7.311 Full support
Informix 9.41 Toleration support
Informix 10 1 Toleration support
Informix 11 1 Toleration support
Informix 11.5 1 Toleration support
Oracle 8.1.72 Full support
Oracle 9.0 Full support
Oracle 9.2 Full support
Oracle 10.1 Full support
Oracle 10.2 Full support
Oracle 11.1.3 Full support
SQL Server 7.0 Full support
SQL Server 2000 Full support
SQL Server 2005 Full support
SQL Server 2008 Toleration support
Sybase 11.9.2 Full support
Sybase 12.0 Full support
Sybase 12.5 Full support
Sybase 15 Full support
Teradata 2.5 Native support for Teradata LOAD. Additional toleration support for Teradata requires add'l programs, services, or both.
Teradata 2.6 Native support for Teradata LOAD. Additional toleration support for Teradata requires add'l programs, services, or both.

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 7.2 does not support the download of sample data to Oracle 8.1.7.
3In Optim 7.2, the DICOM Medical Image, 3D Spatial, and RFID tag data types are not supported.
4DB2 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.

Supported Single-byte Character Sets

Optim supports the following single-byte character sets within all supported databases:

Arabic 1256
Baltic 1257
Canadian French 863
Cyrillic 1251
Eastern European 1250
English 437
Greek 1253
Hebrew 1255
International Multilingual 850
Nordic 865
Portuguese 860
Turkish 1254
Latin 1 1252

Beginning with Oracle version 9.2, Optim supports the following single-byte character set within Oracle.

Thai TH8TISASCII [NLS_LANG=,TH8TISASCII (874)]

Supported Multi-byte Character Sets

Optim (when running on Windows or AIX) supports the following multi-byte character sets within DB2 for Linux, UNIX, and Windows.

Chinese 936 [Windows Simplified Chinese]
950 [IBM Chinese Big-5]
1386 [IBM Simplified Chinese]
Korean 949 [Korean (KS Code 5601-89)-including 1880 UDC]
970 [Korean (EUC)]

Optim supports the following multi-byte character sets within Oracle.

Chinese ZHS32GB18030 [GB18030-2000]
ZHT16MSWIN950 [Windows Code Page 950 Traditional Chinese]
ZHS16GBK [GBK 16-bit Simplified Chinese]
Korean KO16MSWIN949 [Windows Code Page 949 Korean]

Additional Supported Multi-byte Character Sets - Optim 7.2.1

Optim (when running on Windows or AIX) supports the following multi-byte character set within DB2 for Linux, UNIX, and Windows.

Japanese 932 [IBM SJIS]

Optim supports the following multi-byte character sets within Oracle.

Japanese JA16SJIS [Japanese 16-bit SJIS]
JA16SJISTILDE [Japanese 16-bit SJIS with tilde]
JA16EUCTILDE [Japanese EUC 16-bit SJIS with tilde]
JA16EUC [Japanese EUC 17-bit]

Optim supports the following multi-byte character set within Sybase.

Japanese eucjis [EUC SJIS]

Optim supports the following multi-byte character set within Informix.

Japanese ja_jp.sjis-s [SJIS]

Additional Supported Multi-byte Character Sets - Optim 7.2.2

Optim supports the following multi-byte character sets within DB2 for Linux, UNIX, and Windows.

Chinese 950 [IBM Chinese Big-5]
1386 [IBM Simplified Chinese]
Korean 949 [Korean (KS Code 5601-89)-including 1880 UDC]
Note: While the above DB2-LUW code pages were previously supported by Optim, this support was provided by the converters built-in to ICU which do not parallel all code points within DB2-LUW. This newer version of each code page is based soley upon the code points supported within DB2-LUW.

Optim supports the following multi-byte character sets within Informix.

Chinese big5 [Traditional Chinese Big-5]
euctw [EUC code set for Taiwan]
Korean cp949 [Korean Code Page 949]

Optim supports the following multi-byte character sets within Sybase.

Chinese eucgb [EUC for GB2312-80 (Simplified Chinese)]
euccns [EUC for CNS-11643 (Traditional Chinese)]
Korean euckc [EUC for KSC-5601]


Optim v7.2 now includes IBM Mashup Center v2.0.0.2

IBM® Mashup® CenterTM 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 for Windows and AIX includes Mashup Center 2.0.0.2 . Optim installation media for Linux includes Mashup Center 2.0. For Linux users, use the link below to upgrade to FixPack 2.0.0.2:



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 platforms and Optim for z/OS. For use with Optim on distributed platforms, Optim designer must be installed on an Optim workstation.

Optim designer requires an activated copy of InfoSphere™ Data Architect installed on the workstation. The Optim designer kit includes an InfoSphere Data Architect installation disc and an Optim designer installation disc for each operating system. Each Optim designer installation disc includes an InfoSphere Data Architect product activation kit, which you can use to activate InfoSphere Data Architect. Each Optim designer installation disc also includes an InfoSphere Data Architect fix repository. (The downloaded Optim designer installation package contains disc images for all of the discs that are included in the Optim designer kit.)

You must use IBM Installation Manager 1.3.0 to install InfoSphere Data Architect and Optim designer. Installation Manager is included on the InfoSphere Data Architect disc. You must install Installation Manager first. Then, use Installation Manager to install InfoSphere Data Architect, any fix packs that are included on the Optim designer disc, and Optim designer. You can install these items sequentially, or you can install the fix packs and Optim designer at the same time. For more information on Installation Manager, see the Installation Manager information center at:


http://publib.boulder.ibm.com/infocenter/install/v1r2/index.jsp

Optim 7.2.0 is packaged with Optim designer 2.1.0, which requires InfoSphere Data Architect 7.5.2.0 with Fix Pack 2.

Optim 7.2.1 is packaged with Optim designer 2.1.1, which requires InfoSphere Data Architect 7.5.2.1. InfoSphere Data Architect 7.5.2.0 and Fix Pack for InfoSphere Data Architect 7.5.2.1 are included in the Optim designer 2.1.1 kit.

Rate this page:

(0 users)Average rating

Document information


More support for:

Optim
Solution for Data Growth- Data Privacy- and Test Data Management

Software version:

7.2.0, 7.2.1, 7.2.2

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Reference #:

7016808

Modified date:

2011-01-28

Translate my page

Machine Translation

Content navigation