IBM Support

IBM Db2 Mirror for i GUI - PTF Update Details

How To


Summary

Information listing the fixes and changes put into each PTF for IBM Db2 Mirror for i GUI.

Objective


SJ00733(7.5) / SJ00732(7.4)
 

The following enhancements to IBM Db2 Mirror GUI for i are included:

  • User Preference File updates

SJ00583(7.5) / SJ00582(7.4)
 

The following enhancements to IBM Db2 Mirror GUI for i are included:

  • Suspend / Resume /Swap Roles and other actions available in the right-click context menu for the pair to be enabled when appropriate 
  • Authorization related error messages are updated 

SJ00218(7.5) / SJ00217(7.4)
 

The following enhancements to IBM Db2 Mirror GUI for i are included:

  • Configuration Setup Wizard to display the following types of RoCE adapters for Power10 servers:
       - Feature Codes: EC71 and EC72; CCIN 2CF9
       - Feature Codes: EN24 and EN26; CCIN EC2A

SJ00172(7.5) / SJ00171(7.4)
 

The following enhancements to IBM Db2 Mirror GUI for i are included:

  • Object Tracking List table is enhanced with 4 additional columns:
  • Parallel Capable
  • Object Network Number
  • Referential Integrity Related
  • Planned Resync Order

SI86165(7.5) / SI86164(7.4)
 

The following fixes to IBM Db2 Mirror GUI for i are included:

  • Angular 17 upgrade

 SI85734 (7.5) / SI85736 (7.4)
 

The following fixes to IBM Db2 Mirror GUI for i are included:

  • Regression in Compare component, hiding the objects for the selected library
  • Inability to select RCL Pending Groups
  • Improvements in Cluster Node Configuration Component
  • Object Tracking Summary - inability to see SQL 

 SI85618 (7.5) / SI85617 (7.4)
 

The following fixes to IBM Db2 Mirror GUI for i are included:

  • Ability to configure Database IASP with Device Description name not matching Resource Name
  • Application Evaluation was improved to include QSQDSRC files mirror eligibility
  • Object Tracking List for *QSYSBAS to ignore entries from DB IASP when IASP is included into the user profile namespace
  • Inability to connect to Db2 Mirror pairs with sign on that does not match the GUI signon

 
SI85394 (7.5) / SI85393 (7.4)
 

The following fixes to IBM Db2 Mirror GUI for i are included:

  • Security fix has been implemented to reduce the exposure of sensitive data in the browser memory. See details in Security Bulletin

 SI84118 (7.5) / SI84117 (7.4)
 

Enhancements for IBM Db2 Mirror GUI for i include:

  • New: SQL Formatting enabled for all SQL statements visible on the GUI with color coding and keywords capitalized
  • New: Health Monitors controls are updated with several new controls: usage of mirrored data queues and resynchronization 
  • Multithreading improvements are implemented to optimize runtime for the following GUI components:
    • Replication Evaluation
    • Replication Eligibility
    • Sequence Objects
    • Validate Members Data

SI83520 (7.5) / SI83519 (7.4)
 

Enhancements for IBM Db2 Mirror GUI for i include:

  • New: Db2 Mirror Health Center Controls (located under Health Center component) allowing to manage health center properties such as Available Storage Threshold, Suspend Wait Time and others
  • SQL optimization to enhance performance across multiple GUI components:
    • Journal Evaluation
    • Work Discovery
    • GUI Active Jobs
    • Work File Discovery
    • Replication Eligibility
    • Object Tracking List

SI83520 (7.5) / SI83519 (7.4)
 

The following fixes to IBM Db2 Mirror GUI for i are included:

  • Application Evaluation - Replication Eligibility component improvements
  • Application Evaluation - Replication Evaluation - SQL improvements to proper match objects across the nodes
  • Health Center to include new Db2 Mirror jobs
  • Fix for pagination problem with lazy loaded tables 
  • GUI Active Jobs fix

SI83204 (7.5) / SI83057 (7.4)
 

The following fixes to IBM Db2 Mirror GUI for i are included:

  • Update to Angular 15
  • Compare component to expose job logs link in error messages
  • Creation of Setup Tools logger during GUI initialization 

 SI83029 (7.5) / SI83028 (7.4)
 

The following fixes to IBM Db2 Mirror GUI for i are included:

  • Security fix has been implemented to prevent the storage of sensitive data in memory and its potential exposure. See details in Security Bulletin

 SI82608 (7.5) / SI82607 (7.4)
 

The following enhancements to IBM Db2 Mirror GUI for i are included:

  • Added the ability to copy SQL code with one click in the View SQL panel.
  • Improved the performance of the Audit component, enabling it to run queries on large amounts of data.
  • Provided performance improvement for the Abnormal Resume component.

 SI81804 (7.5) / SI81803 (7.4)
 

The following enhancements to IBM Db2 Mirror GUI for i are included:

  • IFS IASP support enhancements
  • Flight Recorder Filters - timestamps are cleared when filters are applied more than once 
  • Access History - added SQL button for viewing query 

SI81390 (7.5) / SI81389 (7.4)
 

The following enhancements to IBM Db2 Mirror GUI for i are included:

  • New Db2 Mirror brand icon
  • Conditional Resume support:
    • If a resume request is unable to proceed because of jobs with pending suspend processing, you see the Jobs Preventing Resume link displayed on the home page of the Db2 Mirror GUI
    • Jobs Prevention Resume view added under Health Center to view and manage jobs preventing resume
    • More details can be found in Db2 Mirror documentation for 7.4 and 7.5
  • Submitted Job Tracker:
    • View and add job queues to track across the mirrored nodes
    • View and resubmit jobs in tracked queues from either node 
    • More details can be found in Db2 Mirror documentation for 7.4 and 7.5
  • IFS IASP Geographic Mirroring management:
    • View and operate CRG and Geographic Mirroring of IFS IASP
  • Setup wizard enhancement:
    • Quiesce improvements for manual clone to allow the user to cancel and then redo the Set mirror state for warm cloning step and set the mirror state for any Database IASPs.
    • Automated remote clone improvements to prompt the user before attempting to suspend *SYSBAS or any Database IASPs to allow any active transactions to quiesce immediately or do it at a specific time. If the quiesce fails, the user is allowed to retry or cancel the quiesce, which causes the clone to fail.

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SSLLPF","label":"IBM Db2 Mirror for i"},"ARM Category":[{"code":"a8m0z0000001hExAAI","label":"DB2 Mirror"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.4.0;7.5.0;and future releases"}]

Document Information

Modified date:
09 July 2024

UID

ibm16840139