IBM Support

MF65697 - OSP-OTHER-PERFM OPNQRYF INTERMITTENTLY PERFORMS POORLY

PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-OTHER-PERFM OPNQRYF INTERMITTENTLY PERFORMS POORLY


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED           PTF/FIX  LEVEL

TYPE PROGRAM  RELEASE   NUMBER   MIN/MAX  OPTION
---- -------- --------- -------  -------  ------
CO   5770999  V7R2M0    MF65696   00/00    0000
CO   5770999  V7R2M0    MF65472   00/00    0000
CO   5770999  V7R2M0    MF65396   00/00    0000
CO   5770999  V7R2M0    MF65125   00/00    0000
CO   5770999  V7R2M0    MF64732   00/00    0000
CO   5770999  V7R2M0    MF64627   00/00    0000
CO   5770999  V7R2M0    MF64629   00/00    0000
CO   5770999  V7R2M0    MF64630   00/00    0000
CO   5770999  V7R2M0    MF64428   00/00    0000
CO   5770999  V7R2M0    MF63669   00/00    0000
CO   5770999  V7R2M0    MF63293   00/00    0000
CO   5770999  V7R2M0    MF62215   00/00    0000
CO   5770999  V7R2M0    MF61310   00/00    0000
CO   5770999  V7R2M0    MF60703   00/00    0000
CO   5770999  V7R2M0    MF59489   00/00    0000
CO   5770999  V7R2M0    MF58880   00/00    0000
CO   5770999  V7R2M0    MF58586   00/00    0000
CO   5770999  V7R2M0    MF57842   00/00    0000
CO   5770999  V7R2M0    MF57843   00/00    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 'IBM License Agreement for Machine
Code', the terms of which were provided in a printed document that was
delivered with the machine.

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.





APAR Error Description / Circumvention

-----------------------------------------------
OPNQRYF intermittently performs poorly.

Applications that perform repeated and limited positioning by
key during the single open of the cursor may intermittently use
more CPU when the file is mostly resident in memory.
The query tends to perform better when the file is not resident
in memory.

CORRECTION FOR APAR MA47489 :
-----------------------------
Changes were made to improve the performance of data space
paging performed during native key positioning.

CIRCUMVENTION FOR APAR MA47489 :
--------------------------------
None.


Activation Instructions


None.




Special Instructions


********************************************************************
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 MF64003 :
=================================================

This PTF resolves a potential hang condition that can occur due to an
orphaned resource during SQL Cancel processing of an SMP query.  It
ensures that SQL Cancel processing will be handled properly after
application.  However, if SQL Cancels have been performed on SMP
queries prior to this PTF application, it would be prudent to schedule
an IPL as soon as possible.


Default Instructions

THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   MF65575      LIC-DB-OTHER-PERFM Certain SQL queries specifying USE CURREN
   MF65470      LIC-DB-OTHER-F/DBPMTRAP-T/QQQSRVE1-RC1720-MSGMCH3203 SQL que
   MF65327      SQL-RUN-INCORROUT FETCH RELATIVE - RETURNS DUPLICATE ROWS -
   MF65341      LIC-DB-OTHER-LOOP DATABASE IS LOOPING DOING INDEX LOOK-UPS
   MF65283      OSP-LOOP ENDJOB *CTLD & *IMMED AND ENDJOBABN UNSUCCESSFUL
   MF65127      OSP-F/QSQRUN2-T/QSQRUN2-MSGSQ20377 XML GENERATING ERROR SQ20
   MF64945      LIC-DB-OTHER-UNPRED 0406  0316 VLOGs generated periodically
   MF64889      LIC-DB-OTHER-INCORROUT JSON_ARRAY AND JSON_OBJECT TRUNCATION
   MF64733      OSP-DB-OTHER-INCORROUT AN OPNQRYF WITH KEYFLD AND GRPFLD PAR
   MF64671      LIC-DB-OTHER-INCORROUT Intermittent incorrect results from S
   MF64648      LIC-DB-OTHER-F/QRCDMGLG-T/QSYSOPR-MSGCPF8174 Full damage on
   MF64628      OSP-DB-OTHER-UNPRED SQE CHANGED TO HOLD JOBS WHEN QUERY RELA
   MF64465      LIC-DB-OTHER-INCORROUT OPNQRYF cursor may return incorrect r
   MF64426      LIC-DB-OTHER-F/DBPMRESOURCE-T/QDBGETMQO-RC1202-MSGMCH3203 VL
   MF64304      OSP-DB-OTHER-INCORROUT PAGE UP OR DOWN SHOWS INCORRECT RECOR
   MF64285      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF64266      OSP-DB ACCESS PATHS MAY REBUILD MULTIPLE TIMES.
   MF64205      LIC-DB-OTHER-INCORROUT Reversing the scrolling direction of
   MF64083      OSP-DB-OTHER-F/DBPMTRAP-T/QDBGETMQO-MSGMCH3203 MSGMCH3203 F/
   MF64036      LIC-DB Internal Maintenance
   MF64019      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF63967      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF64003      OSP-DB-OTHER-UNPRED SQL CANCEL EXCEPTION QEO HANG
   MF63667      LIC-DB-OTHER-PERFM SQL Limit/Offset support
   MF63414      OSP-DB-OTHER-MSGCPI0999 XMLAGG QUERIES MAY RESULT IN LARGE A
   MF63488      OSP-F/DBPMDINPROBENODE-T/QDBGETSQ-MSGMCH3601 AFTER LOADING T
   MF63295      LIC-DB Internal Maintenance
   MF62987      LIC-DB-OTHER-INCORROUT RCAC SQE NATIVE ACCESS AND RPGLE %EQU
   MF62607      LIC-DB-OTHER-F/#DBXBINX-MSGMCH1807 followed by MSGCPF4204 an
   MF62599      F/00000 WANTING TO USE &#10 IN XML ATTRIBUTES
   MF62253      LIC-DB-OTHER Internal database maintenance
   MF62216      OSP-DB-OTHER-INCORROUT INCORROUT FOR SQL USING COUNT, UNLESS
   MF62120      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF61888      OSP-DB-OTHER-INCORROUT SQL CLI SQLFETCHSCROLL BEHAVIOR CHANG
   MF61660      OSP-DB-OTHER-INCORROUT for key positioning, if OPNQRYF KEYFL
   MF61481      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF61348      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF61311      OSP-DB-OTHER-PERFM AFTER DELETION OF RECORDS A SELECT COUNT
   MF61224      LIC-DB-OTHER-LOOP a query accessing a table that is being re
   MF60863      OSP-INCORROUT OPNQRYF with QRYSLT may return incorrect outpu
   MF60708      LIC-DB-INCORROUT IBM i returned incorrect data at PCOMM data
   MF60677      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF60610      OSP-OTHER-PERFM OPNQRYF PERFORMING POORLY AND USING A LOT OF
   MF60542      OSP-DB-OTHER-F/DBPMTRAP-T/QDBGETKY-MSGMCH3203 A MSGMCH3203 M
   MF60457      LIC-DB Allow UTF-16 casing map
   MF60356      OSP-DB IT IS POSSIBLE THAT INCORRECT OUTPUT COULD BE GENERAT
   MF60311      OSP-DB-OTHER-INCORROUT RUNQRY SHOW '+' INSTEAD OF DATA. RESU
   MF60232      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF60094      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF60049      LIC-DB Internal Maintenance
   MF59994      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF59926      LIC-DB-OTHER-INCORROUT QUERY/400 INCORRECTLY DISPLAYING FIEL
   MF59873      LIC-DB-OTHER Internal maintenance
   MF59711      LIC-DB-OTHER-INCORROUT SQE native key next or previous equal
   MF59510      OSP-DB OPNQRYF FAILING AT R720 WITH MSGMCH3203 T/QDBGETKY WI
   MF59487      LIC-DB-OTHER-PERFM Performance improvements for SQE EVI Acce
   MF59300      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF59288      LIC-DB-OTHER-F/DBPMTRAP-T/QDBPUT-RC X'1720'-MSGMCH3203 Inser
   MF59120      QRY-QRYCPY-INCORROUT A PROBLEM HAS BEEN FOUND IN SQE PACKED
   MF59081      LIC-DB-OTHER-PERFM Performance improvements for SQE EVI Acce
   MF58960      OSP-DB-OTHER-INCORROUT A QUERY WITH A -CAST(-2147483648 AS I
   MF58881      LIC-DB-OTHER-INCORROUT SQE query referencing column with fie
   MF58865      LIC-DB-OTHER-F/QDBSIGEX-MSGCPF5040 Attempt to read by RRN fr
   MF58584      LIC-DB-OTHER-PERFM An SQL CANCEL of an SMP query may take an
   MF58465      OSP- MCH6206 Commitment control resource limit overflowed, R
   MF58364      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF58307      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF58278      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF58047      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF57905      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF57617      OSP-DB-OTHER-INCORROUT An MTI initially created over an empt
   MF57839      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF57656      LIC-DB-OTHER-UNPRED Internal Database Maintenance

Summary Information

System.............................. i
Models..............................
Release............................. V7R2M0
Licensed Program............... 5770999
APAR Fixed.......................... View details for APAR MA47489
Superseded by:...................... View fix details for PTF MF66321
Recompile........................... N
Library............................. QSYS
MRI Feature ........................ NONE
Cum Level........................... C9123720


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

Document information

More support for: i family

Software version: V7R2M0

Operating system(s): OS/400

Reference #: MF65697

Modified date: 06 March 2019