IBM Support

2015 December

News


Abstract

2015 December

Content

7.2 SP4,  7.1 SP13

Enhancements and fix details for IBM Navigator for i PTFs. 

For the PTF information please see the PTFs page. 

<-- October 2015 SP details  Next SP details -->

Enhancements

Database: 

Constraints list Include support has been added to allow filtering the list
Show Related action for tables - The resulting list will now include foreign key constraints from others tables when they depend on primary/unique key constraints belonging to the selected table
Index Advisor list new display value ("EVI Only Access" which is English-only) for reason code I8
Fix to Show Indexes (table action) list when paging preference is active and the list exceeds the first page
Database tasks that will now attempt to launch to Access Client Solutions (ACS).  Required version is v1r1m5:

  • Analyze action on SQL performance monitors, SQL plan cache snapshots, and SQL plan cache event monitors will launch the new Analyze function if ACS is listening, otherwise the existing dialog will be displayed
  • Run SQL Scripts (RSS) context menu item on a database (New).  If ACS is listening, RSS is launched, otherwise a dialog is shown with instructions on obtaining and setting up ACS to handle the task
  • Generate SQL action on database objects will launch RSS if ACS is listening, otherwise will show the existing simple text dialog
  • Show SQL buttons on database object definition dialogs, and the database object Comments dialog will launch RSS if ACS is listening, otherwise will show the existing simple text dialog
  • Show Command button on database properties dialog  will launch RSS if ACS is listening, otherwise will show the existing simple text dialog
  • Show SQL from an advised index in the Index Advisor list will launch RSS if ACS is listening, otherwise will show the existing simple text dialog
  • Work with Statement actions in Show Statements and Analyze tools will launch RSS if ACS is listening, otherwise will show the existing simple text dialog

New DB tasks in All Tasks displayed under Health and Performance (No MRI for descriptions) were added to allow task launching from ACS

  • SQL Details for Job
  • SQL Plan Cache Statements
  • SQL Plan Cache Properties
  • New SQL Plan Cache Snapshot
  • New SQL Plan Cache Event Monitor
  • Import SQL Performance Monitor
  • Import SQL Plan Cache Snapshot
  • Import SQL Plan Cache Event Monitor

The Navigator<->ACS (Access Client Solutions) integration - such as Run SQL Scripts is now available 

http://www.ibm.com/support/pages/node/633843

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Document Information

Modified date:
24 January 2020

UID

ibm11164430