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 Group view 
• New Insert from Example

Visual Explain

•  Toolbar buttons for easier adjustment when analyzing queries
•  Added actions to the diagram legend for changing settings
•  The actions menu 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

Schemas

•  Added actions to generate SQL Data Manipulation Language (DML) statements for tables and view (INSERT, UPDATE, DELETE)
•  Alias support for *LAST

Data Transfer

•  Added option to automatically adjust columns when downloading to xls or xlsx files.

IFS

• Switch to a different system using System Group view

Printer Output

• Support switching to a different system

5250 Display 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
• Added configured Hardware Management Interfaces to the Actions menu andcan optionally be configured for the toolbar, pop-up keypad, and keyboard mapping.

5250 Print Emulator

• Enhance the Automatic Page Orientation for JPS printer sessions to be similar to the Automatic Page Orientation for GDI printer sessions

 Open Source Package Management

• Added property for adjusting timeout

General

• Added CHECKVERSION plugin
• Optionally enable checking for updates when plugins are not launched from the main GUI
• Optionally set the default URL for various Hardware Management Interfaces
• Support additional configuration options from the command-line for System Groups and Hardware Management Interfaces

IBM FlashSystem Asynchronous Policy-based Replication

PowerHA has a long history of integrating with IBM Spectrum Virtualize-based storage, including IBM FlashSystem, with built-in native support for technologies including Metro Mirror, Global Mirror, LUN-level switching, and FlashCopy.

With this enhancement, PowerHA adds integration with IBM Spectrum Virtualize asynchronous policy-based replication. PowerHA automatically detects if replication is configured with asynchronous policy-based or consistency-group-based replication, enabling the use of the same configuration and management commands with minimal changes to the user experience. In addition, it is possible to combine technologies, including LUN-level switching and PowerHA’s native FlashCopy integration and automation with policy-based replication.

Enhanced Administrative Domain Integration

The administrative domain in PowerHA synchronizes security and configuration-related objects across a PowerHA environment, including user profiles, so that changes to resources monitored by the administrative domain are automatically synchronized with the other nodes.

The administrative domain now has the following enhancements:

• Improved synchronization of resources when changes occur with adopted authority, reducing the need for manual intervention.
• Support for synchronizing SNMPv3 attributes on printer device descriptions, including the SNMP user name (SNMPUSR) and SNMP context name (SNMPCNTX) attributes. Existing monitored resources in the administrative domain that previously monitored all attributes for printer device descriptions will automatically begin monitoring the new attributes after all nodes are updated to a PowerHA version supporting the new attributes.

• The administrative domain makes it easy to add multiple user profiles based on selection criteria. This update simplifies the ability to omit IBM profiles when adding user profiles to the administrative domain. It is now also possible to add multiple user profiles in batch jobs with a new confirm parameter on the ADDCADMRE command to bypass the confirmation screens.

PowerHA Modern Web Interface

The PowerHA modern web interface with HA version 5.6.2 now provides the ability to perform several management operations, including the ability to perform the following types of operations:

• Start and end cluster nodes
• Administrative domain management, including:
  • Start and end administrative domains
  • Add and remove monitored resources
• The ability to manage switchable environments, including the ability to:
  • Start and end cluster resource groups
  • Perform administrative switchovers and failovers
  • Manage replication sessions with the ability to suspend, resume, detach, and reattach replication.

In addition, the web interface has improved customization that enables searching, sorting, filtering, and selecting columns for tables within the interface with the ability to see dynamic SQL code that will generate a similar view.

PowerHA SQL Services
PowerHA continues to provide additional SQL services as the strategic method of retrieving PowerHA information programmatically. In addition to providing the ability to see equivalent SQL queries for information presented via the web interface, HA version 5.6.2 adds the ability to retrieve HyperSwap status information via SQL.

Additional Enhancements

There are several other enhancements to PowerHA. For more information on these enhancements and to get started, see the IBM PowerHA SystemMirror for i documentation page.