MF69457 - LIC-DB-OTHER ADDITIONAL SQL OPTIMIZER INFORMATION IN JOB WAT

TYPE PROGRAM  RELEASE   NUMBER   MIN/MAX  OPTION
---- -------- --------- -------  -------  ------
PRE  5770999  V7R3M0    MF63963   00/00    0000
PRE  5770999  V7R3M0    MF63247   00/00    0000
PRE  5770999  V7R3M0    MF61285   00/00    0000
CO   5770999  V7R3M0    MF69171   00/00    0000
CO   5770999  V7R3M0    MF68832   00/00    0000
CO   5770999  V7R3M0    MF68422   00/00    0000
CO   5770999  V7R3M0    MF68404   00/00    0000
CO   5770999  V7R3M0    MF67552   00/00    0000
CO   5770999  V7R3M0    MF67553   00/00    0000
CO   5770999  V7R3M0    MF67227   00/00    0000
CO   5770999  V7R3M0    MF67228   00/00    0000
CO   5770999  V7R3M0    MF67231   00/00    0000
CO   5770999  V7R3M0    MF66442   00/00    0000
CO   5770999  V7R3M0    MF64765   00/00    0000
DIST 5770SS1  V7R3M0    SI78382   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

-----------------------------------------------
Having trouble identifying SQL queries that are optimizing for
extended periods of time while using Job Watcher.

CORRECTION FOR APAR MA49462 :
-----------------------------
The QRO hash for a given query will now be supplied to Job
Watcher during optimization to help identify the optimizing
query.

CIRCUMVENTION FOR APAR MA49462 :
--------------------------------
None.


Activation Instructions


None.




Special Instructions


None.


Default Instructions

THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   MF69347      OSP-MSGMCH3402-D/TQQQSVRTN USING IFS_OBJECT_STATISTICS OVER
   MF69172      OSP-PAR-940XMISC AQP PICKING WORSE PLAN THAN THE ORIGINAL
   MF68960      LIC-DB-OTHER SQE Total Temporary Storage only set when query
   MF68833      SLIC-DB INFRASTRUCTURE
   MF68816      INTERNAL DATABASE MAINTENANCE
   MF68797      LIC-DB-OTHER New VLOG 0600 BADE if SQE plan too large to sav
   MF68588      LIC-DB-OTHER Internal database maintenance
   MF68552      LIC-DB-OTHER Internal maintenance
   MF68526      OSP-OTHER-PERFM PSEUDO-OPEN QUERY PERFORMS POORLY DUE TO RE-
   MF68491      LIC-DB-OTHER Internal maintenance
   MF68451      OSP-OTHER-PERFM SELECT INTO QUERY IS SOMETIMES TAKING MULTIP
   MF68448      LIC-DB-OTHER Internal maintenance
   MF68426      LIC-DB-OTHER Internal maintenance
   MF68407      LIC-DB-OTHER-PERFM Fix SELECTIVITY for Various Plans
   MF68310      LIC-DB-OTHER Internal Maintenance
   MF68229      LIC-DB-THER-PERFM Add code static to Field Proc limitation f
   MF68193      OSP-OTHER-INCORROUT COLLECTION SERVICE DATA REPORTING INCORR
   MF68065      SQL-RUN-INCORROUT AQP INTERMITTENT - CURRENT REGISTER DATE R
   MF67735      LIC-DB-OTHER Fix problem with targeted tracing and AQP withi
   MF67554      LIC-DB-OTHER-UNPRED Base support for query monitoring
   MF67298      LIC-DB-THER-PERFM Add code static to Field Proc limitation f
   MF67229      LIC-DB-OTHER-UNPRED Base support for query monitoring
   MF67186      LIC-DB-OTHER Serviceability enhancements
   MF67178      LIC-DB-OTHER Fix problem with targeted tracing and AQP withi
   MF67085      LIC-DB-OTHER Internal Maintenance
   MF67081      OSP-DB-OTHER-SRCB6005121-UNPRED SRCB6005121 - COMPLEX QUERY
   MF66649      OSP-DB-OTHER-WAIT BACKUP JOBS HOLDING SEIZES FOR INDEXES FOR
   MF66626      LIC-DB-OTHER Improve SQE plan cache storage clean up
   MF66441      OSP-DB-OTHER-MSGSQL0901 AFTER PTFS INSTALLED, JOB STARTED TO
   MF66416      OSP-DB-OTHER-INCORROUT SELECT STMT WITH FIELDPROC RETURNS IN
   MF65868      OSP PERIODICALLY A SQL STATEMENT RUNS LONG.
   MF65837      LIC-DB-OTHER-UNPRED CLIENT FOUND LOTS OF 0600BADA VLOGS GENE
   MF65593      LIC-DB-OTHER-PERFM ACCESSING SQE TOOLING CAUSES MACHINE GATE
   MF65548      OSP-MSGMCH3203 FUNCTION CHECK PERFORMING ASSERT ON A LONG, C
   MF65517      LIC-DB-OTHER Internal maintenance
   MF65333      LIC-DB-OTHER IMPROVE SQE TARGETED TRACING
   MF65268      LIC-DB-OTHER-PERFM SQL OPTIMIZATION TIME PERFORMANCE ISSUE W
   MF65203      OSP-DB-OTHER-PERFM GATE CONTENTION ON HEAP ALLOCATIONS DURIN
   MF65184      OSP-DB-OTHER-PERFM INTERMITTENT POOR QUERY PLANS FOR INSERT
   MF65176      LIC-DB-OTHER-UNPRED MANY 0600BADD VLOGS ARE GENERATED WITH N
   MF65052      OSP-OTHER-PERFM JOIN QUERY PERFORMANCE
   MF65042      OSP-PAR-940XMISC PLANS THAT MAY BE IN USE FROM JOBS IN ONE P
   MF64910      LIC-DB-OTHER-F/HMDERIVEDHEAPX/1722-MSGMCH3203 HEAP LEAK CAUS
   MF64829      LIC-DB-OTHER-UNPRED DB SERVER JOBS ARE FLOODED WITH POST AQP
   MF64764      LIC-DB-OTHER Internal Maintenance
   MF64512      OSP-OTHER-PERFM QUERY PERFORMS POORLY WHEN SKEWED DATA IS PR
   MF64407      LIC-DB-UNPRED Query referencing freed storage after vlog
   MF64291      OSP-PERFM SQL BAD ESTIMATE AQP
   MF64271      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF64076      OSP-DB-OTHER-F/DBOPEXPRQDSX/01FE88-T/QQQOOODBOPX/5118- MSGMC
   MF64006      LIC-DB-OTHER Internal Database Maintenance.
   MF63945      LIC-DB-PERFM reorder predicates based on selectivity
   MF63924      OSP-INCORROUT PLANCACHE SNAPSHOT MISSES 'PLAN CREATION USER
   MF63767      LIC-DB-OTHER-F/DBOPRELTABLEMISC-T/QDBGETMQO-MSGMCH3203 MSGMC
   MF63538      OSP-DB-OTHER-F/DBOPRELTABLEMISC-T/QQQOOODBOPX/5000 SELECT ST
   MF63411      OSP-DB-OTHER-F/IXMACHINEINDEXEXTEND-T/QDBPUTMX-MSGMCH2804 MS
   MF63403      OSP-OTHER-PERFM IMPROVEMENT TO PSEUDO_OPEN_CHECK_HOST_VARS Q
   MF63374      LIC-DB Internal maintenance
   MF63345      LIC-DB-Other Improve AQP Error Handling
   MF63341      LIC-DB Improve AQP's ability to re-optimize LPG plans
   MF63297      LIC-DB Internal Maintenance
   MF62179      LIC-DB-OTHER-F/DBLISTHOME-T/QQQOOODBOP-MSGMCH0601 A COMPLEX
   MF63225      LIC-DB-OTHER-PERFM SQL GETTING HARD CLOSED REASON CODE IN DB
   MF63158      OSP-OTHER-PERFM QUERY RE-OPTIMIZATIONS OCCURRING
   MF63149      OSP-DB-OTHER-SRCB6XX0302-UNPRED AQP THREADS CORRUPTING THE S
   MF63148      LIC-DB-OTHER-INCORRECT INAVIGATOR PLAN CACHE ANALYSIS OF ACC
   MF62831      LIC-DB-OTHER-PERFM Reduce the system overhead for QSYS2/SYSI
   MF62814      LIC-DB-OTHER Internal maintenance
   MF62755      LIC-DB-UNPRED Failure tracing Query
   MF62645      OSP-DB-OTHER-F/DBPMTRAP-T/QDBGETM-MSGMCH3203 MSGMCH3203 F/DB
   MF62560      OSP-DB-PERFM Unnecessary hard close of open data path for qu
   MF62522      LIC-DB-OTHER-PERFM REMOVE CORRECT PLAN FROM PLAN CACHE
   MF62516      LIC-DB-OTHER Unable to VE very complex plan from Plan Cache
   MF62458      LIC-DB-OTHER IS NULL index advice ordering.
   MF62382      LIC-DB-OTHER Internal Maintenance
   MF61335      LIC-DB Internal Maintenance
   MF62302      LIC-DB-PERFM SMP support for OLAP queries
   MF61932      LIC-DB-OTHER Internal database maintenance
   MF62182      LIC-DB-OTHER-THREADS-PERFM SYSTEM PERFORMANCE AFFECTED BY AQ
   MF62182      LIC-DB-OTHER-PERFM INFLUX OF QUERY REOPTIMIZAITONS
   MF62061      LIC-DB-OTHER-PERFM QUERY PERFORMS POORLY DUE TO BAD STATISTI
   MF61931      OSP-DB-OTHER-WAIT SUPERVISOR HEAP GROWTH DUE TO PENDING SIGN
   MF61877      LIC-DB-OTHER-UNPRED SQE ROQ USAGE IN PLAN CACHE GROWING DAIL
   MF57967      LIC-DB-PERFM Improve re-use of temporary results with Concur
   MF61787      OSP-DB-OTHER-F/DBOPEXPRQDS-T/QQQOOODBOP-MSGMCH3203 VL0600BAD
   MF61787      OSP-DB-OTHER OUTPUT QRO HASH OF QUERY INITIATING MTI IN TRAC
   MF61208      OSP-PAR-940XBASE ALLOW REMOVAL OF NON-SHAREABLE MTIS IN A MO
   MF61208      OSP-PAR-940XBASE ALLOW REMOVAL OF NON-SHAREABLE MTIS IN A MO
   MF61662      F/DBOPEXPRVALMISC-MSGMCH3203 R720 MCH3203 T/QQQOOOUPCL F/DBO
   MF61289      LIC-DB Offload long EKR estimates found during optimization
   MF61218      OSP-INCORROUT VISUAL EXPLAIN 3 OF TIMESTAMPS ARE INCORRECT.
   MF61188      LIC-DB-OTHER-UNPRED QUERY/400 MAY USE LARGE AMOUNTS OF TEMPO
   MF61188      LIC-DB-OTHER-MSGMCH1202 WHEN BLANK RECORDS RETURNED FROM SQL
   MF61188      OSP-DB SYSTEM CRASH WITH SRCB6000302
   MF61188      LIC-DB-OTHER-PERFM SQE OPTIMIZER AQP FUNCTIONALITY SUBSTITUT
   MF60945      OSP-OTHER-PERFM LONG OPTIMIZATION TIME DUE TO NUMEROUS UDFS/
   MF63759      LIC-DB-PERFM Database Monitor 3010 record

Summary Information
System..............................  i
Models..............................  
Release.............................  V7R3M0
Licensed Program....................  5770999
APAR Fixed..........................  View details for APAR MA49462
Superseded by:......................  View fix details for PTF MF69714
Recompile...........................  N
Library.............................  QSYS
MRI Feature ........................  NONE
Cum Level...........................  NONE

IBM i Support