Ibm I Access Acs Updates
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...
The full story
This article is one source in a clustered incident — the cluster page carries the summary, timeline and every other outlet covering it.
