IBM i Access - ACS Updates for Linux

============================================================================
        IBM i Access Client Solutions - Linux Application Package
                         5733-XJ1 Version: 1.1.0.29
                         ESS ID: LCD8-2012-19

        (c) Copyright IBM Corporation 2026.  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 INSTALLING ON RPM-BASED LINUX DISTRIBUTIONS
1.3 INSTALLING ON DEBIAN-BASED LINUX DISTRIBUTIONS
2.0 RECOMMENDATIONS/RESTRICTIONS
2.1 IBM i SERVER FIXES
2.2 32-BIT SUPPORT
3.0 KNOWN ISSUE (APAR) ABSTRACTS

• SERVICE PACK LEVEL = 1.1.0.29 (March 2026)
• SERVICE PACK LEVEL = 1.1.0.28 (May 2024)
• SERVICE PACK LEVEL = 1.1.0.27 (November 2022)
• SERVICE PACK LEVEL = 1.1.0.26 (May 2022)
• SERVICE PACK LEVEL = 1.1.0.15 (May 2021)
• 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 (May 2019)
• SERVICE PACK LEVEL = 1.1.0.11 (November 2018)
• SERVICE PACK LEVEL = 1.1.0.10 (May 2018)
• SERVICE PACK LEVEL = 1.1.0.9 (October 2017)
• SERVICE PACK LEVEL = 1.1.0.8 (May 2017)
• SERVICE PACK LEVEL = 1.1.0.7 (October 2016)
• SERVICE PACK LEVEL = 1.1.0.6 (May 2016)
• SERVICE PACK LEVEL = 1.1.0.5 (October 2015)
• SERVICE PACK LEVEL = 1.1.0.4 (May 2015)
• SERVICE PACK LEVEL = 1.1.0.3 (October 2014)
• SERVICE PACK LEVEL = 1.1.0.2 (May 2014)
• SERVICE PACK LEVEL = 1.1.0.1 (October 2013)
• SERVICE PACK LEVEL = 1.1.0.0 (June 2013)

4.0 ENHANCEMENTS AND INTERNAL FIXES

• SERVICE PACK LEVEL = 1.1.0.29 (March 2026)
• SERVICE PACK LEVEL = 1.1.0.28 (May 2024)
• SERVICE PACK LEVEL = 1.1.0.27 (November 2022)
• SERVICE PACK LEVEL = 1.1.0.26 (May 2022)
• SERVICE PACK LEVEL = 1.1.0.15 (May 2021)
• 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 (May 2019)
• SERVICE PACK LEVEL = 1.1.0.11 (November 2018)
• SERVICE PACK LEVEL = 1.1.0.10 (May 2018)
• SERVICE PACK LEVEL = 1.1.0.9 (October 2017)
• SERVICE PACK LEVEL = 1.1.0.8 (May 2017)
• SERVICE PACK LEVEL = 1.1.0.7 (October 2016)
• SERVICE PACK LEVEL = 1.1.0.6 (May 2016)
• SERVICE PACK LEVEL = 1.1.0.5 (October 2015)
• SERVICE PACK LEVEL = 1.1.0.4 (May 2015)
• SERVICE PACK LEVEL = 1.1.0.3 (October 2014)
• SERVICE PACK LEVEL = 1.1.0.2 (May 2014)
• SERVICE PACK LEVEL = 1.1.0.1 (October 2013)
• SERVICE PACK LEVEL = 1.1.0.0 (June 2013)

1.0 INSTALLATION INSTRUCTIONS

1.1 SUPPORTED ENVIRONMENTS

This service pack is supported on the following Linux distributions:

• Red Hat Enterprise Linux 10 (x86_64, ppc64le)
• Red Hat Enterprise Linux 9 (x86_64, ppc64le)
• Red Hat Enterprise Linux 8 (x86_64, ppc64le)
• SUSE Linux Enterprise 16 (x86_64, ppc64le)
• SUSE Linux Enterprise 15 (x86_64, ppc64le)
• Ubuntu Linux 24.04 (amd64, ppc64el)
• Ubuntu Linux 22.04 (amd64, ppc64el)

1.2 INSTALLING ON RPM-BASED LINUX DISTRIBUTIONS

The service pack includes rpm files for installation on Linux distributions
which use RPM for package management. The RPMs will have the names:

ibm-iaccess-VRMF-S.0.ARCH.rpm

Where VRMF is the Service Pack level, S is the RPM version, and ARCH is
one of x86_64, ppc64, and ppc64le. The RPMs will be located under the
directory of the corresponding architecture.

Example installation instructions:

• RPM generic:
  rpm -ihv ibm-iaccess-1.1.0.15-1.0.ppc64.rpm
• openSUSE and SUSE Linux Enterprise:
  zypper in ibm-iaccess-1.1.0.15-1.0.ppc64le.rpm
• Fedora, CentOS, RHEL:
  yum install ibm-iaccess-1.1.0.15-1.0.x86_64.rpm

NOTE: In some cases you may have to force install the rpm due to unixODBC
version changes. See section 1.3 for more information.

1.3 INSTALLING ON DEBIAN-BASED LINUX DISTRIBUTIONS

The service pack includes deb files for installation on Debian-based Linux
distributions. The DEBs will have the names:

ibm-iaccess-VRMF-S.0.ARCH.deb

Where VRMF is the Service Pack level, S is the DEB version, and ARCH is
one of amd64 or ppc64le. The DEBs will be located under the directory of the
corresponding architecture.

Example installation instructions:

apt install ./ibm-iaccess-1.1.0.15-1.0.ppc64el.deb

NOTE: The path to the deb file must be qualified and begin with either './'
or '/' or apt will think the file path is a package name and give an
error while trying to retrieve it from the repository.

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

2.2 32-BIT SUPPORT

As of service pack level 1.1.0.28, 32-bit support is no longer provided.

3.0 KNOWN ISSUE (APAR) ABSTRACTS

This a list of Known Issue (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.29
Build Date = March 2026

Version: 1.1.0.28
Build Date = May 2024

Version: 1.1.0.27
Build Date = November 2022

Version: 1.1.0.26
Build Date = May 2022

Version: 1.1.0.15
Build Date = May 2021

Version: 1.1.0.14
Build Date = Aug 2020

Version: 1.1.0.13
Build Date = Feb 2020

Version: 1.1.0.12
Build Date = May 2019

Version: 1.1.0.11
Build Date = November 2018

Version: 1.1.0.10
Build Date = June 2018

Version: 1.1.0.9
Build Date = October 2017

No fixes.

Version: 1.1.0.8
Build Date = May 2017

Version: 1.1.0.7
Build Date = October 2016

Version: 1.1.0.6
Build Date = May 2016

Version: 1.1.0.5
Build Date = November 2015

Version: 1.1.0.4
Build Date = May 2015

Version: 1.1.0.3
Build Date = October 2014

Version: 1.1.0.2
Build Date = May 2014

Version: 1.1.0.1
Build Date = October 2013

No fixes.

Version: 1.1.0.0
Date = June 2013

This package also includes all fixes for the ODBC component from IBM i Access for Windows 7.1 prior to Service Pack level SI49800.

4.0 ENHANCEMENTS AND INTERNAL FIXES

This a list of enhancements and internal fixes.

Version: 1.1.0.29
Build Date = March 2026

• Ensure CCSID conversion parameters used to convert column data in ODBC is
  cleared and not re-used across subsequent SQL statements.

Version: 1.1.0.28
Build Date = May 2024

No enhancements.

Version: 1.1.0.27
Build Date = November 2022

• Add TLS (SSL) support using OpenSSL. This requires that the OpenSSL libraries
  provided by your OS are installed, eg. openssl-libs, libopenssl-1_1,
  libssl1.1, etc. OpenSSL versions 3.0, 1.1.1, and 1.0.2 are supported, with the
  most recent version found taking precedence. Unlike with GSKit on Windows, FIPS
  mode is not supported.
• Add EnableKeepAlive connection string keyword to enable TCP keepalive support
  as an alternative to using cwbcopwr. Setting to 0 disables keepalives, 1
  enables keepalives, and 2 uses the cwbcopwr value (default).
• Add Timeout connection string keyword to set the socket timeout (in seconds)
  when communicating with the server. This is an alternative to using the
  SQL_ATTR_CONNECTION_TIMEOUT connection attribute or cwbcopwr.
• Add LoginTimeout connection string keyword to set the connection timeout (in
  seconds) when initially connecting and logging in to the server. This is an
  alternative to using the SQL_ATTR_LOGIN_TIMEOUT connection attribute.
• Fix handling of QueryStorageLimit=*NOMAX. Previously, this would get
  interpreted as if 0 had been specified.

Version: 1.1.0.26
Build Date = May 2022

• Unify version number with IBM i Access Client Solutions Windows Application
  Package
• Add support for IBM i 7.5 PWDLVL 4
• Add support for IBM i 7.5 BOOLEAN SQL data type
• Add support for SQL_ATTR_CONNECTION_TIMEOUT and proper support for
  SQL_ATTR_LOGIN_TIMEOUT. In addition, cwbcopwr can be used to set send and
  receive socket timeouts.
• Add cwbcopwr utility
• SQL_DESC_OCTET_LENGTH and SQL_DESC_DISPLAY_LENGTH now take in to account any
  expansion that might occur due to CCSID conversion. For instance, a CHAR(10)
  EBCDIC column will now return 20 instead of 10 for the above attributes when
  the client is in UTF-8 since extended ASCII characters take 2 bytes in UTF-8
  but only 1 byte in EBCDIC. This allows retrieving the full column data in
  PHP's odbc and pdo_odbc extensions, especially on IBM i 7.4 and beyond where
  the default PASE CCSID is 1208.
• Fix bug on big endian systems where error message text would be blank in some
  cases
• Fix getaddrinfo error reporting on macOS and PASE systems. These
  were not being mapped correctly, giving odd error messages, eg.
  "rc=8 - CWB0008 - Insufficient personal computer resources" instead of
  "rc=11001 - CWBCO1004 - Remote address could not be resolved"
• Allow SQL_ATTR_ROW_ARRAY_SIZE to change after data has been (pre-)fetched.
• Remove duplicate DBCLOB() CCSID 13488 row returned by SQLGetTypeInfo when
  called with SQL_ALL_TYPES

Version: 1.1.0.15
Build Date = May 2021

• Implement the current_date, current_time, current_timestamp, timestampadd,
  and timestampdiff ODBC scalar function escape sequences. For more details,
  refer to the following ODBC documents:
  https://docs.microsoft.com/en-us/sql/odbc/reference/develop-app/scalar-function-calls
  https://docs.microsoft.com/en-us/sql/odbc/reference/appendixes/time-date-and-interval-functions
• Add TrimCharFields connection option to trim trailing blank characters when
  retrieving CHAR and GRAPHIC fields. Setting this option to 1 will enable
  trimming, while setting it to 0 (default) will disable trimming.
• Add AlwaysCalculateResultLength connection option. Setting this option to 1
  will prevent the driver from returning SQL_NO_TOTAL, while setting it to 0
  (default) will allow the driver to return SQL_NO_TOTAL. Some applications do
  not expect SQL_NO_TOTAL (-4) and treat it as the actual length, causing
  problems. Note that calculating the actual result length can require repeated
  character conversion, so for performance reasons it's advised to not enable
  this feature unless absolutely necessary.

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.
• Utilities in /opt/ibm/iaccess/bin (eg. cwbtrc, cwbmedic, ...) are now
  symlinked to /usr/bin

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 = May 2019

No enhancements.

Version: 1.1.0.11
Build Date = November 2018

No enhancements.

Version: 1.1.0.10
Build Date = May 2018

No enhancements.

Version: 1.1.0.9
Build Date = October 2017

• No longer incorrectly claim support for the ODBC Explicit Data Type Conversion function

Version: 1.1.0.8
Build Date = May 2017

• Fix for result set operations that could cause a statement handle to get in
  to a bad state after calling a stored procedure that returns a result set and
  then calling a stored procedure which does not return a result set. Due to a
  flag not getting unset when it is re-used, the ODBC driver simultaneously
  thinks that it has a result set and does not have a result set. This will
  cause a Function Sequence Error when attempting to close the non-existent
  result set or execute a query.

Version: 1.1.0.7
Build Date = October 2016

No enhancements.

Version: 1.1.0.6
Build Date = May 2016

• Connection string keyword tracing enhancements

Version: 1.1.0.5
Build Date = October 2015

No enhancements.

Version: 1.1.0.4
Build Date = May 2015

• Support for Little Endian POWER systems running Ubuntu 14.04

Version: 1.1.0.3
Build Date = October 2014

• Support for truncating blank padding from character types using
  SQLBindParameter and SQLPutData. When the character parameter does not fit
  in the target field after conversion, the ODBC driver will attempt to
  truncate blanks (both the ASCII space and the ideographic space characters)
  from the end of the buffer until the parameter fits in to the target target
  field after conversion. If the driver truncates blanks, it will return
  SQL_SUCCESS_WITH_INFO and set SQLSTATE 01004. If the buffer does not fit
  even after truncate blanks (if any), it will continue to return SQL_ERROR
  and set SQLSTATE 22001. There is still no support for truncating blank
  padding when using SQLPutData with LOB locators nor support for truncating
  NULL character padding for SQL_C_BINARY parameters.
• Support for Little Endian POWER systems running SUSE Linux Enterprise 12.
• Installation path is now /opt/ibm/iaccess instead of /opt/ibm/iSeriesAccess.
  A symlink has been added for compatibility, but may be removed in a future
  release.
• New header file, /opt/ibm/iaccess/include/cwbodbc.h, contains various
  IBM i Access ODBC driver specific definitions.
• Improved dependency resolution for .deb files.

Version: 1.1.0.2
Build Date = May 2014

• Support for connecting to IBM i 7.2 systems.
• Support for timestamp columns and parameters with precisions other than 6
  when connecting to IBM i 7.2 systems.
• Support for returning IBM-format timestamps instead of ISO-format timestamps
  when using SQLBindCol and SQLGetData. Use the new TimestampFormat odbc.ini
  attribute or the TST connection string keyword (0 = ISO, 1 = IBM).
• ODBC driver is now registered with Threading=0, so multiple threads can use
  the same connection handles and/or statement handles.

Version: 1.1.0.1
Build Date = October 2013

• Support for rpm-based Linux on POWER systems.
• Improved installation and upgrade processing.
• 32-bit co-installable packages for 64-bit systems.
• 64-bit installations now use /opt/ibm/iSeriesAccess/bin instead of
  /opt/ibm/iSeriesAccess/bin64 for binaries. A symlink has been added for
  compatibility, but may be removed in a future release.

Version: 1.1.0.0
Date = June 2013

• Initial release.
• New package name: ibm-iaccess.
• Support for Debian-based systems.
• Full 64-bit support for the ODBC driver. The driver now requires
  unixODBC 2.2.14 or higher.

[END OF DOCUMENT]