Fix Readme
Abstract
This document provides the list of interim fixes (iFix) provided for IBM InfoSphere Optim Solutions 11.7.0.3 that are included in IBM InfoSphere Optim Solutions V11.7.0.4.
Content
The list of interim fixes (iFix) supplied for IBM InfoSphere Optim Solutions 11.7.0.3 that are included in IBM InfoSphere Optim Solutions V11.7.0.4 for the following IBM InfoSphere Optim components are detailed with this document:
- Optim Runtime Services (Archive, Data Growth Solution and Test Data Management)
- Optim Designer
- Optim Web Applications
Optim Runtime Services
The following table contains the list of interim fixes (iFix) delivered for Optim Distributed 11.7.0.3 that are included in Optim Distributed 11.7.0.4:
| iFix | APAR | Description |
| 1 | IT47892 | 11.7.0.3 iFix 001 |
| 2 | IT47844 | Optim (Convert): Access Violation in LUA with ODPP Hash Lookup |
| 3 | IT47982 | Optim (Convert): Failed PR0CMND Overrides Result in ERRORLEVEL=0 |
| 4 | IT47982 | Optim Connect Server (ODM): not able to connect to Optim datasource after Fix pack 03 installation |
| 5 | IT48041 | Optim (Lua): Change of behavior between 11.7 FP0 and FP2 - WVARCHAR_SZ vs WCHAR change |
| 6 | IT48077 | Optim (DBALIAS): DB2 z/OS DBMS Mismatch Error After Optim 11.7 FP 3 |
| 7 | IT48082 | Optim: Unable to save Archive Collection, memory structure error |
| 8 | IT48081 | Optim (Mixed Case): PostgreSQL support for Mixed Case Table Names |
| 9 | IT48083 | Optim (Convert): ECM -CSV conversion performance has deteriorated in 11.7 FP3 |
| 10 | IT48087 | Optim (View Parsing): View not operational or sync error when creating AD on a table that has '/' in the table name. |
| 11 | IT48095 | Optim Archive File Security: Unable to register SF file due to invalid password |
| 12 | IT48197 | Optim (Load): Error ORA-01862 loading Oracle table with a Column defined as Timestamp with TimeZone |
| 13 | IT48218 | Optim (Load): Load processing may fail with a "memory error" with large Table Map as input |
| 14-A | Cumulative iFix which contains all the prior iFixes | |
| 15 | IT48291 | Optim Connect: Query on character semantic column with index returns wrong results |
| 16 | IT48293 | Optim: Unable to see columns from PostgreSQL table |
| 17 | IT48095 | Optim (PR0CMND): Archive File Security -> Unable to register SF file due to invalid password |
| 18 | IT48330 | Optim (SQL Server): Unable to archive SQL Server table with double quotes in the name |
| 19 | IT48041 | Optim (LUA): Access Violation with Optim 11.7 FP3 and iFix 005. |
| 20 | IT48460 | Optim (Convert): DESTQUAL is an unknown override for Convert |
| 21 | IT48488 | Optim: Archive fails because Primary key is identified but not in table |
| 22 | IT48583 | Optim (Convert) - Row Count Threshold does not work for CSV selection |
The following is the contents of 11.7.0.3 iFix 001. These are iFixes provided for 11.7.0.2 that were not included in 11.7.0.3. They are now included in 11.7.0.4.
| iFix | APAR | Description |
| 40 | IT46792 | Optim (Runtime): Hang Condition Running PR0CMND Convert |
| 41 | IT46793 | Optim: Convert from AF to CSV file results in data changes |
| 42 | IT46844 | Optim: Convert to ECM results in Access Violation |
| 43 | IT46824 | Optim (Extract / Archive): Tables with Partitions and Partitioned Indexes fail with an Access Violation |
| 44 | IT46910 | Optim (Informix): Wrong data generated by Optim Load processing on AIX |
| 45 | IT46956 | Optim: Unable to connect to a Sybase server via the Sybase Linux client |
| 46 | IT47028 | Optim: Report of Compare file does not complete, fails with Access Violation |
| 47 | IT47049 | Optim (Relationships): Previously valid DB2 CHAR to Oracle NUMBER no longer working |
| 48 | IT47073 | Optim (Loader): Sybase Loader does not manage NVARCHAR data types properly |
| 49 | IT47090 | Optim (Centera): Attempting Browse an Archive file on Centera results in error |
| 50 | IT47089 | Optim (View Parser): Access Violation when attempting to create an AD on a view |
| 51 | IT46491 | Optim: Running PR0PASS -a, a userid of more than 12 bytes gets error User Id too long error contrary to the documentation |
| 53 | IT47300 | Optim: Convert to ECM fails with ASSERT File:RtFile.cpp Line:5071 Msg:'nCount != 0' |
| 54 | IT47373 | Optim (POSTGRES): Insert into table fails with message "LOB Handle not an XFM LOB Handle". |
| 55 | IT47410 | Optim (View): OPTIM_DATA_CONSUMPTION_VIEW returns no rows |
| 57 | IT47479 | Optim (Insert): Access Violation on Linux with inserting VARCHAR data |
| 58 | IT47554 | Optim (Convert) - Row Count Threshold does not work as designed |
| 59 | IT47601 | Optim (Action): Insert Action not using the correct Column defined in command |
| 62 | IT47779 | Optim (Archive): Access Violation when Archiving Oracle partitioned tables and indexes |
| 63 | IT47839 | Compare: Customer saves Compare Request but when re-opened, Source File 2 goes back to 1st table in extract list (save ignored) |
| 65 | IT47847 | Optim 11702: z/OS DBAlias on a SQL Server Optim Directory fails Verified by Nat 2025-04-02 |
Optim Designer
There are no interim fixes (iFix) for Optim Designer 11.7.0.3:
Optim Web Applications
There are no interim fixes (iFix) for Optim Web Applications 11.7.0.3.
[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS2NEW","label":"IBM InfoSphere Optim Archive Enterprise Edition"},"ARM Category":[{"code":"a8m0z000000cwv4AAA","label":"Optim Archive"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.7.0"},{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSRPUJ","label":"IBM InfoSphere Optim Archive Workgroup Edition"},"ARM Category":[{"code":"a8m0z000000cwv4AAA","label":"Optim Archive"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.7.0"},{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSMLNW","label":"IBM InfoSphere Optim Data Growth Solution"},"ARM Category":[{"code":"a8m0z000000cwvAAAQ","label":"Optim Data Growth"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.7.0"},{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSWG4L","label":"IBM InfoSphere Optim Data Growth Solution for Oracle Applications"},"ARM Category":[{"code":"a8m0z000000cwvAAAQ","label":"Optim Data Growth"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.7.0"},{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSSGMM","label":"IBM InfoSphere Optim Data Privacy Enterprise Edition"},"ARM Category":[{"code":"a8m0z000000cwv9AAA","label":"Optim Data Privacy"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"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":"SSUFZR","label":"IBM InfoSphere Optim Data Privacy Enterprise Edition for Oracle Application"},"ARM Category":[{"code":"a8m0z000000cwv9AAA","label":"Optim Data Privacy"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.7.0"},{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSRPWG","label":"IBM InfoSphere Optim Data Privacy Workgroup Edition"},"ARM Category":[{"code":"a8m0z000000cwv9AAA","label":"Optim Data Privacy"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.7.0"},{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSLZRR1","label":"IBM InfoSphere Optim Solution for Application Retirement including Archive File Access"},"ARM Category":[{"code":"a8m0z000000cwv4AAA","label":"Optim Archive"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.7.0"},{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSXJ8CO","label":"IBM InfoSphere Optim Solution for Application Retirement - Archive File Access"},"ARM Category":[{"code":"a8m0z000000cwv4AAA","label":"Optim Archive"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.7.0"},{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSRPSN","label":"IBM InfoSphere Optim Test Data Management Enterprise Edition"},"ARM Category":[{"code":"a8m0z000000cwvEAAQ","label":"Optim Test Data Management"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.7.0"},{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSMLQ4","label":"IBM InfoSphere Optim Test Data Management Solution"},"ARM Category":[{"code":"a8m0z000000cwvEAAQ","label":"Optim Test Data Management"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.7.0"},{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"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":"PF025","label":"Platform Independent"}],"Version":"11.7.0"},{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSRPYB","label":"IBM InfoSphere Optim Test Data Management Workgroup Edition"},"ARM Category":[{"code":"a8m0z000000cwvEAAQ","label":"Optim Test Data Management"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.7.0"}]
Was this topic helpful?
Document Information
Modified date:
14 November 2025
UID
ibm17247085