IBM Support

SI65705 - OSP-INCORROUT FILTER NOT WORKING AS EXPECTED FOR INDEX ADVIS

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-INCORROUT FILTER NOT WORKING AS EXPECTED FOR INDEX ADVIS


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770SS1  710  SI65530   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 'SE67971' :
-------------------------------
1.IBM Navigator for i now includes a listing of IBM i SQL
Services.  This list can be accessed under the System node in
the navigation area. You can also run sample SQL for each
service by launching to the ACS Run SQL window.

2.IBM Navigator for i now includes the ability to create and
change a job queue.  These tasks are available from the job
queue lists, and also from the All Tasks node under Work
Management, as well as from the search area.

3.IBM Navigator for i now includes the ability to create and
change subsystem descriptions, create and change a class from
All Tasks node under Work Management, as well as from the search
area. It also includes the ability to create a class when adding
a new routing entry for subsystem description.

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

DESCRIPTION OF PROBLEM FIXED FOR APAR 'SE67650' :
-------------------------------------------------
Unable to update the Authorization List option for PUBLIC
Authority in IBM Navigator for i.

CORRECTION FOR APAR 'SE67650' :
-------------------------------
The reported problem is fixed in this PTF. The Authorization
List option for PUBLIC Authority can be checked if the
Authorization list type is not equal to "(None)".

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

DESCRIPTION OF PROBLEM FIXED FOR APAR 'SE68031' :
-------------------------------------------------
When logged into IBM Navigator for i, if you click the Disk
Units, you get prompted for a User ID and Password for Service
Tools. After putting in those credentials and hitting enter the
fields, there is no response. However the same SST user profile
can log in via green screen.

CORRECTION FOR APAR 'SE68031' :
-------------------------------
The reported problem has been fixed in this PTF. Now the length
of the SST user profile is changed to be no longer than ten, in
place of eight.

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

DESCRIPTION OF PROBLEM FIXED FOR APAR 'SE68010' :
-------------------------------------------------
When customer logs into IBM Navigator for i, expands Databases
in left-pane and then expands Databases again nothing is showed
on the left-pane. The right-pane does contain the databases.
When this occurs WRKFCNUSG on the IBM i does not have the
QIBM_XD1_OPNAV_DBLIBS entry registered. In most cases
QIBM_XD1_OPNAV_xxxxxx entries are not there at all.
Fix will allow access when the Function has not been registered.

CORRECTION FOR APAR 'SE68010' :
-------------------------------
Changes will be made to IBM Navigator for i to allow access to
functions if the function has NOT been registered on the IBM yet
via Application Administration.  Administrators should, however,
use Application Administration to set the desired access for
their users.

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

DESCRIPTION OF PROBLEM FIXED FOR APAR 'SE66563' :
-------------------------------------------------
When using Index Advisor in IBM Navigator for i, a filter
selection for "Average of Query Estimates Greater than or equal
to 0.001", the results still contain records that have values of
0.000.

CORRECTION FOR APAR 'SE66563' :
-------------------------------
IBM Navigator for i has been updated to fix this problem.  The
"Average of Query Estimates" column will now show the full four
decimal places for the value, and filtering of the column will
now work as expected.

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

DESCRIPTION OF PROBLEM FIXED FOR APAR 'SE66827' :
-------------------------------------------------
Using IBM Navigator for i, click on Application Administration
on the left pane. This results in the right pane showing the
Application Administration tab, but nothing more (blank).

CORRECTION FOR APAR 'SE66827' :
-------------------------------
A fix has been made to Navigator for i to correctly display the
Application Administration panel.

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

DESCRIPTION OF PROBLEM FIXED FOR APAR 'SE68242' :
-------------------------------------------------
When launching the DHCP Monitor from the IBM Navigator for i,
the screen flashes and go back to the panel TCP/IP server. No
error is given. The profile running the monitor needs *IOSYSCFG
authority which it does have through it's associated group
profile.

CORRECTION FOR APAR 'SE68242' :
-------------------------------
The reported problem is fixed in this PTF. Now the user's group
authority can be checked when performing the function DHCP
Monitor.

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


Activation Instructions

None.




Special Instructions


This PTF will enable IBM i Navigator for Java 8.  To ensure Java 8 will
be used, make sure licensed program 5761JV1 option 17 (Java SE 8 64
bit) is installed before applying this PTF.

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.
********************************************************************

IBM Navigator for i running on admin2 uses 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.


Before applying this PTF, please ensure HTTP PTF Group SF99368 level 46
(or later) is installed.

IBM Navigator for i running on admin2 uses 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.


IBM Navigator for i running on admin2 uses 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.


IBM Navigator for i running on admin2 uses 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)


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)


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.

1. Enter the following command to stop the QHTTPSVR subsystem before
applying
PTE:
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)

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
--------------  ------------------------------------------------------------
   SI65529      OSP-BASEDIR-INCORROUT IBM Navigator for i
   SI64943      OSP-BASEDIR-INCORROUT IBM Navigator for i
   SI64943      OSP-INCORROUT NAVIGATOR FOR I PTF COMPARE AND UPDATE FUNCTIO
   SI64943      OSP-BASEDIR-INCORROUT NOT ALL SUFFIXES DISPLAY WHEN BROWSING
   SI64943      OSP-XTND EIM MAPPING POLICY IS SHOWING GREYED OUT ON I NAVIG
   SI64943      OSP-BASEDIR-THREADS ERROR OCCURRED WHILE CREATING DOMAIN EIM
   SI64943      OSP-MSGGROUPREGISTRYOPTIONMISSINGFROMEIM GROUP REGISTRY OPTI
   SI64943      OSP-BASEDIR-INCORROUT ADMIN2 IS CREATING COOKIES WITHOUT THE
   SI63768      OSP-BASEDIR-INCORROUT IBM Navigator for i
   SI63492      OSP-BASEDIR-INCORROUT IBM Navigator for i
   SI62076      OSP-BASEDIR-INCORROUT IBM Navigator for i
   SI62072      OSP-BASEDIR-INCORROUT IBM Navigator for i
   SI60517      OSP-BASEDIR-INCORROUT IBM Navigator for i
   SI60517      CA400EXP-OPNAV-OUTPUT-INCORROUT-PRT CAN NOT EXPORT IPDS SPOO
   SI60150      OSP-BASEDIR-INCORROUT IBM Navigator for i
   SI59084      OSP-BASEDIR-INCORROUT IBM Navigator for i
   SI59084      OSP-BASEDIR-INCORROUT Add a program to add service entry to
   SI59084      HTTPSVR-UNPRED ENABLE TLSV1.2 FOR HTTPADMIN PORT 2005
   SI58230      OSP-BASEDIR-INCORROUT IBM Navigator for i
   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 SE67971
View details for APAR SE67650
View details for APAR SE68031
View details for APAR SE68010
View details for APAR SE66563
View details for APAR SE66827
View details for APAR SE68242
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:
17 October 2017