IBM Support

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.2Yes No
AIX 5.3Yes No
AIX 6.1Yes No
HP-UX 11.11Yes No
HP-UX 11.23(PA-RISC)1Yes No
HP-UX 11.30(PA-RISC)1Yes No
Red Hat Enterprise Linux 3Yes No
Red Hat Enterprise Linux 4Yes No
Red Hat Enterprise Linux 5Yes No
SUSE Linux Enterprise 9Yes NoOpen Data Manager is not supported on this platform.
SUSE Linux Enterprise 10Yes NoOpen Data Manager is not supported on this platform.
Solaris 8Yes No
Solaris 9Yes No
Solaris 10Yes No
Windows 2000YesYesAt least one workstation4 is required for each Optim implementation.
Windows XP ProfessionalYesYesAt least one workstation4 is required for each Optim implementation.
Windows Server 2003YesYesAt least one workstation4 is required for each Optim implementation.
Windows Vista3YesYesAt least one workstation4 is required for each Optim implementation
Windows 723YesYesAt least one workstation4 is required for each Optim implementation
Windows Server 2008 R223YesYesAt least one workstation4 is required for each Optim implementation
Windows Server 200823 YesYesAt 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
AIXbos.rte.archiveBase Operating System Runtime, Archive Commands
HP-UXOS-Core.CMDS-MIN and PHCO_26898.CMDS-MIN Minimum HPUX commands with Patch (11.11)
Linux ncompressFast compression and decompression utilities
SolarisSUNWesuExtended System Utilities
Windowsnot 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.2Full support
DB2 for Linux, UNIX, and Windows 8.1Full support
DB2 for Linux, UNIX, and Windows 8.2Full support
DB2 for Linux, UNIX, and Windows 9.1Full support
DB2 for Linux, UNIX, and Windows 9.5Toleration support
DB2 for Linux, UNIX, and Windows 9.74Toleration support
DB2 for iSeries 5.3Native support for iSeries LOAD. Additional toleration support for iSeries requires add'l programs, services, or both.
DB2 for iSeries 5.4Native support for iSeries LOAD. Additional toleration support for iSeries requires add'l programs, services, or both.
DB2 for z/OS® 7.1Toleration support
DB2 for z/OS 8.1Full support
DB2 for z/OS 9.1Toleration support
Informix® 7.311Full support
Informix 9.41Toleration support
Informix 10 1Toleration support
Informix 11 1Toleration support
Informix 11.5 1Toleration support
Oracle 8.1.72Full support
Oracle 9.0Full support
Oracle 9.2Full support
Oracle 10.1 Full support
Oracle 10.2Full support
Oracle 11.1.3Full support
SQL Server 7.0Full support
SQL Server 2000Full support
SQL Server 2005Full support
SQL Server 2008Toleration support
Sybase 11.9.2Full support
Sybase 12.0Full support
Sybase 12.5Full support
Sybase 15Full support
Teradata 2.5Native support for Teradata LOAD. Additional toleration support for Teradata requires add'l programs, services, or both.
Teradata 2.6Native 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:




Arabic1256
Baltic1257
Canadian French 863
Cyrillic1251
Eastern European1250
English437
Greek1253
Hebrew1255
International Multilingual850
Nordic865
Portuguese860
Turkish1254
Latin 11252

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

ThaiTH8TISASCII [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.

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

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

ChineseZHS32GB18030 [GB18030-2000]
ZHT16MSWIN950 [Windows Code Page 950 Traditional Chinese]
ZHS16GBK [GBK 16-bit Simplified Chinese]
KoreanKO16MSWIN949 [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.

Japanese932 [IBM SJIS]

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

JapaneseJA16SJIS [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.

Japaneseeucjis [EUC SJIS]

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

Japaneseja_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.

Chinese950 [IBM Chinese Big-5]
1386 [IBM Simplified Chinese]
Korean949 [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.

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

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

Chineseeucgb [EUC for GB2312-80 (Simplified Chinese)]
euccns [EUC for CNS-11643 (Traditional Chinese)]
Koreaneuckc [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.


[{"Product":{"code":"SSGMCR","label":"Optim"},"Business Unit":{"code":"BU001","label":"Analytics Private Cloud"},"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":"7.2.0;7.2.1;7.2.2","Edition":""}]

Document Information

Modified date:
03 June 2019

UID

swg27016808