IBM Support

IBM InfoSphere Optim Solutions V11.7.0.2 Fix List

Fix Readme


Abstract

This document provides the list of interim fixes (iFix) provided for IBM InfoSphere Optim Solutions 11.7.0.1 that are in IBM InfoSphere Optim Solutions V11.7.0.2.

Content

The list of interim fixes (iFix) supplied for IBM InfoSphere Optim Solutions 11.7.0.1 that are included in IBM InfoSphere Optim Solutions V11.7.0.2 for the following IBM InfoSphere Optim component are detailed with this document:
  1. Optim Distributed (Archive, Data Growth Solution and Test Data Management)
Optim Distributed
The following table contains the list of interim fixes (iFix) delivered for Optim Distributed 11.7.0.1 that are included in Optim Distributed 11.7.0.2:
iFix APAR Description
1 IT43278 Optim (Convert): Target file not being compressed
2 IT43398 Optim (SQL Loader): Port number is not added for all tables in the generated BCP command line options
3 IT43362 Optim:  Is it possible to exclude spatial column types from SQL Server load file?
4 IT43470 Optim (View Parser):  Comments (--) in View fail to be parsed resulting in a "View Error"
5 IT43538 Optim (PURGEDBA):  /PURGEDBA function does not work if database is not available
6 IT43608 1) App Server Applet - the warning  'Run time services could not be started (Unknown error)' is returned if Enable Runtime Services is not checked and server is started. Server does start.
2) Optim (Configuration): Applying maintenance to a SQL SERVER 2019 DBALIAS with Optim 11.7.1 causes access violation
7 IT43632 Optim (LUA):  LUA script failure after upgrade to Optim 11.7
008-T N/A *** Accumulative iFix containing all published iFixes through 7***
9 IT43690 Optim (Security): Unable to modify Role with Optim 11.7.0.1
10 IT43784 Optim: UPDATE process fails after first row is processed
11 IT43829 Optim (Transformation): TRANS SSN failing to convert records
12 IT43837 Optim (View Parser): View Error in SQL Server Binary database
13 IT43903 Optim (Archive - Browse): File could not be opened message not percolating message to Archive Report
14 IT43913 Optim (Runtime): ORA-06502: PL/SQL: numeric or value error: host bind array too small ORA-06512
15 IT43932 Optim (Relationships):  INT and NVARCHAR The Datatypes are not compatible.
16 IT43981 Optim (Convert): Lookup function to return more accurate return code in trace when data not found
17 IT43999 Optim (LUA); LUA tracing, activated by COL 16, fails with an extremely large procedure
18 IT43994 Optim (DBMS Index): Archiving / Extracting a table with a specific DBMS defined index fails with an Access Violation
019-T N/A *** Accumulative iFix containing all published iFixes through 18***
20 IT43136 Optim (Browse):  Extract file Join of MS SQL Server table and DB2 z/OS table yields invalid results
21 IT44210 Optim (LUA):  getcolumnvalue function appends a '0' to variable assignment
22 IT44207 Optim (Load): Column map required with computed columns when loading SQL Server table
23 IT44125 Optim (Convert): Converting RAW type column to CSV results in binary data that cannot be displayed
24 IT44221 Optim (PR0CMND): Concurrent Extract/Convert requests fail because tmp file could not be opened
25 IT44352 Optim (Restore): PR0CMND parameter file with OVERRIDES fails
026-A   *** Accumulative iFix containing all published iFixes through 25***
27 IT44352 Optim (Restore): PR0CMND parameter file with OVERRIDES fails
28 IT44432 Optim (XML Reporting):  Expand 10MB limit
29 IT43632 Optim (LUA):  LUA script failure after upgrade to Optim 11.7
30 IT44352 Optim (Restore): PR0CMND parameter file with OVERRIDES fails
31 IT44519 Optim (PR0CNFG):  Task Merge_Current_User  fails with an Access Violation
32 IT44518 Optim (Convert) - ECM convert of an Archive File with large quantity of tables does not work
33 IT44667 Optim: Archive of related tables on Oracle 19c warns of relationship unknown

[{"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":"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":"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":"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":"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":"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":"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":"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":"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":"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":"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":"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":"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":"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":"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":"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":"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":"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":"PF025","label":"Platform Independent"}],"Version":"11.7.0"}]

Document Information

Modified date:
09 November 2023

UID

ibm17051220