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)¹	Yes	No
HP-UX 11.30(PA-RISC)¹	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 workstation⁴ is required for each Optim implementation.
Windows XP Professional	Yes	Yes	At least one workstation⁴ is required for each Optim implementation.
Windows Server 2003	Yes	Yes	At least one workstation⁴ is required for each Optim implementation.
Windows Vista³	Yes	Yes	At least one workstation⁴ is required for each Optim implementation
Windows 7²³	Yes	Yes	At least one workstation⁴ is required for each Optim implementation
Windows Server 2008 R2²³	Yes	Yes	At least one workstation⁴ is required for each Optim implementation
Windows Server 2008²³	Yes	Yes	At least one workstation⁴ is required for each Optim implementation

¹Optim 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.
²Support for these platforms is added in Version 7.2.2.
³ 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
⁴Version of Optim software on the workstation must match that of the Optim software on any connecting Optim servers.
⁵DB2 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.7⁴	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.31¹	Full support
Informix 9.4¹	Toleration support
Informix 10 ¹	Toleration support
Informix 11 ¹	Toleration support
Informix 11.5 ¹	Toleration support
Oracle 8.1.7²	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.

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

[{"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":"7.2.0;7.2.1;7.2.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Tips