IBM i Access - ACS Updates

                              Latest Updates

-----------------------------------------------------------------------------

Version = 1.1.9.1
Build date = November 2022
ESS Level = LCD8-2010-30
Here are some no-cost versions of Java:
    https://developer.ibm.com/languages/java/semeru-runtimes/downloads/
    https://aws.amazon.com/corretto/
    https://adoptium.net/
For information on cost-effective, enterprise-grade support from IBM for your Java deployments:
    https://www.ibm.com/cloud/support-for-runtimes    
For additional information see:
    https://www.ibm.com/support/pages/java-options-ibm-i-access-client-solutions

---------------------------------

Enhancements:
1. Run SQL Scripts (RSS):
   - New preferences added to Edit->Preferences:
     General tab: Auto-save options (Idea IBMI-I-1576)
     Results tab: 'Prompt to close results prior to disconnecting' (Idea IBMI-I-3276)
   - Recover changed scripts after an abnormal termination  (Idea IBMI-I-1690)
   - 'Copy with headings' supported from results (Idea IBMI-I-1032)
   - PC file chooser opens in detail view by default (Idea IBMI-I-2213)
   - Improved positioning of search result (Idea IBMI-I-2501)
   - Allow additional columns to be viewed in results Details... (Idea IBMI-I-3286)
   - Refresh existing Joblog window instead of creating a new one (Idea IBMI-I-2586) 
   - Results windows assume focus for keyboard input only if RSS is the active window (Idea IBMI-I-2871)
2. Schemas:
   - Support for renaming table partitions
   - Allow delete of *JRNRCV with options:
     IGNORE_REMOTE_JOURNALS("*IGNTGTRCV")
   IGNORE_INQUIRY_MESSAGE("*IGNINQMSG")
   IGNORE_EXIT_PROGRAM("*IGNEXITPGM") (Idea IBMI-I-2901)
   - Support for 'RESTRICT ON DROP' in Table Definition dialog
   - Added new column stats information to statistics panel
3. SQL Performance Center:
   - Show Statements:
     Support for MTI names object filtering.
     Added QRO hash, Top N most temp storage, Top N most CPU usage,
           Top N most database reads filters for live plan cache, snapshots, and database monitors.
4. Visual Explain:
   - Show object names by default (Idea IBMI-I-3305)
5. Integrated File System:
   - View options for 'Use short date format' and 'Use IBM i system time zone' (Idea IBMI-I-2612)
6. Open Source Package Management:
   - Support OpenSSH formatted keys
7. General:
   - Ability for an admin to install or propagate an updated JRE to their Windows users when "Help->Check for Updates" has been configured to apply updates from an IBM i (Idea IBMI-I-2563)
   - Host name included in Signon prompt (Idea IBMI-I-2304)

General information about this update:

1. The heap size used by IBM i Access Client Solutions (ACS) will no longer default to 1 gigabyte.
   The heap size will be determined by the Java Virtual Machine (JVM) and the PC available memory.
   In most cases, this will set the heap size to 25% of the PC's installed memory.
   The heap size can be overridden by using the -Xmx option on the command-line, with a desktop shortcut,
   or by setting the JAVA_TOOL_OPTIONS environment variable.
   The following examples will set the heap size to 2 gigabytes:
   
        Example 1 (command-line or desktop shortcut):
        Start_Programs\Windows_x86-64\acslaunch_win-64.exe -Xmx2g
        
        Example 2 (setting the JAVA_TOOL_OPTIONS environment variable):
        JAVA_TOOL_OPTIONS=-Xmx2g
        
2. When using "Open Source Package Management", 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.
   
3. Mac users that install their updates from a configured IBM i location using "Help->Check for Updates" will need to:
   Install the update, restart ACS, run "Help->Check for Updates" a second time, install the update, restart ACS
   The second update is necessary to pick up the new Mac icon for the running application in the dock.
   
   
This update includes several fixes including:
SE77812 OSP ACS DATA TRANSFER SAVE DTTX MIGHT NOT SHOW THE NAME OF THE FILE
SE78009 OSP ACS 1.1.9.0 AND EHLLAPI BRIDGE 9.22.096 CRASHING WHEN USING ] OR [ CHARACTER
SE78103 OSP-UNPRED NO SIGNON PROMPT ON EACH TIME YOU START NAVIGATOR REQUESTS WHEN "PROMPT FOR USER NAME AND PASSWORD EVERY TIME"
SE78106 OSP-INCORROUT UNABLE TO SAVE CUSTOM JKS KEYSTORE FROM ACS KEY MANAGEMENT
SE78199 OSP-UNPRED COLUMN DELIMITER IS INCORRECT WHEN DBCS DATA IS ENTERED TO A FIELD WITH DSPATR (CS)
SE78282 OSP-MSGCPF3344 ISSUED FOR SPOOLED FILES IN FINISHED STATUS WHEN VIEWING THROUGH ACS PRINTER OUTPUT
SE78423 OSP-OSP ACS CHANGE TABLE, REMOVE FIELD NOT WORKING
SE78518 OSP-F/QWSGET-T/QWSGET-MSGMCH0601 THE MESSAGE IN THE CURSOR PROTECTION AREA ON LINE 27 CAN BE DELETED WITH THE DEL KEY
SE78567 OSP ACS 1.1.9. BUILD ID 2151 - SQL SHOW NO OUTPUT WHEN SYNTAX IS INCORRECT DEFINED
SE78601 OSP-UNPRED MESSAGE TEXT NOT SHOWN AT LINE 24 IF FUNCTIONS KEY BUTTONS ARE AT LINE 24

-----------------------------------------------------------------------------

1. Enhancements to Run SQL Scripts:
    - Commit and Rollback buttons added to the toolbar (RFE 137047)
   - Warn user when closing a connection with uncommitted actions (RFE 148568)
      Note: Requires IBM i release 7.3 or higher
   - Job log search support
   - Synchronize recently used files when there are multiple RSS windows
   - Upload Results panel now has separate fields for Schema and Table, and a Replace table option 
   - Additional Examples
2. Enhancements to Schemas:
   - Previous and Next buttons added on Journal Viewer... View Data Details window (RFE 146834)
   - Added Deterministic and Inline columns to Functions list
3. Enhancements to SQL Performance Center:
   - Main window search support
   - Analyze reports search support
   - Added convenience buttons for View options on main window
   - Full statement pop-up when hovering over Show Statements plan cache list of statements (RFE Epic 130919)
   - Added secure database (QZDASSINIT) host server to SQL Details for Jobs
4. Enhancements to Data Transfer
   - Support for selecting a specific Excel spreadsheet.  When connecting to an Active Excel Spreadsheet as the Output device (or Input device), the Name drop-down box allows switching between spreadsheets.
5. Other General Enhancements:
   - Added Processor Feature Code to Virtual Control Panel (RFE 150132)
   - System selection from configured systems by typing name (RFE 138461)

1. Apply IBM i 7.3 PTF SI76982 or IBM i 7.4 PTF SI76981
2. Set the following property in the AcsConfig.properties file:
   com.ibm.iaccess.NewNavigator=true
   OR set the property on the command line. For example:
   Start_Programs\Windows_x86-64\acslaunch_win-64.exe -Dcom.ibm.iaccess.NewNavigator=true

---

1. Enhancements to Run SQL Scripts:
   - All SQL warnings encountered during results retrieval are now posted to the Messages tab
   - A Refresh list... option has been added to Database drop-down on the Connection->Connect to Database... dialog
   - Descriptions for JDBC configurations are displayed as hover text on the Connection->Connect to Database... dialog and Connection->Apply JDBC Configuration menu
   - Data-mapping errors in results are now displayed as "++++++++++++" to match STRSQL behavior
   - Additional Insert from Examples
2. Enhancements to Schemas:
   - A new option on Generate SQL allows constraints to be defined in the CREATE TABLE statement instead of a separate ALTER TABLE statement
3. Enhancements to Visual Explain:
   - Advised Indexes now combine multiple CREATE INDEX statements into a single Run SQL Scripts window (RFE 146855)
4. Enhancements to Printer Output:
   - Actions for Delete, Hold, and Release can be monitored in Active Tasks Pane (RFE 149102)
5. Enhancements to 5250 Display:
   - Allow target address in lower right corner to be copied so it can be pasted (RFE 148520) 
6. Other General Enhancements:
   - Warn user when logging in if caps lock is on (RFE 143192)

1.  If you install this update from an IBM i server using the feature described in GettingStarted section "5.2 Setting up an IBM i Update Location", be aware of the following:
   a. You should first upgrade to 1.1.8.5 before upgrading to the current version.  Or, you may go directly to the current version if you use the install_acs script in the Mac_Application directory.
   If you already applied the update from an IBM i server, ACS will not start. To correct, run the install_acs script in the Mac_Application directory.
   b. The user will be prompted for an Administrator password.  This is necessary so we can move some files to a new location.
2. If you install this update using the install_acs script in the Mac_Application directory:
   a. No additional instructions are needed.
   b. The user will be prompted for an Administrator password.  This is necessary so we can move some files to a new location.

1. Enhancements to the Content Assist feature of Run SQL Scripts include:
   - Syntax Proposals for the following statements: 
   INSERT, UPDATE, DELETE, MERGE, CREATE INDEX, TRUNCATE
   - Support for CASE and  OLAP expressions
   - Enhanced support for built-in functions
   - Provide derived table and UDTF as syntax proposals
   - The expression at the cursor is wrapped by the provided BIF, CASE, or OLAP expression after content assist
   - Support for ALIAS files and QTEMP library
   - Other miscellaneous enhancements
2. Enhancements to Run SQL Scripts:
   - Reconfigured menus including consolidating preferences on a common dialog at Edit->Preferences...
   - Variety of improvements to SQL formatting and syntax proposals
   - Support for INCLUDE SQL (RFE 126674)
   - Added "Find Previous" and "Go to Line..." on Search menu
   - Release cursor lock on full table read or inactivity (RFE 129534, 145008)
   - Change null results from '-' to something else (RFE 141332)
   - Performance improvements including "Replace All" 
   - Additional Insert from Examples for new IBM i Services
3. Enhancements to Database Schemas:
   - System name support for Sequences (requires 7.4 PTF SI74324 or 7.3 PTF SI74326)
   - View Definition column heading and text can be changed
   - View->Data action includes data from hidden columns
4. Enhancements to Integrated File System:
   - Multiple file upload (RFE 108689)
   - Upload an entire folder (RFE 114991)
   - Support for unzip to extract the contents of a .jar or .zip file (RFE 134332)
   - Added "View..." with an option to convert a text file to UTF-8 so it can be viewed on the workstation
   - Support for viewing and downloading /QSYS.LIB .MBR files (RFE 144689)
5. Enhancements to 5250 Display:
   - Updates to CCSIDs 1377 and 1388.  See PTFs required below.
6. Other General Enhancements:
   - "System for checking updates" added to Edit->Preferences General tab (RFE 143072)
   - Executable files have been signed with an IBM owned certificate (RFE 136954)
   - New product icon

1. You must be at version 1.1.8.5.  If you are at a version before 1.1.8.5, you may skip over 1.1.8.5 if you use the install_acs script in the Mac_Application directory.
   If you already applied the update using this feature and were not at version 1.1.8.5, ACS will not start.  Run the install_acs script in the Mac_Application directory to fix it.
2. The user will be prompted for an Administrator password.  This is necessary so we can move some files to a new location.

1. No additional instructions are needed.
2. The user will be prompted for an Administrator password.  This is necessary so we can move some files to a new location.