Release notes - IBM InfoSphere Optim 11.7
IBM® InfoSphere® Optim™ 11.7, which supports data growth, data masking, test data management, and application retirement initiatives for your relational data, is available. These release notes address compatibility, installation, and other getting-started issues.
Contents
Description
- With the archiving or data growth features of Optim, you can segregate historic data from current activity and safely remove it to secure offline storage, access the archived data easily, and restore archived data to its business context when necessary.
- The Optim test data management capacity lets you create and populate appropriately sized development and test environments, automatically or manually edit the data in these environments to match your test cases, and compare test results with your original data.
- Data masking features help you to prevent misuse of information by masking, obfuscating, and privatizing personal information that is propagated outside your production environment.
What's new in 11.7.0 Fix Pack 2
Fix Pack 2 for Optim 11.7.0 adds the following functionality:
- Operating system support added for:
- Microsoft Windows 11.
- Microsoft Windows Server 2022.
- Database toleration support added for:
- Microsoft SQL Server 2022 as an Optim Directory and Database Alias.
- PostgreSQL 15 as a Database Alias.
- Third party software upgraded:
- IBM WebSphere Liberty from 21.0.0.6 to 23.0.0.3.
- LOB handling performance improvements for DB2® and Oracle.
- Microsoft SQL Server Load on Linux.
- Support for table and column names increased from 64 characters to 128 characters. For actions needed to be taken for this to work, see Support for 128 character table and column names.
- SQL Injection vulnerability fixed in Optim Stored Procedures for Microsoft SQL Server 2016.
- Increase length of passwords from 30 to 64 characters.
The following functionality has been removed from Optim 11.7.0 with Fix Pack 2:
- All Optim Data Privacy Providers (ODPP) for Windows 32-bit.
- Installation of IBM SWIDTAG files that are used by the IBM License Metric Tool (ILMT). These are now parts that are included with Optim on Passport Advantage.
For the list of interim fixes (iFixes) that are included in Optim 11.7.0 Fix Pack 2, see the IBM InfoSphere Optim Solutions V11.7.0.2 Fix List.
sp_rename '{Owner ID}.PSTARCVTBL3', 'PSTARCVTBL3_11701';
CREATE TABLE [{Owner ID}].[PSTARCVTBL3](
[ARCHIVEID] [int] NOT NULL,
[TABLEDBALIAS] [nvarchar](12) NOT NULL,
[TABLECREATORID] [nvarchar](64) NOT NULL,
[TABLENAME] [nvarchar](128) NOT NULL,
[TABLEID] [int] NOT NULL,
[STARTTABLEFLAG] [char](1) NOT NULL,
[CHECKSUM] [int] NOT NULL,
[SEQNO] [int] NOT NULL,
[TABLEDATA1] [varchar](250) NOT NULL,
[TABLEDATA2] [varchar](250) NOT NULL,
[TABLEDATA3] [varchar](250) NOT NULL,
[TABLEDATA4] [varchar](250) NOT NULL,
[TABLEDATA5] [varchar](250) NOT NULL,
[TABLEDATA6] [varchar](250) NOT NULL
);
INSERT INTO {Owner ID}.PSTARCVTBL3 SELECT * FROM {Owner ID}.PSTARCVTBL3_11701;
sp_rename '{Owner ID}.PSTAUDIT3', 'PSTAUDIT3_11701';
CREATE TABLE [{Owner ID}].[PSTAUDIT3](
[DBALIAS] [nvarchar](12) NOT NULL,
[CREATORID] [nvarchar](64) NOT NULL,
[TABLENAME] [nvarchar](128) NOT NULL,
[USERID] [nvarchar](85) NOT NULL,
[AUDIT_TYPE] [char](1) NOT NULL,
[ACTION_DT] [datetime] NOT NULL,
[SEQNO] [decimal](20, 0) NOT NULL,
[SUBSEQNO] [int] NOT NULL,
[CHECKSUM] [int] NOT NULL,
[DATA1] [varchar](255) NOT NULL,
[DATA2] [varchar](255) NOT NULL,
[DATA3] [varchar](255) NOT NULL,
[DATA4] [varchar](255) NOT NULL
);
INSERT INTO {Owner ID}.PSTAUDIT3 SELECT * FROM {Owner ID}.PSTAUDIT3_11701;
{Owner ID}
is the Optim Directory Owner ID schema specified when
the Optim Directory was created. If
it is not known, you can navigate to the Optim Directory dialog and click the Modify
button. The value can be found in the Procedure
Qualifier field on the Server tab.What's new in 11.7.0 Fix Pack 1
Fix Pack 1 for Optim 11.7.0 adds the following functionality:
- Database Toleration support added for:
- Oracle 21c for both the Optim Directory and as a DB Alias.
- PostgreSQL 12, 13 and 14 as a DB Alias.
- Teradata 16.10, 16.20, 17.10 and 17.20 as a DB Alias.
- Cloud Storage support to store Optim
Archive Files for:
- IBM Cloud Storage Simple Storage Service (ICOS S3).
- Amazon Web Services Simple Storage Service (AWS S3).
- A new, refreshed user interface for the Optim Connection Manager.
- Optim Service Interface enhancements:
- Service sets support.
- Service monitoring filters.
- TLS 1.3 is the default used by Designer, Manager and Runtime Services.
- Integration with IBM Data Virtualization Manager:
- Using JDBC on Linux or Windows.
- Using ODBC on Windows.
- To prevent Server Side Request Forgery, the ability to whitelist IP addresses for the Optim Web Applications use has been added. See How to Prevent Server Side Request Forgery in the IBM InfoSphere Optim Solutions Web Applications for more information about this and instructions on how to configure it.
The following functionality has been removed from Optim 11.7.0 with Fix Pack 1:
- The use of Dojo.
For the list of interim fixes (iFixes) that are included in Optim 11.7.0 Fix Pack 1, see the IBM InfoSphere Optim Solutions V11.7.0.1 Fix List.
What's new in 11.7.0
- Microsoft Windows 2019.
- RHEL 8.
- SUSE 15.
- AIX 7.2 TL4.
- Microsoft SQL Server 2016 on AIX and Linux.
- Microsoft SQL Server 2017 on AIX and Linux.
- Microsoft SQL Server 2019 on all Optim supported platforms.
Use of the Windows registry has been removed.
A new data masking verification feature is provided.
The silent install process has been streamlined through the Optim Utility Scripts.
WebSphere Liberty replaces WebSphere Application Server Community Edition (WASCE).
Support for IPv6 on Windows only.
Optim now has Java as a pre-requisite, rather than including it.
Support for Optim Data Privacy Provider (ODPP) User Defined Functions (UDFs) in Netezza 11.2 (64-bit only, as Netezza 11.2 is 64-bit only).
Announcement
- Detailed product description, including a description of new functions.
- Product-positioning statement.
- Packaging and ordering details.
- International compatibility information.
IBM Db2 for z/OS Multibyte Character Support
- Db2 LUW v9.7 FixPack 5 or higher is required on the Optim client/server.
- Optim Load into a Db2 z/OS system does not support object names (for example, table names, column names, and so on) that contain MBCS-type characters.
- CLOB and DBCLOB data is not supported in an ASCII or Unicode tablespace.
System requirements
For information about hardware and software compatibility, see the Detailed System Requirements report that is available from the IBM Software Product Compatibility Reports (SPCR) tool.
Fix lists
For a summary list of fixes that are included in release 11.7, see the IBM InfoSphere Optim V11.7.0 Fix List..
For the list of interim fixes (iFixes) that are included in Optim 11.7.0 Fix Pack 1, see the IBM InfoSphere Optim Solutions V11.7.0.1 Fix List.
For the list of interim fixes (iFixes) that are included in Optim 11.7.0 Fix Pack 2, see the IBM InfoSphere Optim Solutions V11.7.0.2 Fix List.
Installation instructions for Optim 11.7
To install Optim 11.7, please complete the installation instructions that are detailed separately in the Optim documentation.
IBM License Metric Tool
The files used by the IBM License Metric Tool
(ILMT) are installed with an extension of optswidtag
. After you
configure the first workstation, the files to which you have been granted access
will have their extensions changed to swidtag
.
If you use ILMT, complete the following manual process to activate it for data sources that do not reside on an Optim server or on a z/OS system:
- Locate the set of *.swidtag files residing at:
Optim_Root\properties\version
on the Optim server. - Copy the
*.swidtag
files to:\\server_root\IBM\InfoSphere\Optim\ITLM
on any server hosting data sources on which you are using Optim.
Optim directory support
For release 11.7 of the Optim solutions, the Optim directory is supported on the following database management systems:
Db2 for Linux®, UNIX, and Windows | Oracle | SQL Server |
---|---|---|
v9.5 (FP10 or later) | v11g R1 (11.1.0.7 or later) | 2008 R1 |
v9.7 | v11g R2 (11.2) | 2008 R2 |
v10.1 | v12c R1 | 2012 |
v10.5 | v12c R2 | 2014 |
v11.1 | v18c | 2016 |
v11.5 | v19c | 2017 |
2019 |
Known issues
Notices
The NOTICES file is at installation
directory\license\notices.txt
.