IBM Support

SI58218 - OSP-BASEDIR-INCORROUT IBM Navigator for i

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-BASEDIR-INCORROUT IBM Navigator for i


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED           PTF/FIX  LEVEL

TYPE PROGRAM  RELEASE   NUMBER   MIN/MAX  OPTION
---- -------- --------- -------  -------  ------
PRE  5770SS1  V7R2M0    SI58219   NONE     0003
PRE  5770SS1  V7R2M0    SI56748   NONE     0003
PRE  5770SS1  V7R2M0    SI56828   NONE     0003
PRE  5770SS1  V7R2M0    SI56831   NONE     0003
PRE  5770SS1  V7R2M0    SI57344   NONE     0003
CO   5770SS1  V7R2M0    SI51768   NONE     0003



NOTICE:
-------
Application of this PTF may disable or render ineffective programs that
use system memory addresses not generated by the IBM translator,
including programs that circumvent control technology designed to limit
interactive capacity to purchased levels.  This PTF may be a prerequisite
for future PTFs.  By applying this PTF you authorize and agree to the
foregoing.

This PTF is subject to the terms of the license agreement which
accompanied, or was contained in, the Program for which you are obtaining
the PTF.  You are not authorized to install or use the PTF except as part
of a Program for which you have a valid Proof of Entitlement.

SUBJECT TO ANY WARRANTIES WHICH CAN NOT BE EXCLUDED OR EXCEPT AS EXPLICITLY
AGREED TO IN THE APPLICABLE LICENSE AGREEMENT OR AN APPLICABLE SUPPORT
AGREEMENT, IBM MAKES NO WARRANTIES OR CONDITIONS EITHER EXPRESS OR IMPLIED,
INCLUDING BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OR CONDITIONS OF
MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND NON INFRINGEMENT,
REGARDING THE PTF.

The applicable license agreement may have been provided to you in printed
form and/or may be viewed using the Work with Software Agreements (WRKSFWAGR)
CL command.


APAR Error Description / Circumvention

-------------------------------------------------
The PTF delivers some improvements on IBM Navigator for i.

CORRECTION FOR APAR 'SE63111' :
-------------------------------
1.PDI updates
1)Batch Model usability improvements
- Move Delta seconds and Delta Seconds/Elapsed time to left
in table for easier viewing
- Add Workload ID to tables - on Change Batch Model and
Change Calibration workload tabs
- Filter out processors that don't run on IBM i (retrieved
from system.xml file)
2)Fix to System Monitor metrics not charting results
- Monitor metrics were truncating decimal values. They will
now show the decimal values on the chart and table views.
3)Disk perspective text enhancements
- Disk Reads and Writes labels improved

2.DB2 improvements
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 5770JV1 Option 15 installed on the system.

CIRCUMVENTION FOR APAR 'SE63111' :
----------------------------------
None.


Activation Instructions


None.




Special Instructions

With this PTF, IBM Navigator for i running on admin2 moves to JDK 64
bit. Before applying this PTF, verify licensed program 5770JV1 option
15 (Java SE 7 64 bit) is installed.

1. Enter the following command to stop the QHTTPSVR subsystem before
applying PTF:
ENDSBS SBS(QHTTPSVR) OPTION(*IMMED)

2. Apply or remove this PTF (immediate mode).

3. Start the HTTP server(s) using:
STRTCPSVR SERVER(*HTTP) HTTPSVR(*ADMIN)

4. It is highly recommended to clear the browser cache after applying
this PTF.


Default Instructions

THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   SI56747      OSP-BASEDIR-INCORROUT IBM Navigator for i
   SI56747      OSP-MSGLANGUAGEISSUE INAVIGATOR FOR I GUI SCREENS JAPANESE I
   SI56747      OSP-BASEDIR-UNPRED INAV - APPLICATION ADMINISTRATION SHOWS N
   SI56747      OSP DHCP MONITOR UNDER ISDN DOESN'T SHOW ANY SUBNET
   SI53771      OSP-BASEDIR-INCORROUT IBM Navigator for i
   SI53771      OSP-BASEDIR-INCORROUT IBM Navigator for i
   SI53521      OSP-BASEDIR-INCORROUT IBM Navigator for i
   SI52843      OSP-BASEDIR-INCORROUT IBM Navigator for i
   SI51789      OSP-BASEDIR-INCORROUT IBM Navigator for i
   SI51508      OSP-BASEDIR-INCORROUT IBM Navigator for i

Summary Information

System..............................i
Models..............................
Release.............................V7R2M0
Licensed Program...............5770SS1
APAR Fixed..........................View details for APAR SE63111
Superseded by:......................View fix details for PTF SI75349
Recompile...........................N
Library.............................QSYSDIR
MRI Feature ........................NONE
Cum Level...........................NONE


IBM 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, 2019, 2020, 2021 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.

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.2","Product":{"code":"SG15V","label":"PTF Cover Letters - IBM i General"},"Component":"5770SS1","Edition":""},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.2","Product":{"code":"SG16F","label":"PTF Cover Letters - IBM i 7.2"},"Component":"5770SS1","Edition":""}]

Document Information

Modified date:
15 March 2021