About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Detailed System Requirements
Abstract
This document provides information about prerequisites for the IBM® InfoSphere® Optim™ solutions and their features.
Content
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.
- IBM InfoSphere Optim Archive Enterprise Edition
- IBM InfoSphere Optim Archive Work Group Edition
- IBM InfoSphere Optim Application Retirement Solution
- IBM InfoSphere Optim Application Retirement Starter Edition for JD Edwards EnterpriseOne
- 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 Work Group Edition
- IBM InfoSphere Optim Oracle Application Accelerators Enterprise Edition
- IBM InfoSphere Optim Oracle Application Accelerators Work Group Edition
- IBM InfoSphere Optim Test Data Management Enterprise Edition
- IBM InfoSphere Optim Test Data Management Work Group Edition
- IBM InfoSphere Optim Test Data Management Solution
- IBM InfoSphere Optim Test Data Management Starter Edition for JD Edwards EnterpriseOne
- IBM InfoSphere Optim Test Data Management Solution for SAP Applications
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 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 |
2012 |
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.
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
| Version | Support Level | Comments |
|---|---|---|
|
9.1 |
Supported |
|
|
9.5 |
Supported |
The DECFLOAT data type is not supported for editing or browsing. Also, for load, DECFLOAT is supported only in IXF loader file format. |
|
9.7 |
Supported |
Authorizations for group privileges changed in version 9.7. If upgrading from version 9.5 to a subsequent version of DB2, 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. |
|
10.1 |
Toleration |
DB2 for iSeries®
| Version | Support Level | Comments |
|---|---|---|
|
5.3 |
Supported |
Packaged with IBM InfoSphere Federation Server for connectivity. For IBM InfoSphere Federation Server 9.7 SP3 go to Fix Central and select Product Group: Information Management, Product: InfoSphere Federation Server. |
|
5.4 |
Supported |
Packaged with IBM InfoSphere Federation Server for connectivity. For IBM InfoSphere Federation Server 9.7 SP3 go to Fix Central and select Product Group: Information Management, Product: InfoSphere Federation Server. |
DB2 for z/OS®
| 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. |
|
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"}}]
Was this topic helpful?
Document Information
More support for:
IBM InfoSphere Optim Test Data Management Solution
Software version:
9.1
Operating system(s):
AIX, HP-UX, IBM i, Linux, Solaris, Windows, z/OS
Document number:
628071
Modified date:
08 July 2021
UID
swg27024294
Manage My Notification Subscriptions