IBM Support

SE63116 - OSP-BASEDIR-INCORROUT IBM NAVIGATOR FOR I

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 APAR (Authorized Program Analysis Report)

Abstract

OSP-BASEDIR-INCORROUT IBM NAVIGATOR FOR I

Error Description

OSP-BASEDIR-INCORROUT IBM Navigator for i                      

Problem Summary

The PTF delivers some improvements on IBM Navigator for i.      

Problem Conclusion

DB2 improvements and enhancements as follows:                  
   1.Constraints list Include support has been added to allow  
filtering the list                                              
   2.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  
   3.Index Advisor list new display value ("EVI Only Access"    
which is English-only) for reason code I8                      
   4.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                                
    5.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                      
    6.Fix to Show Indexes (table action) list when paging      
preference is active and the list exceeds the first page        
                                                               
*requires 5761JV1 Option 15 installed on the system.            

Temporary Fix

Comments

Circumvention


PTFs Available

R710 SI67927 PTF Cover Letter   1000

Affected Modules

         
         

Affected Publications

Summary Information

Status............................................ CLOSED PER
HIPER........................................... No
Component.................................. 5770SS1ED
Failing Module.......................... RCHMGR
Reported Release................... R710
Duplicate Of..............................




System i Support

IBM disclaims all warranties, whether express or implied, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose. By furnishing this document, IBM grants no licenses to any related patents or copyrights. Copyright © 1996,1997,1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017, 2018 IBM Corporation. Any trademarks and product or brand names referenced in this document are the property of their respective owners. Consult the Terms of use link for trademark information

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.2.0"},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG15Q","label":"APARs - OS\/400 General"},"Component":"","ARM Category":[],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"V7R1M0;V7R2M0;V7R3M0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
14 July 2018