Detailed System Requirements
Abstract
This document provides information about prerequisites for the IBM® InfoSphere® Optim™ solutions and their features.
Content
- 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 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.
- 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
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. |
- Supports processing of the most common data types for the data source
- Might support or exploit other new features of the data source
Was this topic helpful?
Document Information
Modified date:
08 July 2021
UID
swg27024294