IBM Support

Detailed System Requirements for v9.1 of the IBM InfoSphere Optim solutions

Detailed System Requirements


This document provides information about prerequisites for the IBM® InfoSphere® Optim™ solutions and their features.


Supported data sources are described in the tabs on this page. Use the following links to view additional requirements for each product included in version 9.1 of IBM InfoSphere Optim solutions.

Optim directory support

For Optim 9.1 test data management solutions that use Optim designer and Optim manager, the Optim directory and the IBM InfoSphere Optim Connection Manager database must be Unicode and are supported on the following database management systems only. For the next major version, all Optim solutions support the Optim directory and the InfoSphere Optim Connection Manager database on these database management systems only. The Optim directory must use a different schema from the schema that is used by the InfoSphere Optim Connection Manager database.

In DB2, certain Optim directory tables require an 8K tablespace. The default size for DB2 is 4K. Ensure that the directory owner has authorization to an 8K tablespace or that a specific 8K tablespace is specified when installing or upgrading.

DB2® for Linux, UNIX, and Windows Oracle SQL Server

v9.5 (FP10 or later)

v11gR1 ( or later)

2008 R1


v11gR2 (11.2)

2008 R2



Supported data sources

The Optim solutions support data sources heterogeneously. That is, a solution can generally process a business object that consists of data from one or more data sources or extract data from one data source or DBMS and insert it in another. Select a tab for more information about supported data sources.

To prevent inadvertent deletion or alteration of data from system tables for your relational database management system, your Optim solution cannot be used in INSERT, UPDATE, or DELETE processing against these tables.

Tabs by data source


Version Support Level Comments



For platforms other than Windows, Netezza version 6.0.3 is not supported when the Optim directory resides in a DB2 database.

Setup considerations for Netezza

The following considerations apply when using Optim server to access a Netezza database:

  • ODBC client for Netezza is required
  • To configure a Linux or UNIX machine as a client, use either the Data Direct ODBC driver manager, provided with Optim, or a driver manager that is in use at your site with the Netezza ODBC driver for Linux or UNIX.
  • Netezza loader must be available
  • Version 6.0.3 of the Netezza appliance is supported

Support levels

The support level for a version of a database is toleration or supported.

If a database is provided at a toleration level, the Optim solution can connect to the data source. The Optim solution also supports data types and features supported in previous releases of the solution but does not support all features of the data source.

If a data source is supported, the Optim solution also:

  • Supports processing of the most common data types for the data source
  • Might support or exploit other new features of the data source
In addition, for relational databases, the Optim solution supports extracting object definitions for the database as well as preserving and using (with the Optim create utility) extracted objects.

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

Document Information

Modified date:
08 July 2021