PTF Cover Letter
PTF ( Program Temporary Fixes ) Cover letter
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 |
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.
Was this topic helpful?
Document Information
Modified date:
29 April 2016