IBM Support

IBM InfoSphere Information Server, Version 11.7 Fix Pack 2 Fix List

Fix Readme


Abstract

Summary of fixes included in the IBM InfoSphere Information Server, Version 11.7 Fix Pack 2.

Content

The following list contains APARs included in InfoSphere Information Server, Version 11.7.0.2 (fix pack 2).

Fix pack 2 contains the fixes listed below which were released after the availability of Information Server 11.7.0.1 (11.7 Fix Pack 1).   This includes fixes that were contained in 11.7.0.1 Service Pack 1.

To see the more detail on the list of fixes included in base level and fix pack 1, refer to the following 2 technotes:
InfoSphere Information Server, Version 11.7.0.0 fix list
InfoSphere Information Server, Version 11.7 Fix Pack 1 fix list

Fix pack 2 can be downloaded from Fix Central via the following download document:
IBM InfoSphere Information Server, Version 11.7.0.2 (Fix Pack 2)

*Fixes that have an asterisk by the Fix ID may require post-install steps to activate. Please refer to the following document for details on how to activate those fixes:
InfoSphere Information Server Version 11.7 fixes that require post-installation steps



Connectivity - IBM

APAR
Description
JR58858 Support for the HTTP / Knox in the JDBC Hive Driver
JR59180 IA job using DB2 connector fails after IIS upgrade to 11.7
JR59186 When DB2 Connector uses Derivation the columns mismatch occurs and the job aborts with error
JR59342 DB2 Connector loses rejected rows if there are more than 32767 failing rows in a parameter array
JR59467 Runtime Column Propagation (RCP) causes job error for File Connector stage using ORC/Parquet file format
JR59518 Netezza connector fails with code 139 when file with user-defined SQL does not exist
JR59537 Cognos TM1 Connector and IMAM View Assets fails when dimension name contains ampersand character
JR59561 Job aborts when DB2 connector reports a warning when parsing SQL
JR59625 No schema reconciliation when Table Action is set to Create or Replace
JR59655 Unnecessary queries to DB2 for z/OS when DB2 connector operates in 'read' mode
JR59682 DataDirect JDBC Driver for Hive update to version 6.0.1.000081
JR59692 Hive Connector fails to parse query when parallel read is enabled and keywords are part of the column name
JR59696 Password logged in clear text during metadata import
JR59743 DB2 connector fails to write data into tables created with DISTRIBUTE BY RANDOM clause
JR59775 DB2 connector server job with column derivation fails during schema reconciliation
JR59787 DB2 Connector migrated from DB2 API stage fails to match design and external schema columns
JR59790 DB2 Connector not correctly extracting DECFLOAT datatype when handled as DECIMAL
JR59859 DataDirect JDBC Driver for Hive update to version 6.0.1.000092
JR59901 Netezza Connector fails on transient external table statement when inserting to NPS 7.0.2


Connectivity - non-IBM

APAR
Description
JR58600 ODBC Connector Sybase ASE BulkLoad jobs abort with NULL column values
JR59586 DataDirect Teradata ODBC driver without libtdgss dependency
JR59603 Connector Migration tool (CMT) removes WHERE keyword in SQL when Oracle OCI Plugin (ORAOCI9) has nested where clauses
JR59610 Server oracle connector jobs fails with ORA-24374 when both "Before SQL" & "Select statement" exists in same stage
*JR59624 DB2 Stage jobs migrated to DB2 Connector generate correct but unwanted IIS-CONN-DAAPI-000398/399 warnings
JR59614 Temporary files are not deleted in scratch directory after IQ write using Sybase EE on Linux
JR59726 Support Schema Reconciliation in GreenPlum Connector
JR59626 CMT GUI (Connector Migration Tool) on IS 11.5 and 11.7 is not working for Oracle Client version 12
*JR59707 Add support for disabling Batch Error Mode for Oracle Connector running PL/SQL block as source stage.
JR59611 Support of Salesforce Multi Level Relationships for Query Operations
JR59756 Support of TLS 1.2 ECDHE* Cipher suites in DataDirect ODBC Drivers
*JR59580 Cannot create new record when the reference field is null using Salesforce Connector
JR59718 Describe all the unsupported datatypes as UNKNOWN columns while importing metadata using Oracle connector
*JR59823 Oracle connector on server canvas (Non-NLS environment) is unable to load accentuated characters
JR59855 Add support for range partition for ASEWrite in Sybase operator
JR59806 Unable to compile jobs migrated to Oracle Connector with the Partition Table and the User Defined SQL
JR59839 Salesforce Connector in Bulk Mode for query operations extracts NULL value for reference fields
JR59836 File Connector rounds a number while reading a decimal field with large scale from an ORC file
JR59663 Invalid JSON may cause parser to skip valid rows

*To use this fix in your jobs, refer to InfoSphere Information Server Version 11.7 fixes that require post-installation steps


DataStage Core / Engine

APAR
Description
JR58962 Ops Console UI not displaying disk space for compute nodes on mounted settings
JR59175 Properties of an opened Job can not see updated information after a Parameter Set is modified.
JR59287 Incorrect sort icon on link in job design
JR59409 QS Match designer fails to run tests when target columns have non-ascii characters.
JR59445 Designer crashes when large properties are being processed in the IDOC stage editor
JR59455 Second sort key in LinkCollector stage does not work
JR59529 There is a potential for memory growth on the services tier relating to the reading of job graph deflator properties
JR59710 EngMonApp service stopped due to SQL Error: ERRORCODE=-4461, SQLSTATE=42815
*JR59741 Optionally enforce full suite logon for the dsjob commandline tool
JR59825 Project creation enhancements for DataStage Flow Designer
JR59828 Generated report for Advanced Find for column does not have containing object result
JR59949 Windows 2016 event errors when Director selects schedule

*To use this fix in your jobs, refer to InfoSphere Information Server Version 11.7 fixes that require post-installation steps


DataStage Flow Designer

APAR
Description
JR59131 Addressed issues with DataStage Flow Designer server scripts on the engine tier for AIX.
JR59080 Added user roles support.
JR59658 Install of FixPack 1 may hang running addDFDStartUp.sh/addDFDStartUp.bat per ISInstall log field.
JR59927 Error message Unparseable date: "Tue May 29 12:38:54 CST 2018" when open job in DataStage Flow Designer

DataStage Parallel Engine

APAR
Description
JR59189 Make buildop Operator wave aware.
JR59463 Revise Parallel Engine file system sync behavior for better performance.
JR59562 File import pattern using fileset option does not match file names containing quotes.
JR59648 Fix thread safety issues in APT_Archive and PX control services.
JR59802 Correction in APAR JR58883 to support DB2 Surrogate Key Stage password.
JR59838 Set APT_PRESERVER_SEQUENCE_OP_SEQ to 1 to keep "Sequential execution mode" of a Sequence stage.
JR59919 Parallel job can hang if it has a combined operator containing two sort stages feeding a join stage.
JR60095 Implementation of various checkpoint features as described below.
JR60096 Supporting HDFS for scratch.
JR60097 Add locking to start-pxyarn.sh.
JR60098 Add memory pool size command line option.
JR60099 Code changes for support of bounded memory for join.
JR60100 Switch back to using local /tmp for binary localization.
JR60101 Add support for Dataset compression.
JR60102 BigIntegrate Localization Serviceability Enhancements.
JR60103 APT_PM_CONNECTION_CONCURRENCY set in YARN mode causes job failure
JR60104 Ambari Integration Enhancements.
JR60105 Checkpoint operator: implement options for varying the memory block and file size.


Information Analyzer (IA)

APAR
Description
JR59498 Rules Binded with SqlVT columns are failing when setCredentialMapping is used.
JR59602 Display of Column Analysis result with Information Analyzer Thin Client failed for IADB located on Micrososft SQL Server.
JR59607 User with 'Rule Author' role cannot delete the rules owned in IA thick client in LDAP based authentication.
JR59628 DataRule fails when joins are involved with files imported using file connector (with no metadata defined) and oracle table.
JR59688 Import of rule executables via IAAdmin does not work if the associated rule definition already exists.


Information Governance Catalog (IGC)

APAR
Description
JR59132 Excessive quotes in the Source/Target Columns during export of extension mapping document to the CSV file
JR59190 Export of extension mapping documents does not keep the folder hierarchy structure
JR59370 Improve performance of an endpoint for updating single asset
JR59556 Data File, DFR or DFF searches unable to filter on folder or path
JR59578 During the ISX export of extension mapping documents IGC picks up the deleted asset information from the MwbExtensions model


Information Server Framework(ISF)

APAR
Description
JR58645 "No Active Transactions" error while browsing terms in Information Governance Catalog
JR59546 Use user or default DataStage credentials when shared credentials are not found
JR59674 ISES or new IGC login with federated repository fails if user id case does not match that from LDAP
JR59793 Information Server Console shuts down itself after running for about an hour


Installation

APAR
Description
JR59579 Information Server is affected by a weak password encryption vulnerability
JR59701 Incorrect DB2 license file
JR59721 Information Server installers are affected by vulnerabilities in Eclipse Jetty
JR59843 Installation hangs if InformationServer directory has group permission "rws" OR "r-s" rather than "rwx"


Metadata Asset Manager (IMAM)

APAR
Description
JR59125 An error occurred while importing OBIEE metadata using bridge in IMAM
JR59623 Import of SAP Powerdesigner v16.5 PDM file failed with [MIRSDK_F0004] Illegal Argument
JR59659 IMAM import Erwin xml missing domains in IGC

.


For searchability, the following APARs were included in Information Server 11.7 Fix Pack 1 and thus are also included in Fix Pack 2 as fix packs are cumulative service:

JR37559, JR54016, JR56177, JR57408, JR57629, JR57631, JR57925, JR58164, JR58244, JR58343, JR58351, JR58378, JR58389, JR58477, JR58478, JR58488, JR58489, JR58507, JR58523, JR58536, JR58563, JR58574, JR58597, JR58601, JR58612, JR58629, JR58633, JR58662, JR58665, JR58690, JR58694, JR58698, JR58701, JR58707, JR58719, JR58728, JR58751, JR58752, JR58756, JR58777, JR58792, JR58795, JR58800, JR58810, JR58812, JR58813, JR58821, JR58823, JR58826, JR58831, JR58843, JR58848, JR58853, JR58857, JR58866, JR58875, JR58883, JR58884, JR58888, JR58895, JR58896, JR58900, JR58910, JR58913, JR58920, JR58929, JR58931, JR58933, JR58934, JR58935, JR58936, JR58943, JR58944, JR58947, JR58968, JR58969, JR58978, JR58983, JR58986, JR58988, JR58994, JR59005, JR59006, JR59010, JR59024, JR59028, JR59030, JR59033, JR59036, JR59037, JR59052, JR59053, JR59054, JR59067, JR59081, JR59083, JR59096, JR59097, JR59101, JR59103, JR59105, JR59108, JR59109, JR59115, JR59121, JR59127, JR59135, JR59136, JR59140, JR59143, JR59148, JR59158, JR59161, JR59166, JR59179, JR59180, JR59186, JR59209, JR59214, JR59221, JR59222, JR59229, JR59230, JR59234, JR59243, JR59251, JR59255, JR59265, JR59270, JR59275, JR59277, JR59280, JR59280, JR59284, JR59298, JR59300, JR59319, JR59322, JR59326, JR59337, JR59340, JR59351, JR59358, JR59360, JR59361, JR59381, JR59389, JR59416, JR59430, JR59446, JR59461, JR59468, JR59521, JR59658

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Component":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"11.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
07 January 2019

UID

ibm10733711