IBM Support

Detailed System Requirements for v11.3 of the IBM InfoSphere Optim Solutions and Hive as a Data Source DBMS

Product Documentation


This document provides information about prerequisites for the IBM® InfoSphere® Optim™ solutions and their features. Requirements for using Hive as a data source DBMS are provided as well.


IBM InfoSphere Optim Solutions Supported Data Sources

Click on the DBMS name in the tabs below for the detailed system requirements page for it.

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.

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.
Note that Optim does not currently support Temporal Tables in any data source.

Optim Directory Support

For Optim 11.3 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.

In DB2, certain 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


12cR1 and 12cR2

Minimum required level of Optim is




Minimum required level of Optim is



Minimum required level of Optim is


Minimum required level of Optim is


Minimum required level of Optim is

Minimum required level of Optim is with intermediate fix (iFix) 023-A. See "How to Add Toleration of IBM® Db2 11.5 to IBM® InfoSphere Optim 11.3" for detailed installation instructions.


Minimum required level of Optim is

Hive as a Data Source Requirements

Version Support Level Comments
2.0, 2.1 Support

Minimum version of Optim required is

Apache Hadoop Hive 2.0 and 2.1 have been verified against the following distributions:

  • Cloudera (CDH) 5.4, 5.5, 5.6, 5.7, 5.8, 5.9, 5.10, 5.11, 5.12
  • Hortonworks (HDP) 2.4, 2.5
  • IBM BigInsights 4.2, 4.3

Hive Complex Data Types are not 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.

Set up considerations

The following considerations apply when using an Optim server to access Hive:

  • The appropriate ODBC driver must be installed on both workstation and server.
  • You must use the Progress DataDirect ODBC driver manager distributed with your Optim solution. For information needed to install and configure the DataDirect ODBC driver manager, see the Progress DataDirect "DataDirect Connect® Series for ODBC Users Guide".
  • Optim uses the Progress DataDirect ODBC and JDBC drivers for Hive. These are installed as part of the Optim installation. If you desire to use a different driver, you will have to install and configure it.

Requirements for Included Products

Use the following links to view additional requirements for each product included in version 11.3 of IBM InfoSphere Optim solutions.

[{"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":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"11.3.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
08 July 2021