Release notes - IBM InfoSphere Optim 11.7

Contents

• Description
• What's new in 11.7.0 Fix Pack 4
  • Known issues in 11.7.0 Fix Pack 4
• What's new in 11.7.0 Fix Pack 3
  • Known issues in 11.7.0 Fix Pack 3
• What's new in 11.7.0 Fix Pack 2
• What's new in 11.7.0 Fix Pack 1
• What's new in 11.7.0
• Announcement
• IBM Db2 for z/OS Multibyte Character Support
• System requirements
• Fix lists
• Installation instructions for Optim 11.7
• IBM License Metric Tool
• Optim directory support
• Known issues
• Notices

Description

What's new in 11.7.0 Fix Pack 4

Fix Pack 4 for Optim 11.7.0 adds the following functionality:

• Operating system support added for:
  • Windows 2025.
• Database toleration support added for Optim Directory and DB Alias:
  • IBM Db2® 12.1
  • Oracle 23ai.
• Database toleration support added for DB Alias:
  • Teradata 17.20.
• Third party software upgraded:
  • IBM WebSphere Liberty from 24.0.0.12 to 25.0.0.6.
• Create: Don't Convert CLOB to TEXT for Informix
• AWS ENDPOINT Definitions
  • This enhancement provides the capability to override the S3 Region specified for the location of an AWS bucket with an S3 Endpoint. The S3 Region can be overridden to use an S3 Endpoint via a named environment variable (AWS_ENDPOINT_URL_S3). Using an S3 Endpoint will allow the data to go through a private network, which is more secure.

The following functionality is removed from Optim 11.7.0 with Fix Pack 4:

• Remove OptimConfigClient.pst and OptimConfigServer.pst from AIX and Linux installations, as they are not used there.

For the list of interim fixes (iFixes) that are included in Optim 11.7.0 Fix Pack 4, see the IBM InfoSphere Optim Solutions V11.7.0.4 Fix List

Known Issues and Limitations in 11.7.0 Fix Pack 4

1. After updating Runtime Services to 11.7.0.4, maintenance must be applied to all DB Aliases for SQL Server.
2. An update of Runtime Services to 11.7.0.4 from an install that was performed with 11.7.0.0 and 11.7.0.2 simultaneously will fail with the following message, explanation and user action:

   IOQIN0110E: The root installation folder C:\IBM\InfoSphere\Optim is the parent of an RT folder that contains an existing Optim runtime. You cannot overwrite a previous version of Optim with this version.

   Explanation: If you plan on migrating your existing Optim artifacts to the new Optim Directory, you must leave your existing Optim installation intact until after you have migrated your artifacts using the configuration program installed with this component.

   User Action: Choose another installation folder where the root folder is not the parent of an existing Optim runtime or uninstall the Optim runtime installed in the folder C:\IBM\InfoSphere\Optim\rt\bin.

   The fix for this is to rename the file services\version\version_11.7.0.2.txt to services\version\version_11.7.0.0.txt. After doing this, the update to 11.7.0.4 will complete successfully.

3. The SQL Server HEIRARCHYID and SQL_SPATIAL data types are not supported on Linux and AIX. They are supported on Windows.

What's new in 11.7.0 Fix Pack 3

Fix Pack 3 for Optim 11.7.0 adds the following functionality:

• Operating system support added for:
  • RHEL 9.
• Database toleration support added for:
  • IBM Db2® 13 for z/OS.
  • Informix 14.10.
• Third party software upgraded:
  • IBM WebSphere Liberty from 23.0.0.3 to 24.0.0.12.
• Services that are in progress can be stopped through Manager and Designer.
• Special characters can be used in table and column names for Microsoft SQL Server.
• DBMS password length increased from 30 to 64 characters.

The following functionality has been removed from Optim 11.7.0 with Fix Pack 3:

• Data Explorer, rt/search/optim.search.data.explorer_1.0.0.1.zip, is no longer included.
• The Runtime Services installer no longer prompts if the Attunity patch should be put on the system.

For the list of interim fixes (iFixes) that are included in Optim 11.7.0 Fix Pack 3, see the IBM InfoSphere Optim Solutions V11.7.0.3 Fix List

Known issues in 11.7.0 Fix Pack 3

1. An update of Runtime Services to 11.7.0.3 from an install that was performed with 11.7.0.0 and 11.7.0.2 simultaneously will fail with the following message:

   IOQIN0110E: The root installation folder C:\IBM\InfoSphere\Optim is the parent of an RT folder that contains an existing Optim runtime. You can not overwrite a previous version of Optim with this version.

   Explanation: If you plan on migrating your existing Optim artifacts to the new Optim Directory, you must leave your existing Optim installation intact until after you have migrated your artifacts using the configuration program installed with this component.

   User Action: Choose another installation folder where the root folder is not the parent of an existing Optim runtime or uninstall the Optim runtime installed in the folder C:\IBM\InfoSphere\Optim\rt\bin.

   The fix for this is to rename the file services\version\version_11.7.0.2.txt to install\services\version\version_11.7.0.0.txt. After doing this, the update to 11.7.0.3 will complete successfully.

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.

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;

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

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

IBM Db2 for z/OS® Multibyte Character Support

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:

Known issues

Notices

The NOTICES file is at installation directory\license\notices.txt.