Skip to content

Ibm I Access Acs Updates

www.ibm.com • November 2, 2026

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.

Fixes will only be provided for the current version.

Version: 1.1.9.17 October 2026 ESS ID: LCD8-2010-46

Versions 1.1.9.1 through 1.1.9.16 are vulnerable to memory exhaustion via a malicious SFTP server sending unsolicited replies. The SFTP client (Apache MINA SSHD) did not verify that incoming replies corresponded to previously sent requests yet continued to store them.

Known issues (APARs) fixed:

DT502103 CA400EXP-SERVICE-F/QSQPROC-T/QSQPROC-MSGSQL7906 RESTRICT ON DROP

Version: 1.1.9.16 September 2026 ESS ID: LCD8-2010-45

All prior versions are vulnerable to arbitrary code execution via: STRPCCMD CL command sent from a compromised IBM i. 5250 emulator macro that contains a malicious 'RunProgram' action. 5250 multiple sessions file (.bch, .bchx) that contains a malicious 'Run' action.

STRPCCMD CL command sent from a compromised IBM i.

5250 emulator macro that contains a malicious 'RunProgram' action.

5250 multiple sessions file (.bch, .bchx) that contains a malicious 'Run' action.

Beginning with this version, each of the above actions requires explicit user confirmation before it is allowed to run. A confirmation prompt will be displayed asking whether to run the action, with 'Yes' and 'No' options. For the emulator macro 'RunProgram' action, an additional 'Cancel' option is available to stop execution of the entire macro.

Known issues (APARs) fixed:

DT500870 OSP-UNPRED ACS - "CHECK FOR UPDATES" FOR PLAIN USER FAILS WITH CPFA09C

Version: 1.1.9.15 August 2026 ESS ID: LCD8-2010-44

Known issues (APARs) fixed:

DT498800 OSP-UNPRED MSGSSL007 - AN ERROR OCCURRED WITH AN SSL CERTIFICATE (JAVA.NIO.FILE.ATTRIBUTE.USERPRINCIPALNOTFOUNDEXCEPTION)

Version: 1.1.9.14 August 2026 ESS ID: LCD8-2010-43

All prior versions are vulnerable to: Arbitrary code execution on Windows when installed for all users due to publicly writeable directory and configuration file. Injection of rogue certificate authority due to publicly writeable truststore. Zip slip path traversal exploit when importing a configuration.

Arbitrary code execution on Windows when installed for all users due to publicly writeable directory and configuration file.

Injection of rogue certificate authority due to publicly writeable truststore.

Zip slip path traversal exploit when importing a configuration.

Versions 1.1.8.3 through 1.1.9.13 are vulnerable to downloading unverified product code when configured to update from an IBM i.

The sample scripts in Documentation\Sample_Scripts\Linux_Mac_Other are vulnerable to arbitrary code execution via maliciously crafted input parameters.

Known issues (APARs) fixed:

DT472544 CA400EXP KEY IS IGNORED IN INDEX ADVISOR IF DESC KEYWORD IS USED

DT473152 OSP-UNPRED ACS 1.1.9.12 AND 1.1.9.13 ACSLAUNCH_WIN-64.EXE WON'T START IF NATIVE FILES AREN'T ALONGSIDE

Version: 1.1.9.13 May 2026 ESS ID: LCD8-2010-42

Versions 1.1.5.0 through 1.1.9.12 are vulnerable to remote code execution when configured to listen for requests from IBM i Navigator.

Version: 1.1.9.12 April 2026 ESS ID: LCD8-2010-41

Run SQL Scripts: Support for SELF utility Save to Source Physical File without inserting x25 line endings Enforce record length rather than wrapping lines when saving to Source Physical File Source Physical file chooser dialog usability improvements Insert from Examples: Db2 for i Services SELF - System-wide controls SELF - Job-level controls SELF - Log Queries SELF - Removing historical rows SELF - Initial Stack SELF - Top occurrences SELF - QA use case example IBM i Services Security - Who is creating objects in the IFS root Security - Who is creating objects in the /QOpenSys subdirectory Security - IFS first-level directories that are open to attack Security - IFS subdirectory object attack vector check Security - IFS directory ownership SYSTOOLS Generate spreadsheet and send email example

Support for SELF utility

Save to Source Physical File without inserting x25 line endings

Enforce record length rather than wrapping lines when saving to Source Physical File

Source Physical file chooser dialog usability improvements

Insert from Examples: Db2 for i Services SELF - System-wide controls SELF - Job-level controls SELF - Log Queries SELF - Removing historical rows SELF - Initial Stack SELF - Top occurrences SELF - QA use case example IBM i Services Security - Who is creating objects in the IFS root Security - Who is creating objects in the /QOpenSys subdirectory Security - IFS first-level directories that are open to attack Security - IFS subdirectory object attack vector check Security - IFS directory ownership SYSTOOLS Generate spreadsheet and send email example

Db2 for i Services SELF - System-wide controls SELF - Job-level controls SELF - Log Queries SELF - Removing historical rows SELF - Initial Stack SELF - Top occurrences SELF - QA use case example

SELF - System-wide controls

SELF - Job-level controls

SELF - Removing historical rows

SELF - Top occurrences

SELF - QA use case example

IBM i Services Security - Who is creating objects in the IFS root Security - Who is creating objects in the /QOpenSys subdirectory Security - IFS first-level directories that are open to attack Security - IFS subdirectory object attack vector check Security - IFS directory ownership

Security - Who is creating objects in the IFS root

Security - Who is creating objects in the /QOpenSys subdirectory

Security - IFS first-level directories that are open to attack

Security - IFS subdirectory object attack vector check

Security - IFS directory ownership

SYSTOOLS Generate spreadsheet and send email example

Generate spreadsheet and send email example

Known issues (APARs) fixed:

DT463280 OSP-MSGSQL0206 ACS - DISPLAY CHECK PENDING CONSTRAINTS RETURNS SQL0206 SQLSTATE 42703 COLUMN OR GLOBAL VARIABLE QSYS2 NOT FOUND

DT465165 OSP-UNPRED SQL STATE 07001, VENDOR CODE -99999 ERROR - RUN SQL SCRIPTS PROCEDURE CALLS FAIL USING COMMA DECIMAL SEPARATOR

DT469076 OSP-INCORROUT ACS 5250 MACRO RETURNS MACROACTIONINPUT.PLACETEXT(): INTERNAL MACRO ERROR.

Version: 1.1.9.11 January 2026 ESS ID: LCD8-2010-40

Versions 1.1.9.8 through 1.1.9.10 are vulnerable to an attacker carrying out an XML External Entity injection via a crafted XFA file inside of a PDF. Apache Tika is used by the Run SQL Scripts feature to determine the content type of binary column data in a table on the IBM i.

Known issues (APARs) fixed:

DT455863 OSP-UNPRED ACS - CURSOR VALUE INCORRECT USING DDS KEYWORD RTNCSRLOC

DT457428 OSP-INCORROUT ACS DOES NOT DETECT AVAILABILITY OF VERSION 1.1.9.10

Version: 1.1.9.10 November 2025 ESS ID: LCD8-2010-39

Data Transfer: Support for bold headings when adding new sheets to an existing spreadsheet

Support for bold headings when adding new sheets to an existing spreadsheet

5250 Emulator: Access to the System Debugger is now available from the Actions . It can also be added to the Toolbar, Keyboard..., or Popup Keypad via Edit→Preferences.

Access to the System Debugger is now available from the Actions . It can also be added to the Toolbar, Keyboard..., or Popup Keypad via Edit→Preferences.

Integrated File System: Added a Favorites for keeping track of favorite directories. The list can be updated using the new star icon to the parent icon. Added the Move action for files and directories within the same system Support for updating Properties on all files in a directory and subdirectories

Added a Favorites for keeping track of favorite directories. The list can be updated using the new star icon to the parent icon.

Added the Move action for files and directories within the same system

Support for updating Properties on all files in a directory and subdirectories

Schemas: Make the RGZPFM command available in the Table Reorganize window

Make the RGZPFM command available in the Table Reorganize window

Run SQL Scripts: Added several preferences for customizing what job log messages will be displayed. See the General tab at Edit→Preferences... When connecting, extract error messages from the job log for the ADDLIBLE command and display them in the Messages tab ahead of the Connected... message Added property com.ibm.iaccess.RSSWrapResultsTabs to revert results tabs from a single scrollable row back to a wrapped stack of rows (pre-1.1.9.0) Insert from Examples: IBM i Services Security - How many libraries are OPEN for attack? Security - How many libraries are OPEN for attack? (ownership perspective) Security - Which commands can anyone use? Security - Which libraries contain commands that anyone use? Security - What Database triggers exist? Security - What are the IFS directories, where the owner doesn't match the dir? Security - IFS directories with a name and owner mismatch not using *PUBLIC *EXCLUDE Security - IFS directory contents object ownership mismatch (detail report) Security - IFS directory contents object ownership mismatch (summary report) Security - Data areas where any user can see the value (detail report) Security - Data areas where any user can see the value (summary report) Security - Data areas where anyone can change data area value (detail report)

Added several preferences for customizing what job log messages will be displayed. See the General tab at Edit→Preferences...

When connecting, extract error messages from the job log for the ADDLIBLE command and display them in the Messages tab ahead of the Connected... message

Added property com.ibm.iaccess.RSSWrapResultsTabs to revert results tabs from a single scrollable row back to a wrapped stack of rows (pre-1.1.9.0)

Insert from Examples: IBM i Services Security - How many libraries are OPEN for attack? Security - How many libraries are OPEN for attack? (ownership perspective) Security - Which commands can anyone use? Security - Which libraries contain commands that anyone use? Security - What Database triggers exist? Security - What are the IFS directories, where the owner doesn't match the dir? Security - IFS directories with a name and owner mismatch not using *PUBLIC *EXCLUDE Security - IFS directory contents object ownership mismatch (detail report) Security - IFS directory contents object ownership mismatch (summary report) Security - Data areas where any user can see the value (detail report) Security - Data areas where any user can see the value (summary report) Security - Data areas where anyone can change data area value (detail report)

IBM i Services Security - How many libraries are OPEN for attack? Security - How many libraries are OPEN for attack? (ownership perspective) Security - Which commands can anyone use? Security - Which libraries contain commands that anyone use? Security - What Database triggers exist? Security - What are the IFS directories, where the owner doesn't match the dir? Security - IFS directories with a name and owner mismatch not using *PUBLIC *EXCLUDE Security - IFS directory contents object ownership mismatch (detail report) Security - IFS directory contents object ownership mismatch (summary report) Security - Data areas where any user can see the value (detail report) Security - Data areas where any user can see the value (summary report) Security - Data areas where anyone can change data area value (detail report)

Security - How many libraries are OPEN for attack?

Security - How many libraries are OPEN for attack? (ownership perspective)

Security - Which commands can anyone use?

Security - Which libraries contain commands that anyone use?

Security - What Database triggers exist?

Security - What are the IFS directories, where the owner doesn't match the dir?

Security - IFS directories with a name and owner mismatch not using *PUBLIC *EXCLUDE

Security - IFS directory contents object ownership mismatch (detail report)

Security - IFS directory contents object ownership mismatch (summary report)

Security - Data areas where any user can see the value (detail report)

Security - Data areas where any user can see the value (summary report)

Security - Data areas where anyone can change data area value (detail report)

SQL Performance Center: Added columns to Index Advisor that display the related MTI info LUG Requirement SM1846

Added columns to Index Advisor that display the related MTI info LUG Requirement SM1846

Visual Explain: Enhanced the numeric values in attributes to be formatted based on user locale Enhanced the "Indexes Considered" dialog to show SQL schema and name when available

Enhanced the numeric values in attributes to be formatted based on user locale

Enhanced the "Indexes Considered" dialog to show SQL schema and name when available

Usability: Printer Output and IFS now support the delete key to initiate the Delete action and the Enter key to initiate the View action When viewing Plan Cache Statements, reduce the scope of when the tooltip of the SQL statement is displayed so the other data columns can be easily read

Printer Output and IFS now support the delete key to initiate the Delete action and the Enter key to initiate the View action

When viewing Plan Cache Statements, reduce the scope of when the tooltip of the SQL statement is displayed so the other data columns can be easily read

Known issues (APARs) fixed:

DT447641 OSP-UNPRED INCORRECT HANDLING OF 1399 CODEPAGE IN EHLLAPI COPY PS (5) FUNCTION

DT449480 F/ACS-NEWPRINTSESSIONS DIALOGUE USED FOR NEW PRINTER SESSIONS IN ACS NOT ALLOWED AT JAVA 21.

Version: 1.1.9.9 July 2025 ESS ID: LCD8-2010-38

General: Added /plugin=script so multiple ACS command-line plugins can be called from a single invocation of ACS. See GettingStarted section 9.1.43 for usage and restrictions. Cleaning up temporary files created by ACS has been enhanced to provide 2 options: Added property com.ibm.iaccess.DaysTemporaryFilesAllowed Added the /cleartempfiles parameter to /plugin=maint See AcsConfig.properties for additional details Added property com.ibm.iaccess.DesktopLocation so that the default Desktop location used by ACS can be overridden. See AcsConfig.properties . Added property com.ibm.iaccess.AcsConfig to override location and name of AcsConfig.properties . See GettingStarted section 4.1 for details. Show the configured system name for the command-line plugins that check or apply updates Added support for passphrase protected SSH keys used by Open Source Package Management and /plugin=httpproxyui

Added /plugin=script so multiple ACS command-line plugins can be called from a single invocation of ACS. See GettingStarted section 9.1.43 for usage and restrictions.

Cleaning up temporary files created by ACS has been enhanced to provide 2 options: Added property com.ibm.iaccess.DaysTemporaryFilesAllowed Added the /cleartempfiles parameter to /plugin=maint See AcsConfig.properties for additional details

Cleaning up temporary files created by ACS has been enhanced to provide 2 options:

Added property com.ibm.iaccess.DaysTemporaryFilesAllowed

Added the /cleartempfiles parameter to /plugin=maint

See AcsConfig.properties for additional details

Added property com.ibm.iaccess.DesktopLocation so that the default Desktop location used by ACS can be overridden. See AcsConfig.properties .

Added property com.ibm.iaccess.AcsConfig to override location and name of AcsConfig.properties . See GettingStarted section 4.1 for details.

Show the configured system name for the command-line plugins that check or apply updates

Added support for passphrase protected SSH keys used by Open Source Package Management and /plugin=httpproxyui

Data Transfer: Added the /sqlfile parameter to /plugin=cldownload . This parameter will support a UTF-8 encoded file that contains a single SQL query.

Added the /sqlfile parameter to /plugin=cldownload . This parameter will support a UTF-8 encoded file that contains a single SQL query.

Integrated File System: Added property com.ibm.iaccess.ifs.VerifyAvailableSpace to enable the checking of available space before doing an IFS send, upload or copy/paste. See AcsConfig.properties for details. Added Description as an optional column to display the Text attribute of the file

Added property com.ibm.iaccess.ifs.VerifyAvailableSpace to enable the checking of available space before doing an IFS send, upload or copy/paste. See AcsConfig.properties for details.

Added Description as an optional column to display the Text attribute of the file

Schemas: Added the "Work With→Journal Receivers" action to provide a complete list of related receivers The Table Definition dialog has been changed to leverage the SUPPRESS_INQUIRY_MESSAGES QAQQINI option when dropping columns (instead of requiring authority to the CHGRPLYE command) Support for "Generate SQL..." to save directory paths Additional columns have been added to the Journal and Journal Receiver lists

Added the "Work With→Journal Receivers" action to provide a complete list of related receivers

The Table Definition dialog has been changed to leverage the SUPPRESS_INQUIRY_MESSAGES QAQQINI option when dropping columns (instead of requiring authority to the CHGRPLYE command)

Support for "Generate SQL..." to save directory paths

Additional columns have been added to the Journal and Journal Receiver lists

Run SQL Scripts: Support for 7.6 SQL syntax in the formatter Insert from Examples: IBM i Services Security - Audit Journal CD review Security - Auditing configuration for commands Security - Commands that Limited Capabilities can use Security - Db2 for i - Delete attack vector Security - Db2 for i - Insert attack vector Security - Db2 for i - Query attack vector Security - Db2 for i - RENAME attack Security - Db2 for i - Trigger attack vector Security - Db2 for i - Update attack vector Security - IFS directories (detail) Security - IFS directories (summary) Security - Library List security review Security - Powerful commands Security - Special Authority and Db2 data Security - User profile attack vector Security - Users with Limited Capabilities

Support for 7.6 SQL syntax in the formatter

Insert from Examples: IBM i Services Security - Audit Journal CD review Security - Auditing configuration for commands Security - Commands that Limited Capabilities can use Security - Db2 for i - Delete attack vector Security - Db2 for i - Insert attack vector Security - Db2 for i - Query attack vector Security - Db2 for i - RENAME attack Security - Db2 for i - Trigger attack vector Security - Db2 for i - Update attack vector Security - IFS directories (detail) Security - IFS directories (summary) Security - Library List security review Security - Powerful commands Security - Special Authority and Db2 data Security - User profile attack vector Security - Users with Limited Capabilities

Insert from Examples:

IBM i Services Security - Audit Journal CD review Security - Auditing configuration for commands Security - Commands that Limited Capabilities can use Security - Db2 for i - Delete attack vector Security - Db2 for i - Insert attack vector Security - Db2 for i - Query attack vector Security - Db2 for i - RENAME attack Security - Db2 for i - Trigger attack vector Security - Db2 for i - Update attack vector Security - IFS directories (detail) Security - IFS directories (summary) Security - Library List security review Security - Powerful commands Security - Special Authority and Db2 data Security - User profile attack vector Security - Users with Limited Capabilities

Security - Audit Journal CD review

Security - Auditing configuration for commands

Security - Commands that Limited Capabilities can use

Security - Db2 for i - Delete attack vector

Security - Db2 for i - Insert attack vector

Security - Db2 for i - Query attack vector

Security - Db2 for i - RENAME attack

Security - Db2 for i - Trigger attack vector

Security - Db2 for i - Update attack vector

Security - IFS directories (detail)

Security - IFS directories (summary)

Security - Library List security review

Security - Powerful commands

Security - Special Authority and Db2 data

Security - User profile attack vector

Security - Users with Limited Capabilities

SQL Performance Center: Added Index Evaluator which prompts for a Schema and Table and then launches Work with Indexes

Added Index Evaluator which prompts for a Schema and Table and then launches Work with Indexes

Usability: The selected system on the ACS main panel should be in view when entering System Configurations Corrected the list of entries in the IFS most recently used directories dropdown Added capability to copy the contents of a terminal session started by Open Source Package Management. Ctrl+A (Windows) and Command-A (Mac) will do a select-all and copy to the system clipboard.

The selected system on the ACS main panel should be in view when entering System Configurations

Corrected the list of entries in the IFS most recently used directories dropdown

Added capability to copy the contents of a terminal session started by Open Source Package Management. Ctrl+A (Windows) and Command-A (Mac) will do a select-all and copy to the system clipboard.

Known issues (APARs) fixed:

DT436323 OSP-WAIT SLOW RESPONSE WHEN RUNNING QUERIES. 5250 SESSION INACCESSIBLE WHILE QUERIES ARE BEING EXECUTED

DT438830 OSP-UNPRED FUNCTIONS ARE NOT WORKING WHEN ACS IS STARTED WITH SYSTEM GROUP VIEW

DT440129 OSP-UNPRED INTERNAL MACRO ERROR WHEN PRESSING THE ESC KEY ON THE PROMPT SHOWN BY THE MACRO DUE TO THE ELEMENT

DT444495 OSP-DB-OTHER-INCORROUT ACS RSS SQL REMOVES WHITE SPACE AND DOES NOT ISSUE SQL0104

DT446221 MAINTAINED TEMPORARY INDEXES' NOT SUPPORTED AT THE CURRENT SERVER RELEASE LEVEL.

Version: 1.1.9.8 April 2025 ESS ID: LCD8-2010-37

As previously announced in 1.1.9.3, ACS will no longer support checking for FIPS compliance. The option has been removed from the General tab on the main GUI Preferences panel.

General: Support for providing an Additional Factor when MultiFactor Authentication (MFA) is enabled on an IBM i 7.6 partition. See section 9.14 in GettingStarted for additional information. Keep ACS host server connections from being disconnected due to inactivity. See the property com.ibm.iaccess.ConnectionStayAlive in AcsConfig.properties for additional information. Launch ACS showing System Groups when that was the last active view

Support for providing an Additional Factor when MultiFactor Authentication (MFA) is enabled on an IBM i 7.6 partition. See section 9.14 in GettingStarted for additional information.

Keep ACS host server connections from being disconnected due to inactivity. See the property com.ibm.iaccess.ConnectionStayAlive in AcsConfig.properties for additional information.

Launch ACS showing System Groups when that was the last active view

Data Transfer: Added the "Update existing file" option to the Details panel for Data Transfer downloads to an existing .xls or .xlsx workbook. This option will update an existing sheet or add additional sheets without changing the existing data or formatting in the workbook. LUG Requirement SM1659 Added parameters to /plugin=cldownload for specifying the sheet, row, and column. An update parameter was also added so the existing data and formatting would not be changed. Support for the BOOLEAN SQL data type

Added the "Update existing file" option to the Details panel for Data Transfer downloads to an existing .xls or .xlsx workbook. This option will update an existing sheet or add additional sheets without changing the existing data or formatting in the workbook. LUG Requirement SM1659

Added parameters to /plugin=cldownload for specifying the sheet, row, and column. An update parameter was also added so the existing data and formatting would not be changed.

Support for the BOOLEAN SQL data type

Integrated File System: A new Duplicate action for files and folders

A new Duplicate action for files and folders

Run SQL Scripts: Support for viewing contents of binary result columns ( BLOB, BINARY, VARBINARY ). Support for viewing formatted JSON data LUG Requirement AD1774 New Preference added on the General tab for bypassing the "Save As" New Preference added on Results tab to format numeric values based on locale. This is also available on the Results context as "Format Numeric Values". LUG Requirement SM1813 Improved behavior for the Toggle action Additional Insert from Examples

Support for viewing contents of binary result columns ( BLOB, BINARY, VARBINARY ).

Support for viewing formatted JSON data LUG Requirement AD1774

New Preference added on the General tab for bypassing the "Save As"

New Preference added on Results tab to format numeric values based on locale. This is also available on the Results context as "Format Numeric Values". LUG Requirement SM1813

Improved behavior for the Toggle action

Additional Insert from Examples

SQL Performance Center: Additional filtering on Index Advisor LUG Requirement SM1846 Additional filtering on Active Query Info Individual column values can be copied from Plan Cache Statements by using the "Copy Column" option on the context Added the "Condense Advised Indexes" option to the Index Advisor button

Additional filtering on Index Advisor LUG Requirement SM1846

Additional filtering on Active Query Info

Individual column values can be copied from Plan Cache Statements by using the "Copy Column" option on the context

Added the "Condense Advised Indexes" option to the Index Advisor button

Visual Explain: Added an action to view indexes considered during optimization (available on each table and the entire plan). The indexes considered will have a reason code and description of why it was or was not used. LUG Requirement SM1845

Added an action to view indexes considered during optimization (available on each table and the entire plan). The indexes considered will have a reason code and description of why it was or was not used. LUG Requirement SM1845

Key Management: A new option "Open Java default" under "Key Database File" makes it easier to view the Certificate Authorities (CAs) in the installed Java truststore, and to optionally push them to a Windows environment making them available to the optional ACS Windows Application Package

A new option "Open Java default" under "Key Database File" makes it easier to view the Certificate Authorities (CAs) in the installed Java truststore, and to optionally push them to a Windows environment making them available to the optional ACS Windows Application Package

Known issues (APARs) fixed:

DT418608 OSP-DB-OTHER-F/QCANPARS-T/QSQRUN4-MSGCPD0017 ACS DISPLAY JOURNAL RECEIVERS FAIL WHEN THE SCHEMA NAME STARTS WITH 'Ñ'

Version: 1.1.9.7 November 2024 ESS ID: LCD8-2010-36

5250 Emulator: EHLLAPI 64-bit support has been added - See

EHLLAPI 64-bit support has been added - See

Database: Set the client special register for application name throughout ACS DB functions. For example: IBM i Access Client Solutions - Run SQL Scripts IBM i Access Client Solutions - Run SQL Scripts - Content Assist IBM i Access Client Solutions - Visual Explain Provide ability to display SQL used to populate various lists

Set the client special register for application name throughout ACS DB functions. For example: IBM i Access Client Solutions - Run SQL Scripts IBM i Access Client Solutions - Run SQL Scripts - Content Assist IBM i Access Client Solutions - Visual Explain

IBM i Access Client Solutions - Run SQL Scripts

IBM i Access Client Solutions - Run SQL Scripts - Content Assist

IBM i Access Client Solutions - Visual Explain

Provide ability to display SQL used to populate various lists

Schemas: Support for displaying Maintained Temporary Index (MTI) detail via a new Table action. Requires these IBM i PTFs (or later): 7.4 SF99704 Level 20 7.3 SF99703 Level 28 Ability to perform actions in the context of a list that is displayed in a separate window

Support for displaying Maintained Temporary Index (MTI) detail via a new Table action. Requires these IBM i PTFs (or later): 7.4 SF99704 Level 20 7.3 SF99703 Level 28

Ability to perform actions in the context of a list that is displayed in a separate window

SQL Performance Center: Established a launch pad for specific database performance features Added launch for easier access to Index Advisor Added launch for access to Maintained Temporary Index (MTI) detail Added launch for access to Active Query Information

Established a launch pad for specific database performance features

Added launch for easier access to Index Advisor

Added launch for access to Maintained Temporary Index (MTI) detail

Added launch for access to Active Query Information

Known issues (APARs) fixed:

DT395262 OSP ACS DB SCHEMA " STATISTIC DATA DETAILS " TEXT IS NOT READABLE WHEN ACS IS SET TO GERMAN

DT395897 OSP-UNPRED ACS - RUNSQLSCRIPT - SQL FORMATTER AND SYNAX CHECK ISSUE

DT395925 OSP-OSP-UNPRED ACS WARNING

DT396274 OSP THE DEFAULT PATH AND NAME USED WHEN USING ACS RUN SQL SCRIPT AND SAVING TO AN IFS FILE IS INCORRECT.

DT396414 OSP PRINTER SESSION DOES NOT AUTOMATICALLY CONNECT AT ACS V1.1.9.6

DT397540 OSP-UNPRED IBM I ACS 5250 SESSION MAY ATTEMPT FTP CONNECTION TO NETWORK RESOURCE HOSTING EMULATOR FOLDER

DT398408 OSP-UNPRED RSS - CL PROMPT FOR COMMAND ADDLICKEY FAILS WITH CPD0082

DT400313 OSP-UNPRED ACS EMULATION - FIELD SET TO BLINK WITH DBCS CHARACTER THE OTHER FIELDS BEFORE THAT FIELD ALSO BLINKS

DT400977 OSP-MSGDB0036 SQL0913 DATA TRANSFER WITH LOCK ON FIRST MEMBER

DT406832 OSP WHEN USING ACS RSS 1.1.9.6 ON LINUX USING THE SAVE RESULTS OPTION, GETS NO POP-UP.

Version: 1.1.9.6 August 2024 ESS ID: LCD8-2010-35

General: Update /plugin=cfg for supporting console configurations Added /gui option to /plugin=pwchange Added Description and Group name as sortable columns to the Password change panel

Update /plugin=cfg for supporting console configurations

Added /gui option to /plugin=pwchange

Added Description and Group name as sortable columns to the Password change panel

Data Transfer: When using "Create IBM i Database File", double-click on scan results to open Details

When using "Create IBM i Database File", double-click on scan results to open Details

5250 Emulator: Added the following Screen History enhancements: Time stamp of when screen was added to the archive. It will be visible when using the Archive Viewer. Optionally use time stamp in file name when using "Save screens as images..." Command-line plugin scrconv for converting a saved archive

Added the following Screen History enhancements: Time stamp of when screen was added to the archive. It will be visible when using the Archive Viewer. Optionally use time stamp in file name when using "Save screens as images..." Command-line plugin scrconv for converting a saved archive

Time stamp of when screen was added to the archive. It will be visible when using the Archive Viewer.

Optionally use time stamp in file name when using "Save screens as images..."

Command-line plugin scrconv for converting a saved archive

Integrated File System: Drag-and-drop of files on PC to open IFS panel Double-click to view a file

Drag-and-drop of files on PC to open IFS panel

Double-click to view a file

Schemas: Support for PROGRAM_NAME on New Function and New Procedure dialogs

Support for PROGRAM_NAME on New Function and New Procedure dialogs

Run SQL Scripts: Complete management of custom user examples including delete and replace Drag-and-drop of .sql files from IFS panel Support for Projects to allow for saving/restoring open tabs Added several Insert from Examples File chooser dialog usability improvements (for Windows only)

Complete management of custom user examples including delete and replace

Drag-and-drop of .sql files from IFS panel

Support for Projects to allow for saving/restoring open tabs

Added several Insert from Examples

File chooser dialog usability improvements (for Windows only)

Known issues (APARs) fixed:

DT380854 WHEN CHANGING THE HOST CODE PAGE IN ACS TO 1130 - VIETNAMESE, IT SHOWS ADDITIONAL CHARACTER ON SCREEN

DT380879 OSP-UNPRED ACS "VIEW JOURNAL ENTRIES" FAILS WHEN THE SCHEMA AND/OR TABLE NAME IS BETWEEN QUOTES (")

DT381910 ACS SQL PERFORMANCE CENTER APPEARS TO HANG TRYING TO VIEW DETAILS FOR A JOB

DT382066 ACS 5250 EMULATION COPY PASTE ISSUE WITH A SESSION USING CP 424

DT389695 OSP-UNPRED ACS - CUSTOMIZE BAR - ACTIONS, WINDOWS AND HELP ARE MISSING FROM " LEVEL 1"

DT390063 OSP-UNPRED ACS - 5250 SIZE AND SCRATCHPAD ARE DISPROPORTIONAL WHEN SESSION IS MAXIMIZED

DT390446 OSP-OSP ACS OPENING DATA TRANSFER AT MULTIPLE DISPLAY ENV BECOMES A VERY WIDE WINDOW

DT390468 OSP-OTHER-INCORROUT ACS HANDLING OF CACHED SST PROFILE CAUSING CONSOLE RECONNECTING ISSUES

DT391696 CA400EXP-CA400EXP-APIS-OTHER-SRCPWSI-INCORROUT ACS RUN SQL SCRIPTS IFS STREAM FILE NOT OPENING WITH INTENDED SHORTCUT

DT393181 OSP INCORROUT-ACS JAPANESE CHARACTERS PRINT INCORRECTLY THROUGH PRINTER SESSION CONFIGURED TO USE JPS

Version: 1.1.9.5 April 2024 ESS ID: LCD8-2010-34

General: Added /plugin=checkversion command line option. See GettingStarted section 9.1.41 Optionally enable checking for updates when plugins are not launched from the main GUI. See com.ibm.iaccess.CheckUpdateForPlugins in AcsConfig.properties . Optionally set the default URL for various Hardware Management Interfaces. See the com.ibm.iaccess.hmiUrl.* properties in AcsConfig.properties . Support additional configuration options from the command-line for System Groups and Hardware Management Interfaces. See the CFG plugin in GettingStarted section 9.1.4.

Added /plugin=checkversion command line option. See GettingStarted section 9.1.41

Optionally enable checking for updates when plugins are not launched from the main GUI. See com.ibm.iaccess.CheckUpdateForPlugins in AcsConfig.properties .

Optionally set the default URL for various Hardware Management Interfaces. See the com.ibm.iaccess.hmiUrl.* properties in AcsConfig.properties .

Support additional configuration options from the command-line for System Groups and Hardware Management Interfaces. See the CFG plugin in GettingStarted section 9.1.4.

Data Transfer: Added option to automatically adjust columns when downloading to .xls or .xlsx files From the Data Transfer GUI: select Format Options, Other, Adjust column width From the command-line, /plugin=cldownload specify /adjustcolumns

Added option to automatically adjust columns when downloading to .xls or .xlsx files From the Data Transfer GUI: select Format Options, Other, Adjust column width From the command-line, /plugin=cldownload specify /adjustcolumns

From the Data Transfer GUI: select Format Options, Other, Adjust column width

From the command-line, /plugin=cldownload specify /adjustcolumns

5250 Emulator: Support for displaying the Host Code Page as part of the title: Edit→Preferences→Appearance→Window Setup..., or as part of the watermark by using &CODEPAGE in the text field at Edit→Preferences→Watermark... Specify the initial macro from 5250 command-line plugin. See the /macro and /mparms options in GettingStarted section 9.1.13. Added configured Hardware Management Interfaces to the Actions . They can optionally be configured for the toolbar, pop-up keypad, and keyboard mapping. Enhanced the Automatic Page Orientation for JPS printer sessions to be similar to the Automatic Page Orientation for PC5250 GDI-based printer sessions in Access for Windows

Support for displaying the Host Code Page as part of the title: Edit→Preferences→Appearance→Window Setup..., or as part of the watermark by using &CODEPAGE in the text field at Edit→Preferences→Watermark...

Specify the initial macro from 5250 command-line plugin. See the /macro and /mparms options in GettingStarted section 9.1.13.

Added configured Hardware Management Interfaces to the Actions . They can optionally be configured for the toolbar, pop-up keypad, and keyboard mapping.

Enhanced the Automatic Page Orientation for JPS printer sessions to be similar to the Automatic Page Orientation for PC5250 GDI-based printer sessions in Access for Windows

Integrated File System: Switch to a different system using System Groups

Switch to a different system using System Groups

Printer Output: Support switching to a different system

Support switching to a different system

Schemas: Added actions to generate SQL Data Manipulation Language (DML) statements for tables and views ( INSERT, UPDATE, DELETE ) Alias support for *LAST (requires the following PTFs): 7.5 SF99950 Level 7 7.4 SF99704 Level 28

Added actions to generate SQL Data Manipulation Language (DML) statements for tables and views ( INSERT, UPDATE, DELETE )

Alias support for *LAST (requires the following PTFs): 7.5 SF99950 Level 7 7.4 SF99704 Level 28

Run SQL Scripts: Performance improvements to Content Assist Enabled the copying of text from Job Log Viewer When selecting files from PC, the List or Details view is saved Connect to a different database using System Groups Added several Insert from Examples

Performance improvements to Content Assist

Enabled the copying of text from Job Log Viewer

When selecting files from PC, the List or Details view is saved

Connect to a different database using System Groups

Added several Insert from Examples

Visual Explain: Added toolbar buttons for easier adjustments when analyzing queries Added actions to the diagram legend for changing settings The actions has been rearranged to differentiate between actions for entire graph and those of selected icon New option (icon) to show object system name New option (arrow) to show both estimated and actual rows Graph links with hover text that show all attributes User adjusted icon spacing is now saved

Added toolbar buttons for easier adjustments when analyzing queries

Added actions to the diagram legend for changing settings

The actions has been rearranged to differentiate between actions for entire graph and those of selected icon

New option (icon) to show object system name

New option (arrow) to show both estimated and actual rows

Graph links with hover text that show all attributes

User adjusted icon spacing is now saved

Open Source Package Management: Added property for adjusting timeout. See com.ibm.iaccess.ospm.RunCommandTimeout in AcsConfig.properties .

Added property for adjusting timeout. See com.ibm.iaccess.ospm.RunCommandTimeout in AcsConfig.properties .

Known issues (APARs) fixed:

SE81001 OSP-UNPRED INSTALL BOOTSTRAP USING ACS FAILS WITH MESSAGE ERROR: BSH: /QOPENSYS/PKGS/BIN/YUM: NOT FOUND

SE81017 OSP ACS 1.1.9.4 5250 MSGSSL002 THE IBM I SERVER APPLICATION IS NOT TRUSTED FOR SECURE SOCKETS CONNECTIONS

SE81226 QIWA2-OTHER-DATABASE-MSGCPD0046 SQL0443 CPF0006 CPF0001

SE81240 OSP-UNPRED OPSM - FAILED TO LIST INSTALLED PACKAGES

SE81341 OSP-UNPRED SELECT BORDER NOT WORKING IN WINDOW BY DOUBLE-CLICK LEFT MOUSE KEY

SE81350 EHLLAPI STARTSESSION INTERMITTENTLY FAILS AFTER /PLUGIN=PCS IS CALLED

Version: 1.1.9.4 November 2023 ESS ID: LCD8-2010-33

IBM strongly recommends upgrading to 1.1.9.4 to receive critical security fixes. Continued use of prior versions is not recommended. Use of 1.1.9.4 and a prior version on the same workstation might cause unexpected prompts for credentials. Special instructions: In addition to updating acsbundle.jar on all platforms, any deployment on Windows that uses acslaunch_win-XX.exe (where XX=32 or 64 ) to start ACS, also needs to update acslaunch_win-XX.exe , acsnative.dll and acspcoc.exe . Note: These files are updated automatically when you use any of the following methods to update ACS: An installation script in the Windows_Application folder A configured IBM i location with the command-line /plugin=installupdates A configured IBM i location with "Install Update" from the ACS main GUI (available from Help→ , "Check for Updates" when an IBM i location is configured for updates) All other deployments on Windows that use these .exe and .dll files need to make sure the most recent versions of these files are being used. Failure to use the updated files in combination with acsbundle.jar might result in a failed connection to the IBM i host.

IBM strongly recommends upgrading to 1.1.9.4 to receive critical security fixes. Continued use of prior versions is not recommended.

Use of 1.1.9.4 and a prior version on the same workstation might cause unexpected prompts for credentials.

Special instructions:

In addition to updating acsbundle.jar on all platforms, any deployment on Windows that uses acslaunch_win-XX.exe (where XX=32 or 64 ) to start ACS, also needs to update acslaunch_win-XX.exe , acsnative.dll and acspcoc.exe .

Note: These files are updated automatically when you use any of the following methods to update ACS:

An installation script in the Windows_Application folder

A configured IBM i location with the command-line /plugin=installupdates

A configured IBM i location with "Install Update" from the ACS main GUI (available from Help→ , "Check for Updates" when an IBM i location is configured for updates)

All other deployments on Windows that use these .exe and .dll files need to make sure the most recent versions of these files are being used. Failure to use the updated files in combination with acsbundle.jar might result in a failed connection to the IBM i host.

General: Check for Updates should provide a better error message when an internet connection is not available Support for a larger font size throughout ACS. To enable, set the property com.ibm.iaccess.FontSize . The maximum size allowed is 25. This support is being made available for convenience and AS-IS. IBM is under no obligation to fix rendering issues that occur when setting this property. Some known limitations are: Text in some combo boxes and tabs might not display the entire text depending on the OS and font size Text within the 5250 display area is unchanged (use 5250 specific settings) Text within the Run SQL Script editor pane is unchanged (use View→Font...) Icons and other graphics remain unchanged

Check for Updates should provide a better error message when an internet connection is not available

Support for a larger font size throughout ACS. To enable, set the property com.ibm.iaccess.FontSize . The maximum size allowed is 25. This support is being made available for convenience and AS-IS. IBM is under no obligation to fix rendering issues that occur when setting this property. Some known limitations are: Text in some combo boxes and tabs might not display the entire text depending on the OS and font size Text within the 5250 display area is unchanged (use 5250 specific settings) Text within the Run SQL Script editor pane is unchanged (use View→Font...) Icons and other graphics remain unchanged

Support for a larger font size throughout ACS. To enable, set the property com.ibm.iaccess.FontSize . The maximum size allowed is 25. This support is being made available for convenience and AS-IS. IBM is under no obligation to fix rendering issues that occur when setting this property. Some known limitations are:

Text in some combo boxes and tabs might not display the entire text depending on the OS and font size

Text within the 5250 display area is unchanged (use 5250 specific settings)

Text within the Run SQL Script editor pane is unchanged (use View→Font...)

Icons and other graphics remain unchanged

5250 Emulator: Add date and timestamp to Status History Log Automatic copy function should not keep trim rectangle

Add date and timestamp to Status History Log

Automatic copy function should not keep trim rectangle

Integrated File System: Option from GUI to allow Sending and Pasting files to other systems through user's workstation when QFileSvr.400 prevents a direct transfer Upload option to Store to UTF-8 text file

Option from GUI to allow Sending and Pasting files to other systems through user's workstation when QFileSvr.400 prevents a direct transfer

Upload option to Store to UTF-8 text file

Schemas: Added Details action to SQL Packages

Added Details action to SQL Packages

Run SQL Scripts: Syntax support for ENCRYPT_AES256 scalar function Insert from Examples extended for additions to SYSTOOLS Recent files can be viewed with the key sequence Alt+F R

Syntax support for ENCRYPT_AES256 scalar function

Insert from Examples extended for additions to SYSTOOLS

Recent files can be viewed with the key sequence Alt+F R

SQL Performance Center: Improve usability of SQL Performance Monitor wizard when selecting a specific job

Improve usability of SQL Performance Monitor wizard when selecting a specific job

HMC Probe Utility: When connecting to a 5250 console, allow default SSL setting to be changed

When connecting to a 5250 console, allow default SSL setting to be changed

Known issues (APARs) fixed:

SE80286 OSP-THREADS-UNPRED ACS INTEGRATED FILE SYSTEM HANGS ON QTEMP SYMBOLIC LINK

SE80395 OSP-UNPRED MSGGEN005 CHANGING PASSWORD FOR MULTIPLE SYSTEMS

SE80407 OSP ACCESS CLIENT SOLUTIONS-INCORROUT- SPOOLED FILE PRINTS INCORRECTLY AT V1.1.9.2 USING JAVA PRINT SERVICE

SE80466 OSP RUN SQL SCRIPTS GETTING SQL0312 WHEN USING THE OPERATION BETWEEN IN A WHERE CLAUSE AND TRYING TO PROMPT FOR VARIABLES

SE80613 OSP-UNPRED ACS PRINTER OUTPUT USER SECTION BLANK

Version: 1.1.9.3 July 2023 ESS ID: LCD8-2010-32

FIPS compliance checking will not be supported in a future update. As the requirements for FIPS compliance change and the Java Runtime Environment (JRE) evolves, it no longer makes sense for ACS to attempt to verify whether or not the JRE supports FIPS compliance. The check box "Client SSL must be FIPS-compliant" currently available at Edit→Preferences will be removed in a future update. Beginning with this update, if this option is checked, a warning is displayed when visiting the Preferences panel informing the user that this option will be removed in a future update.

General: System debugger added to the Tools

System debugger added to the Tools

Integrated File System: Added a preference for specifying an "Upload From Location" Added a preference for specifying the maximum threads allowed for doing concurrent uploads and downloads Support a property that sets the top level directory allowed (to enable this restriction, see AcsConfig.properties ) Usability improvement when attempting to view files larger than 1MB that do not have an installed viewer

Added a preference for specifying an "Upload From Location"

Added a preference for specifying the maximum threads allowed for doing concurrent uploads and downloads

Support a property that sets the top level directory allowed (to enable this restriction, see AcsConfig.properties )

Usability improvement when attempting to view files larger than 1MB that do not have an installed viewer

Schemas: New actions to generate SQL Data Manipulation Language (DML) SQL statements for tables and views

New actions to generate SQL Data Manipulation Language (DML) SQL statements for tables and views

Run SQL Scripts: across tabs Updated SQL syntax for formatting and colorization Performance improvements to Content Assist Additions to Insert from Examples

across tabs

Updated SQL syntax for formatting and colorization

Performance improvements to Content Assist

Additions to Insert from Examples

Open Source Package Management: Support for password protected SSH keys

Support for password protected SSH keys

Known issues (APARs) fixed:

SE79815 OSP OSPM DISPLAY HANGS AND DOESN'T COMPLETE

SE79819 OSP-OTHER-INCORROUT MSGGEN005 IS RECEIVED WHEN TRYING TO CHANGE AN EXPIRED PASSWORD WITH ACS 1.1.9.2 WITH PASSWORD LEVEL 0 OR 1

SE79821 OSP-OTHER-UNPRED 1.1.9.2. SST PROFILE PASSWORD WITH 9+ CHARACTERS FAILING

SE79836 OSP-MSGMSGGEN049-PAR-940XMISC MSGGEN049 GETS WHILE STARTING 5250 EMULATOR WITH ACS 1.1.9.2

SE79857 OSP-OTHER-MSGSQL0104 IN ACS WITH NO WHITESPACE AFTER A LABEL COLON

SE80020 OSP-INCORROUT JAPANESE AUTO-IME CHARACTER INPUT IS ACTIVATED ON NON-INPUT SCREEN AREA WHEN CURSOR PASSES THROUGH DBCS CHARACTER

Version: 1.1.9.2 April 2023 ESS ID: LCD8-2010-31

When using "Help→Check for Updates" to monitor IBM's web location for the available update, this feature does not work for versions before 1.1.9.2 because all FTP requests to this web location have been disabled.

When using "HMC Probe Utility" and "Virtual Control Panel", a change was made to use the standard SSH known_hosts file. That means you can expect to be prompted to accept the fingerprint of the IBM i server the first time you connect after installing this update.

General: Eliminate extra terminal window that appears after applying Windows 11 update Note: To eliminate the extra terminal window when using ACS Desktop shortcuts or file associations, you must run the installation script for your installation located in the Windows_Application folder for this update or later

Eliminate extra terminal window that appears after applying Windows 11 update Note: To eliminate the extra terminal window when using ACS Desktop shortcuts or file associations, you must run the installation script for your installation located in the Windows_Application folder for this update or later

5250 Emulator: Support certificates with multiple Subject Alternative Name (SAN)

Support certificates with multiple Subject Alternative Name (SAN)

Schemas...