Fix Readme
Abstract
This document provides the list of interim fixes (iFix) provided for IBM InfoSphere Optim Solutions 11.7.0.0 that are in IBM InfoSphere Optim Solutions V11.7.0.1.
Content
The list of interim fixes (iFix) supplied for IBM InfoSphere Optim Solutions 11.7.0.0 that are included in IBM InfoSphere Optim Solutions V11.7.0.1 for the following 4 IBM InfoSphere Optim components are detailed with this document:
- Optim Data Privacy
- Optim Designer
- Optim Runtime Services
- Optim Distributed (Data Growth Solution and Test Data Management)
Optim Data Privacy
The following table contains the list of interim fixes (iFix) delivered for Optim Data Privacy 11.7.0.0 that are included in Optim Data Privacy 11.7.0.1:
| iFix | APAR | Description |
| 1 | Netezza ODDP and UDF functions are holding memory and making SPU non-usable for other requests and automatic restart | |
| 2 | UDF Netezza: UDF - Incorrect email validation and incorrect behavior of WHENINV=PRE | |
| 3 | Netezza ODDP and UDF functions are holding memory and making SPU non-usable for other requests and automatic restart | |
| 4 | 1) ODPP EML: Inconsistent results across test cases for EML provider in specific cases 2) UDF Netezza: UDF - Incorrect email validation and incorrect behavior of WHENINV=PRE |
|
| 5 | Netezza ODDP and UDF functions are holding memory and making SPU non-usable for other requests and automatic restart |
Optim Designer
The following table contains the list of interim fixes (iFix) delivered for Optim Data Designer 11.7.0.0 that are included in Optim Designer 11.7.0.1:
| iFix | APAR | Description |
| 1 | IP24400 | Optim (Designer): Import of Load Request to Optim Designer fails with an error |
| 2 | IP24408 | 1) Designer: Switching Optim Directory to sqlserver causes pr0cnfg to hang when override url is used for optim dir in OCM 2) Optim (Designer): Cannot configure DBALIAS for a SQL SERVER db in Designer if the DBALIAS name and Optim directory name are the same |
| 3 | IT42430 | Optim Designer: Deleted columns still shown in AD and newly added columns do not show in the AD |
Optim Runtime Services
The following table contains the list of interim fixes (iFix) delivered for Optim Runtime Services 11.7.0.0 that are included in Optim Runtime Services 11.7.0.1:
| iFix | APAR | Description |
| 4 | IT42615 | Optim: HTTPS endpoint security issue - RFC 6797 |
Optim Distributed
The following table contains the list of interim fixes (iFix) delivered for Optim Distributed 11.7.0.0 that are included in Optim Distributed 11.7.0.1:
| iFix | APAR | Description |
| 1 | IP24213 | Optim (Convert): TRANS PRO AGE on Postgres (or Oracle) Date Column Fails with FLDDEF Type definition errors |
| 2 | IP24391 | Optim (LUA): Fall out from iFix 187 with Optim field code |
| 3 | IP24393 | Optim (Oracle 9i): Release 11.7 will not connect to Oracle 9i database |
| 4 | IP24394 | Improve Optim TDM stored procedures to minimize impact of sql injection attacks: MS SQL Server 2017 and 2019 |
| 5 | IP24372 | Optim (Load): XFM (COL Services) Error when building SQL Server Load process |
| 6 | IP24373 | Optim (PR0CNFG): Purge DBALIAS task from Command line fails with no DBALIAS connectivity |
| 7 | IP24383 | Optim (Compare): Comparing z/OS and LUW Extracts results in "Incompatible Data Types" for character columns |
| 8 | IP24384 | Optim (PR0CNFG): Command line utility does not recognize SQL Server 2014 when creating a DBALIAS |
| 9 | IP24389 | Optim (TRANS COL): TRANS COL ('UNIQUE') is not behaving correctly with specific table |
| 10 | IP24382 | Optim (Import): Import resetting "Header Delimiter" to default value |
| 11 | IT43285 | Optim: Add Apache Hive 3.1.3 support |
| 12 | IP24396 | Optim (Shuffle): Message, "Unhandled error from Data Process Module" reported when running a Convert process |
| 13 | IP24397 | Optim (Insert): Insert process fails, containing a Convert Request with Shuffle function |
| 14 | IP24401 | Optim (Load): SQL Server load fails into table with computed columns |
| 15 | IP24402 | Optim (Restore): Restore Selection Criteria Error when using wildcards |
| 16 | IP24403 | Optim (LUA): Convert process fails with error referencing the l_SetColumnValue function |
| 17 | IP24399 | Optim: Unable to write all Teradata loader files to shared drive |
| 18 | IP24406 | Optim (Column Map): Access Violation occurs with Shuffle function and LUA script within same Column Map |
| 20 | IP24407 | Optim: Email notification status is "Completed" even when the Delete request failed |
| 21 | IP24405 | Optim (Insert): Insert with recursive constraint doesn't work on Linux, but correctly works on Windows |
| 23 | IT42251 | Optim 11.7 Access Violation Trying to Access Views |
| 24 | IP24390 | Optim (TDM): Error "Table 'POSTGRESQL.postgres.v_optim_customers' is defined in the AD but it is inaccessible" during Extract on Linux and PostGreSQL with iFix -096-A |
| 25 | IT42277 | Optim (Unix 117 AIX): Server fails to start on AIX |
| 26 | IT42288 | Optim (11.3 Unix): Error-less PSTPASS file reports corrupt file after Optim 11.7 upgrade |
| 28 | IT42407 | Optim (Import): Convert Request with Table Map results in an Access Violation |
| 30 | IT42501 | Optim (Lua): Truncation error with z/OS VARCHAR column defined as SBCS data |
| 30 | IT42501 | Optim (Lua): Truncation error with z/OS VARCHAR column defined as SBCS data |
| 31 | IT42586 | Optim: No OptimConfig PST files update required for PR0CMND, PR0SVCE & PR0SVER processes |
| 32 | IT42585 | Optim (Runtime): Oracle Load request failing with Character Semantic defined columns |
| 33 | IT42587 | Optim: Load into DB2 Generated Always Identity column with Identity Override fails to override values |
| 35 | IT42647 | Optim: Error message "Encountered an improper argument" while adding/deleting roles to an existing FAD |
| 36 | IT42714 | Optim (Scheduler): Multi-step job results in Access Violation in the Scheduler code |
| 37 | IT42731 | Optim (Runtime): Oracle NUMBER Columns losing precision values |
| 38-A | *** Accumulative iFix containing all published iFixes through 37 *** | |
| 39 | IT42779 | Optim (Compare): Unable to browse table - Assert - hbm error |
| 40 | IT42501 | Optim (Lua): Truncation error with z/OS VARCHAR column defined as SBCS data |
| 41 | IT42587 | Optim: Load into DB2 Generated Always Identity column with Identity Override fails to override values |
| 42 | IT43077 | Optim (Federation): SQLSTATE 01003 Extracting NULL Values From View Based On A Nickname |
| 45 | IT43134 | Optim (Browse): Using the Join facility using a file via the Optim Server will fail with no Child rows displayed |
| 46 | IT43136 | Optim (Browse): Extract file Join of MS SQL Server table and DB2 z/OS table yields invalid results |
| 47 | IT43180 | Optim (Load): Load does not generate 'LOG NO' statement in DB2 zOS LOAD commands |
| 48 | IT43212 | Optim: Internal Oracle NEXTVAL functionality limited to just NUMERIC columns |
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS2NEW","label":"IBM InfoSphere Optim Archive Enterprise Edition"},"ARM Category":[{"code":"a8m0z000000cwv4AAA","label":"Optim Archive"}],"Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"11.7.0"},{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSRPUJ","label":"IBM InfoSphere Optim Archive Workgroup Edition"},"ARM Category":[{"code":"a8m0z000000cwv4AAA","label":"Optim Archive"}],"Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"11.7.0"},{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSMLNW","label":"IBM InfoSphere Optim Data Growth Solution"},"ARM Category":[{"code":"a8m0z000000cwvAAAQ","label":"Optim Data Growth"}],"Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"11.7.0"},{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSWG4L","label":"IBM InfoSphere Optim Data Growth Solution for Oracle Applications"},"ARM Category":[{"code":"a8m0z000000cwvAAAQ","label":"Optim Data Growth"}],"Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"11.7.0"},{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSSGMM","label":"IBM InfoSphere Optim Data Privacy Enterprise Edition"},"ARM Category":[{"code":"a8m0z000000cwv9AAA","label":"Optim Data Privacy"}],"Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"11.7.0"},{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSRPWG","label":"IBM InfoSphere Optim Data Privacy Workgroup Edition"},"ARM Category":[{"code":"a8m0z000000cwv9AAA","label":"Optim Data Privacy"}],"Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"11.7.0"},{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSXJ8CO","label":"IBM InfoSphere Optim Solution for Application Retirement - Archive File Access"},"ARM Category":[{"code":"a8m0z000000cwv4AAA","label":"Optim Archive"}],"Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"11.7.0"},{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLZRR1","label":"IBM InfoSphere Optim Solution for Application Retirement including Archive File Access"},"ARM Category":[{"code":"a8m0z000000cwv4AAA","label":"Optim Archive"}],"Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"11.7.0"},{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSRPSN","label":"IBM InfoSphere Optim Test Data Management Enterprise Edition"},"ARM Category":[{"code":"a8m0z000000cwvEAAQ","label":"Optim Test Data Management"}],"Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"11.7.0"},{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSMLQ4","label":"IBM InfoSphere Optim Test Data Management Solution"},"ARM Category":[{"code":"a8m0z000000cwvEAAQ","label":"Optim Test Data Management"}],"Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"11.7.0"},{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSWG5Q","label":"IBM InfoSphere Optim Test Data Management Solution for Oracle Applications"},"ARM Category":[{"code":"a8m0z000000cwvEAAQ","label":"Optim Test Data Management"}],"Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"11.7.0"},{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSRPYB","label":"IBM InfoSphere Optim Test Data Management Workgroup Edition"},"ARM Category":[{"code":"a8m0z000000cwvEAAQ","label":"Optim Test Data Management"}],"Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"11.7.0"}]
Was this topic helpful?
Document Information
Modified date:
06 October 2023
UID
ibm16966972