============================================================================ IBM i Access Client Solutions - PASE Application Package 5733-XJ1 Version: 1.1.0.14 (c) Copyright IBM Corporation 2020. All rights reserved. ============================================================================= NOTICE: Application of this Service Pack may disable or render ineffective programs that use system memory addresses not generated by the IBM translator, including programs that circumvent control technology designed to limit interactive capacity to purchased levels. This Service Pack may be a prerequisite for future Service Packs. By applying this Service Pack you authorize and agree to the foregoing. This Service Pack is subject to the terms of the license agreement which accompanied, or was contained in, the Program for which you are obtaining the Service Pack. You are not authorized to install or use the Service Pack except as part of a Program for which you have a valid Proof of Entitlement. SUBJECT TO ANY WARRANTIES WHICH CAN NOT BE EXCLUDED OR EXCEPT AS EXPLICITLY AGREED TO IN THE APPLICABLE LICENSE AGREEMENT OR AN APPLICABLE SUPPORT AGREEMENT, IBM MAKES NO WARRANTIES OR CONDITIONS EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OR CONDITIONS OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND NON INFRINGEMENT, REGARDING THE SERVICE PACK. The applicable license agreement may have been provided to you in printed form and/or may be viewed using the Work with Software Agreements (WRKSFWAGR) CL command. ----------------- Table of Contents ----------------- 1.0 INSTALLATION INSTRUCTIONS 1.1 SUPPORTED ENVIRONMENTS 1.2 PREREQUISITES 1.3 INSTALLING 2.0 RECOMMENDATIONS/RESTRICTIONS 2.1 IBM i SERVER FIXES 3.0 AUTHORIZED PROGRAM ANALYSIS REPORT (APAR) ABSTRACTS - SERVICE PACK LEVEL = 1.1.0.14 (August 2020) - SERVICE PACK LEVEL = 1.1.0.13 (February 2020) - SERVICE PACK LEVEL = 1.1.0.12 (August 2019) 4.0 ENHANCEMENTS AND INTERNAL FIXES - SERVICE PACK LEVEL = 1.1.0.14 (August 2020) - SERVICE PACK LEVEL = 1.1.0.13 (February 2020) - SERVICE PACK LEVEL = 1.1.0.12 (August 2019) ----------------------------------------------------------------------------- 1.0 INSTALLATION INSTRUCTIONS ------------------------------ 1.1 SUPPORTED ENVIRONMENTS -------------------------- This service pack is supported on IBM i 7.2 and later. 1.2 PREREQUISITES ------------------ This service pack is shipped as an RPM and is designed to integrate with the IBM i Open Source yum ecosystem. You must have yum installed in order to install this package. For information on how to get the yum environment installed go to http://ibm.biz/ibmi-rpms. 1.3 INSTALLING --------------- The service pack includes rpm files for installation on PASE. The RPMs will have the names: ibm-iaccess-V.R.M.F-S.ibmi7.2.ppc64.rpm Where V.R.M.F is the Service Pack level, S is the RPM version. The RPMs will be located under the directory of the corresponding architecture. Example installation instructions: yum install ibm-iaccess-1.1.0.12-0.ibmi7.2.ppc64.rpm 2.0 RECOMMENDATIONS/RESTRICTIONS --------------------------------- 2.1 IBM i SERVER FIXES ----------------------- We recommend keeping your IBM i system at the latest Cumulative PTF package, HIPER Group PTF, and latest Database Group PTF. See https://www.ibm.com/support/pages/node/667303 3.0 AUTHORIZED PROGRAM ANALYSIS REPORT (APAR) ABSTRACTS -------------------------------------------------------- This a list of APAR fixes included in this service pack. Each service pack is cumulative. The current service pack includes all the fixes from the prior service pack levels. --------------------------------- Version: 1.1.0.14 Build Date = Aug 2020 --------------------------------- APAR SE73090 OSP-INCORROUT NOTES ON LINUX USING ODBC CRASHES APAR SE73347 OSP-INCORROUT ACS LINUX ODBC USING UNICODE SQL STATEMENTS CAN ENCOUNTER CONVERSION ISSUES RESULTING IN SUBSTITUTION CHARACTER APAR SE73817 OSP-INCORROUT ONLY 200 ROWS OF DATA ARE FETCHED BY ODBC DRIVER FOR LINUX --------------------------------- Version: 1.1.0.13 Build Date = Feb 2020 --------------------------------- APAR SE72337: OSP-INCORROUT LONG COLUMN NAMES TRUNCATED FOR FIRST METADATA RESPONSE APAR SE72376: OSP-OTHER-INCORROUT IBM I ACS LINUX APPLICATION PACKAGE 64-BIT ODBC DRIVER IS NOT CORRECTLY CONVERTING CHAR* TO BIGINT VALUE --------------------------------- Version: 1.1.0.12 Build Date = Aug 2019 --------------------------------- - Initial release for PASE APAR SE71039: CA400EXP-APIS-NLS-INCORROUT CCSID 937 USING 28709 FOR SBCS RATHER THAN 37 APAR SE71097: CA400EXP-ODBC-MSGSQL0181 LINUX ODBC DRIVER CONVERTING STRING TO TIME INCORRECTLY APAR SE71133: CA400EXP-ODBC-THREADS-PERFM IBM I ACCESS CLIENT SOLUTIONS LINUX ODBC DRIVER MEMORY USAGE GROWTH 4.0 ENHANCEMENTS AND INTERNAL FIXES ------------------------------------ This a list of enhancements and internal fixes. --------------------------------- Version: 1.1.0.14 Build Date = Aug 2020 --------------------------------- - Better handling of surrogate pairs in UTF-16 when converting to and from UTF-8 or UTF-32. - Send SQL text in UTF-16 instead of UCS-2 when UnicodeSQL is 1 or 2 - Improve ODBC error reporting when server messages contain embedded NUL bytes. This should result in fewer "Error message text unavailable" messages. - Allow setting SQL_ATTR_TXN_ISOLATION to 0 for COMMIT(*NONE). Some driver managers restrict the values to those defined by ODBC. In that case, a custom driver attribute CWB_ATTR_TXN_ISOLATION (2139) can be used which functions identically to SQL_ATTR_TXN_ISOLATION and bypasses the restriction. - Support for using ODBC escape sequences in connection strings. The primary benefit is for passwords which contain any of the special characters '"', '=', and ';'. Wrap any value in curly braces "{}" to embed special characters. A '}' can be doubled inside an open escape sequence to escape it. - Fix driver identification on POWER. This should now give ppc, ppc64, and ppc64le correctly depending on the platform. Previously it always gave ppc. - Fix possible crash when fetching an output parameter from a stored procedure and tracing is enabled. - Added cwbmedic script to gather diagnostic material for support personnel. --------------------------------- Version: 1.1.0.13 Build Date = Feb 2020 --------------------------------- - Fix a bug in fetch processing that could cause a call to SQLFetch, SQLFetchScroll, or SQLExtendedFetch after a forward-only cursor had reached the end of data in a previous fetch call to return the last rowset of data again instead of returning SQL_NO_DATA. In some cases, this could result in another fetch call being made to the server, resulting in an error. --------------------------------- Version: 1.1.0.12 Build Date = August 2019 --------------------------------- - Initial release for PASE ----------------------------------------------------------------------------- [END OF DOCUMENT]