Detailed System Requirements for v11.3 of the IBM® InfoSphere® Optim™ and IBM® DB2 as a Data Source Database Management System (DBMS)

Detailed System Requirements

Abstract

This document provides detailed system requirements for the IBM® InfoSphere® Optim™ solutions and their features. Requirements for using DB2 as a data source DBMS are provided as well.

Content

IBM InfoSphere Optim Solutions Supported Data Sources

Click 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 (11.1.0.7 or later)	2008 R1
v9.7	v11gR2 (11.2)	2008 R2
v10.1	12cR1 and 12cR2 Minimum required level of Optim is 11.3.0.6	2012
v10.5	18c Minimum required level of Optim is 11.3.0.8	2014
v11.1 Minimum required level of Optim is 11.3.0.5	19c Minimum required level of Optim is 11.3.0.8	2016 Minimum required level of Optim is 11.3.0.5
v11.5 Minimum required level of Optim is 11.3.0.8 with intermediate fix 023-A. See "How to Add Toleration of IBM® Db2 11.5 to IBM® InfoSphere Optim 11.3" for detailed installation instructions.		2017 Minimum required level of Optim is 11.3.0.7

DB2 as a Data Source System Requirements

DB2® for Linux, UNIX, and Windows

Supported DB2 character sets.

Version	Support Level	Comments
9.1	Supported
9.5	Supported	Refer to note 1 below.
9.7	Supported	Refer to notes 1 and 2 below.
10.1	Toleration	Refer to notes 1 and 2 below.
10.5	Toleration	Refer to notes 1 and 2 below.
11.1	Toleration	Refer to notes 1 and 2 below.. Minimum required level of Optim is 11.3.0.5
11.1	Supported	Refer to notes 1 and 2 below. Minimum required level of Optim is 11.3.0.7 Db2 Blu is supported.
11.5	Toleration	Refer to notes 1 and 2 below. Minimum required level of Optim is 11.3.0.8 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.

Notes:

The DECFLOAT data type is not supported for Optim Edit or Browse requests. For Load, the DECFLOAT datatype is supported only for IXF loader file format. Also, the DECFLOAT datatype is not supported for Optim Connect (Attunity) ODBC materialization of the data.
Authorizations for group privileges changed in version 9.7. If upgrading from version 9.5 to a subsequent version of DB2, review DB2 documentation to ensure that Optim user account privileges remain valid.

DB2 for iSeries®

Version	Support Level	Comments
5.3	Supported	Packaged with IBM InfoSphere Federation Server for connectivity.
5.4	Supported	Packaged with IBM InfoSphere Federation Server for connectivity.
6.0	Supported	Packaged with IBM InfoSphere Federation Server for connectivity.
7.0	Supported	Connectivity supported through Federation Server that comes with certain editions of Db2 11.1, which is not currently packaged with Optim 11.3.

DB2 for z/OS®

Supported DB2 character sets.

Version	Support Level	Comments
8.1	Supported	CLOB and DBCLOB column types are not supported in Unicode and ASCII tablespaces.
9.1	Supported	CLOB and DBCLOB column types are not supported in Unicode and ASCII tablespaces.
10.1	Supported	CLOB and DBCLOB column types are not supported in Unicode and ASCII tablespaces.
11.1	Toleration	CLOB and DBCLOB column types are not supported in Unicode and ASCII tablespaces.
12	Toleration	CLOB and DBCLOB column types are not supported in Unicode and ASCII tablespaces. Minimum required level of Optim is 11.3.0.5

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.

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"}}]

Tips

Detailed System Requirements for v11.3 of the IBM® InfoSphere® Optim™ and IBM® DB2 as a Data Source Database Management System (DBMS)