IBM Support

SI58230 - 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  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770SS1  710  SI58229   NONE     0003
PRE  5770SS1  710  SI56827   NONE     0003
PRE  5770SS1  710  SI56830   NONE     0003
PRE  5770SS1  710  SI57343   NONE     0003
CO   5770SS1  710  SI51264   NONE     0003
DIST 5770DG1  710  SI48091   NONE     0000



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 'SE63116' :
-------------------------------
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.

CIRCUMVENTION FOR APAR 'SE63116' :
----------------------------------
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 5761JV1 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.

********************************************************************
THE FOLLOWING ARE SUPERSEDED SPECIAL INSTRUCTIONS. IF THE SUPERSEDED
PTF HAS ALREADY BEEN APPLIED AND ITS SPECIAL INSTRUCTION FOLLOWED,
IT IS NOT NECESSARY TO FOLLOW THAT SPECIAL INSTRUCTION AGAIN.
********************************************************************

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI37069 :
=================================================
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
--------------  ------------------------------------------------------------
   SI56992      OSP-BASEDIR-INCORROUT IBM Navigator for i
   SI53777      OSP-BASEDIR-INCORROUT IBM Navigator for i
   SI53777      OSP-BASEDIR-INCORROUT IBM Navigator for i
   SI53383      OSP-BASEDIR-INCORROUT IBM Navigator for i(SP10)
   SI52672      OSP-BASEDIR-INCORROUT IBM Navigator for i(SP10)
   SI50753      OSP-BASEDIR-INCORROUT IBM Navigator for i(SP9)
   SI50753      OSP-BASEDIR-INCORROUT IBM Navigator for i (SP9)
   SI49568      OSP-BASEDIR-INCORROUT IBM Navigator for i
   SI49568      OSP-BASEDIR-INCORROUT IBM Navigator for i
   SI49029      OSP-BASEDIR-INCORROUT IBM Navigator for i
   SI47573      OSP-BASEDIR-INCORROUT IBM Navigator for i
   SI47573      OSP-BASEDIR-INCORROUT IBM Navigator for i
   SI46592      OSP-BASEDIR-INCORROUT IBM Systems Director Navigator for i (
   SI44613      OSP-BASEDIR-INCORROUT IBM Systems Director Navigator for i
   SI42184      OSP-BASEDIR-INCORROUT IBM Systems Director Navigator for i
   SI41396      OSP-BASEDIR-INCORROUT IBM Systems Director Navigator for i
   SI38958      OSP-BASEDIR-INCORROUT IBM Systems Director Navigator for i
   SI37918      OSP-BASEDIR-INCORROUT Updates for System i Navigator tasks o
   SI37583      OSP-BASEDIR-INCORROUT Updates for IBM Systems Director Navig
   SI37069      OSP Updates for IBM Systems Director Navigator for i
   SI36476      OSP-BASEDIR-INCORROUT IBM i Level 1 Console update for TVT

Summary Information

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


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.1.0"},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG15V","label":"PTF Cover Letters - OS\/400 General"},"Component":"","ARM Category":[],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"V7R1M0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
29 April 2016