Product Documentation
Abstract
This document provides information about prerequisites for the IBM® InfoSphere® Optim™ solutions and their features. Requirements for using Informix as a data source DBMS are provided as well.
Content
IBM InfoSphere Optim 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 (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 (iFix) 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 |
Informix® as a Data Source Requirements
Supported Informix character sets.
Version | Support Level | Comments |
---|---|---|
7.3.1 | Supported | 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. |
11.0 |
Toleration |
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. |
11.5 |
Toleration |
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. |
11.7 |
Toleration |
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. |
12.1 |
Toleration |
Version 2.9, version 3.5 and Version 4.1 clients are supported. Version 3.5 and Version 4.1 clients are required for support of BIGINT and BIGSERIAL. BIGINT and BIGSERIAL are not supported on SUSE and Redhat Linux. |
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
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.
- IBM InfoSphere Information Lifecycle Governance for Structured Data
- IBM InfoSphere Optim Application Retirement Solution
- IBM InfoSphere Optim Archive Enterprise Edition
- IBM InfoSphere Optim Archive Work Group Edition
- IBM InfoSphere Optim Data Growth Solution
- IBM InfoSphere Optim Data Growth Starter Edition for JD Edwards EnterpriseOne
- IBM InfoSphere Optim Data Privacy Enterprise Edition
- IBM InfoSphere Optim Data Privacy for Data Warehouse Appliances
- IBM InfoSphere Optim Data Privacy Workgroup Edition
- IBM InfoSphere Optim Test Data Management Enterprise Edition
- IBM InfoSphere Optim Test Data Management Solution
- IBM InfoSphere Optim Test Data Management Solution for SAP Applications
- IBM InfoSphere Optim Test Data Management Starter Edition for JD Edwards EnterpriseOne
- IBM InfoSphere Optim Test Data Management Work Group Edition
Was this topic helpful?
Document Information
Modified date:
08 July 2021
UID
swg27043009