IBM Support

MF61656 - LIC-DB-OTHER-INCORROUT Left outer join query returns wrong r

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

LIC-DB-OTHER-INCORROUT Left outer join query returns wrong r


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770999  710  MF61138   00/00    0000
PRE  5770999  710  MF58711   00/00    0000
PRE  5770999  710  MF55844   00/00    0000
CO   5770999  710  MF61661   00/00    0000
CO   5770999  710  MF61275   00/00    0000
CO   5770999  710  MF61277   00/00    0000
CO   5770999  710  MF61276   00/00    0000
CO   5770999  710  MF59650   00/00    0000
CO   5770999  710  MF58780   00/00    0000
CO   5770999  710  MF58649   00/00    0000
CO   5770999  710  MF51399   00/00    0000
CO   5770999  710  MF48118   00/00    0000
DIST 5770SS1  710  SI56556   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

-----------------------------------------------
Wrong results may be produced for a query involving a LEFT OUTER
JOIN if the join predicate contains a value derived from a
column value. If that same derived value is included in the
query output by the SELECT clause, the value may be incorrect
for some rows. Note that the derivation may be explicit (e.g.
SUBSTR) or implicit (a cast of a numeric value to a character
value).

CORRECTION FOR APAR MA45434 :
-----------------------------
In order to improve the speed of query results, the SQE
optimizer evaluates values only when necessary. Because of the
column value's presence in the join predicate, the optimizer
concluded that the column value had already been evaluated by
the right side of the LEFT OUTER JOIN. However, this assumption
did not hold for the join exception row, leading to an
unspecified value being produced for exception rows. This fix
ensures that the value is unconditionally evaluated after the
join so that the correct value accompanies all rows.

CIRCUMVENTION FOR APAR MA45434 :
--------------------------------
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 MF57002 :
=================================================

The customer should clear out the system wide index advice table so as
not to be confused by the duplicate key advice that was incorrectly
generated per this problem.  After clearing out the bad advice, new
index advice will automatically be generated through the ongoing use of
SQL.

SQL:  delete from qsys2.sysixadv


Default Instructions

THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   MF61634      LIC-DB-OTHER-MSGMCH3203-F/DBOPAFFINITY-T/QQQOOODBOP followed
   MF61274      LIC-DB-PERFM - EAO with Partitioned Tables
   MF61187      OSP-DB-OTHER-SAP400 INDEX ADVISER IS SETTING SORT TABLE TO *
   MF61135      OSP-DB-OTHER-F/DBPMTRAP-T/QQQOOODBOP-MSGMCH3203 VL0600BADD V
   MF60779      LIC-DB-OTHER-INCORROUT SQL LOCATE with VARCHAR columns and t
   MF60759      LIC-DB-PERFM SQL EVI Only Access query optimization techniqu
   MF60745      LIC-DB-INCORROUT SMP XML INCORRECT OUTPUT AFTER UPGRADE
   MF60698      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF60600      LIC-DB-OTHER-INCORROUT SPECIAL REGISTER VALUE INCORRECTLY RE
   MF06005      LIC-DB-UNPRED Plan cache snapshot may cause unpredictable be
   MF60515      OSP-DB-OTHER-UNPRED VL0600A1B8 PLANCACHE
   MF60514      LIC-DB-OTHER-LOOP IMPROVE THE MANAGEMENT OF SPARSE MTIS IN A
   MF60503      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF60488      LIC-DB-OTHER-UNPRED HIGH TEMP STORE USAGE FROM HEAP SEGMENT
   MF60476      OSP-DB-OTHER-PERFM SELECT/OMIT INDEX NO LONGER BEING USED
   MF60345      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 A MSGMCH3203 M
   MF60183      LIC-DB-UNPRED Temps and Concurrent Access Resolution of Skip
   MF60129      LIC-DB-OTHER-PERFM EXCESSIVE TEMPORARY STORAGE CONSUMPTION A
   MF60033      LIC-DB-OTHER-INCORROUT OLAP ORDER BY ASC NULLS FIRST WITH NU
   MF60005      LIC-DB-OTHER Add MEMORY_POOL_PREFERENCE QAQQINI OPTION TO VE
   MF59982      LIC-DB-OTHER-INCORROUT Left outer join queries executed with
   MF59911      OSP-OTHER-PERFM LONG OPTIMIZATION TIME DUE TO NUMEROUS UDFS/
   MF59791      LIC-DB-OTHER Internal maintenance
   MF59791      LIC-DB-OTHER Internal maintenance
   MF59764      OSP-PERFM SQL PERFORMANCE PROBLEM WITH JOIN LF AFTER MIGRATI
   MF59753      LIC-DB-OTHER-PERFM IMPROVE SQL PLAN VALIDATION
   MF59654      LIC-DB-UNPRED Ensure order of partitions in partitioned tabl
   MF59654      LIC-DB-OTHER MCH3602 DbopReferenceDataTable with array host
   MF59697      LIC-DB-PERFM Query with Partitioned table
   MF59410      OSP-PERFM QUERIES AT R710 ARE RUNNING SLOWER UNLESS THE INLI
   MF59402      OSP-DB-OTHER-F/#CFOCHKR-T/QDMCOPEN-MSGMCH2601 QZDASOINIT JOB
   MF59336      LIC-DB-PERFM Probe Predicate not completely normalized
   MF58062      OSP-PERFM QUERY PERFORMS POORLY WHEN SYMMETRIC MULTIPROCESSI
   MF57255      LIC-DB-OTHER-PERFM Queries which preload partitioned tables
   MF56939      OSP-PERFM QUERY OPTIMIZATION TAKES TOO LONG WHEN MANY INDEXE
   MF56850      LIC-DB-MSGMCH3203 COUNT DISTINCT query in DbopStatDadIndex
   MF56785      OSP-DB-OTHER-PERFM PARTITIONED TABLE PROBE COSTING NEEDS TO
   MF55258      LIC-DB-OTHER problems tracing partitioned table queries
   MF54885      LIC-DB-PERFM Bad Plan for Partitioned Table Queries
   MF54047      LIC-DB-MSGSQL0901 QUERY FAILS WHEN TRACING ENABLED
   MF53638      OSP-DB-OTHER-F/DBOPRELINDEX-T/QQQOOODBOP-MSGMCH3601 SQL SELE
   MF52464      LIC-DB Connect By infrastructure
   MF51926      LIC DB - 0600 BADD LIC logs from removeIter
   MF51475      OSP-DB-OTHER Enable in memory files for indexes
   MF51382      LIC-DB-PERFM SQE optimization performance
   MF51382      LIC-DB Improve query optimization for select/omit indexes
   MF49930      LIC-DB-PERFM Improve EVI with INCLUDE costing in low memory
   MF51184      OSP-DB Creation of SQL deflated table
   MF50598      LIC-DB-OTHER Internal Maintenance
   MF48347      OSP DB OTHER Partition tables and aggregate EVIs
   MF47927      LIC-DB-MSGMCH3601  DbopStatDadIndexMisc + 00014694
   MF59330      LIC-DB-OTHER DATABASE MONITOR 3010 RECORD MISSING
   MF59240      LIC-DB-OTHER-PERFM HIGHER CPU CONSUMPTION FOR QUERY AFTER AP
   MF59006      OSP-DB-PERFM MQT not matching with CASE and  IN LIST values
   MF58972      OSP-PERFM QUERIES AT R710 ARE RUNNING SLOWER UNLESS THE INLI
   MF58912      LIC-DB-OTHER-PERFM DISTINCT QUERY TAKES TWICE AS LONG AFTER
   MF58886      LIC-DB-OTHER Internal Maintenance
   MF58829      LIC-DB-OTHER-PERFM QUERY OPTIMIZER DOES NOT IMPLEMENT VIA AN
   MF58782      LIC-DB-Other Internal Maintenance
   MF58769      OSP-UNPRED RPG PROGRAM WITH EMBEDDED SQL RETURNS NO RESULT S
   MF58744      OSP-DB-OTHER-INCORROUT Round, ceiling and floor may produce
   MF58722      LIC-DB-OTHER Internal Maintenance
   MF58731      LIC-DB-OTHER-PERFM SMP IMPLEMENTATION LEADS TO POOR SQL QUER
   MF58421      OSP-DB SOME FUNCTIONS IN VISUAL EXPLAIN MAY FAIL IF AN INDEX
   MF58243      OSP-DB-OTHER-F/QDBIOERRQO-T/QSQRUN2-MSGCPF503E MSGSQL0502-F/
   MF57556      LIC-DB-OTHER-INCORROUT Queries which group over LOB columns
   MF57546      OSP-DB-OTHER-INCORROUT THE CUSTOMER IS SEEING INCONSISTENT O
   MF57497      LIC-DB-OTHER-PERFM SMP QUERY EXECUTION IS PREVENTED BY HIGH
   MF57035      LIC-DB-OTHER-INCORROUT SQL OPTIMIZER USING SPARSE INDEXES WI
   MF57025      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 MSGMCH3203 F/A
   MF57003      OSP-DB-OTHER-INCORROUT SYSIXADV RECOMMENDS FIELDS MORE THAN
   MF56938      OSP-PERFM QUERY OPTIMIZATION TAKES TOO LONG WHEN MANY INDEXE
   MF56302      LIC-PERFM LARGE NUMBER OF SEIZES DURING ON SPARSE MTIS OPTIM
   MF56180      LIC-DB-OTHER-F/DBOPOPERATIONMISC-T/QQQOOODBOP-MSGMCH3601
   MF56068      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 QUERY DBOP ISS
   MF55950      LIC-DB-MSGMCH3601 relating to partitioned tables and EVIs
   MF55835      OSP-DB-OTHER-PERFM OPTIMIZATION ENHANCMENT
   MF55733      LIC-DB-OTHER-MSGMCH3203 Queries of aggregate DISTINCT data w
   MF55617      LIC-DB-INCORROUT INDEX CREATED OVER PARTITIONED TABLE WILL C
   MF55500      LIC-DB-UNPRED Using LOBs as input to UDTF
   MF55420      LIC-DB-PERFM LONG OPTIMIZATION TIMES WITH HIGH NUMBER OF SEL
   MF54693      LIC-DB-MSGMCH3402 0600 BADD VLOG Running Partitioned Table Q
   MF54573      LIC DB - Query fails due to lost seize during MTI creation
   MF54296      LIC-DB-PERFM Union QDS's incorrectly requesting preload on r
   MF54024      LIC-DB-PERFM-OTHER Problems with costing Select/Omit indexes
   MF53024      LIC-DB-OTHER-PERFM COMPLEX QUERY PLAN IS TOO LARGE TO BE SAV
   MF52460      LIC-DB Connect by infrastructure
   MF51927      LIC DB - 0600 BADD LIC logs from removeIter
   MF51499      LIC-DB-MSGMCH3203 Visual Explain with a FieldProc
   MF51381      LIC-DB-PERFM SQE optimization performance
   MF51181      OSP-DB Creation of SQL deflated table
   MF51065      OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0901 SOME SQL CAUSES
   MF51044      LIC-DB-INCORROUT Updatable ORDER BY columns
   MF50597      LIC-DB-PERFM SSD support during query optimization
   MF50597      LIC-DB-OTHER Internal Maintenance
   MF50494      OSP-DB-PERFM Not using MQT when MQT matches query selection
   MF50310      LIC-DB-MSGMCH3203 SQL Field Procedure in a partitioned table
   MF49961      LIC-DB-OTHER LPG HIGHLIGHTING IS NOT WORKING CORRECTLY IN TH
   MF49961      LIC-DB SQL Support Select/Omit indexes with FieldProcs
   MF49924      LIC-DB-PERFM Improve EVI with INCLUDE costing in low memory
   MF49552      LIC SMP CAN CHOOSE A VERY HIGH SMP NUMBER WHEN USING EVI'S
   MF49401      OSP-DB-MSGMCH3601 F/T:DbopOperationMisc/QQQOOODBOP
   MF49393      LIC-DB-MSGMCH3203 SQL Array and XML Agg
   MF49386      LIC-DB-INCORROUT COLLATE_ERRORS *YES not being honored for G
   MF48790      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-RC1720-MSGMCH3203 COMPLEX
   MF48774      LIC-DB-SQL Add long index schema to dbmon
   MF48676      LIC DB MSGMCH3203 DbpmTrap sAttributeOperationRefreshFailed
   MF48600      LIC-DB-MSGMCH3203 SQL Arrays
   MF48491      LIC-DB-MSGMCH3203 SQL Arrays
   MF48568      LIC-DB SQL query does not complete.
   MF48346      OSP DB OTHER Partitioned table and aggregate EVI support
   MF47920      LIC-DB-OTHER-MSGCPF4204 CPF4204 WHEN RUNNING OVER LARGE PART
   MF58650      LIC-DB-OTHER Internal maintenance
   MF58681      LIC-DB-OTHER-INCORROUT SYSTEM CRASH DURING NORMAL OPERATIONS
   MF58575      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 SQL SELECT STA
   MF58026      LIC-DB-OTHER-PERFM DELETE STATEMENT WITH NOT IN PREDICATE IS
   MF57876      OSP-DB-OTHER-F/QQQOOODBOP-T/QQQOOOINV-MSGMCH3203 QUERIES FAI
   MF57808      LIC-DB-PERFM Excessive optimization time when MQTs enabled
   MF57576      LIC-DB-MSGMCH3603 MSGMCH3603
   MF57391      OSP-DB-OTHER-UNPRED LOB USED IN SQL CAUSES HUGE TEMPORARY ST
   MF57359      OSP-DB-OTHER-INCORROUT A QUERY INCORRECTLY SELECT NO ROW WIT
   MF57283      OSP-DB-OTHER-LOOP A QUERY WITH NESTED NULLIF, AND MULITPLE O
   MF57203      LIC-DB Optimizer not always observing INI option OPTIMIZE_ST
   MF57002      OSP-DB-OTHER-INCORROUT SYSIXADV RECOMMENDS FIELDS MORE THAN
   MF56937      OSP-PERFM QUERY OPTIMIZATION TAKES TOO LONG WHEN MANY INDEXE
   MF56804      OSP-DB-OTHER-T/QQQOOODBOPX/4655-MSGMCH3203 SELECT STMT FAILS
   MF56593      SQL-DB-PERFM Index advice for ORed predicates
   MF56580      OSP-DB-PERFM Visual Explain while running fails for short ru
   MF56485      LIC-DB-UNPRED Update of self-referencing view
   MF56352      LIC-DB-OTHER-PERFM COMPLEX QUERY REOPTIMIZES TOO OFTEN
   MF56254      OSP-DB SQL Plan Cache - filter by index advise key columns
   MF56175      OSP-PERFM OPTIMIZER RECOMMENDS EVI OVER A PRIMARY KEY
   MF56067      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 QUERY DBOP ISS
   MF56035      OSP-INCORROUT OSP INCORROUT PLANCACHE POOLID
   MF56023      LIC-DB Fix optimizer code to be compatible with xpf compile
   MF56015      LIC-DB-OTHER-F/DBPMTRAP-T/QQQOOODBOP-MSGMCH3203 USING EMPTY
   MF55986      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 A MSGMCH3203 F
   MF55979      OSP-DB-OTHER QQQOOODBOP MSGMCH3402 Assert XMLTABLE
   MF55944      LIC-DB-PERFM Performance Problems when DBMON active
   MF55868      LIC-DB-PERFM Overflow condition on EVI with INCLUDE over tab
   MF55854      LIC-DB-OTHER-INCORROUT Grouping set queries with concatenati
   MF55836      OSP-DB-OTHER-PERFM OPTIMIZATION ENHANCMENT
   MF55768      OSP-DB Visual Explain, Not able to explain a query access pl
   MF55720      LIC-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 COMPLEX SQL QU
   MF55669      OSP-DB-OTHER-INCORROUT INCORRECT OUTPUT ON QUERY WITH COMMON
   MF55652      OSP-OTHER-PERFM QUERY PERFORMANCE. LONG OPTIMIZATION TIME. P
   MF55498      LIC-DB-UNPRED Using LOBs as input to UDTF
   MF55413      LIC-DB-PERFM LONG OPTIMIZATION TIMES WITH HIGH NUMBER OF SEL
   MF55265      LIC-DB-OTHER not revalidating on Workload Group changes
   MF55248      LIC-DB Internal maintenance
   MF55142      LIC-DB-PERFM Table Probe IO Costing when secondary in a join
   MF54942      LIC-DB-OTHER Wrong host variables in VE diagram when PSEUDO_
   MF54892      LIC-DB-OTHER SQE Optimizer support for Workload Group
   MF54722      LIC-DB-OTHER Internal Maintenance
   MF54687      OSP-DBPARL-UNPRED QSQSRVR QSQDBXXXXXX SPACE OBJECTS USING TE
   MF54675      OSP-DB Incorrout with Col1 Is Null OR Col1 Is Not Null
   MF54667      OSP-DB-OTHER-F/ASSERTX/004-T/QQQOOODBOPX/4474-RCX1720- MSGMC
   MF54609      OSP-DB-OTHER-T/QQQOOODBOP-MSGMCH3203 SQL UPDATE of MULTI-DS
   MF54387      OSP-DB Perform key selection for LIKE predicate with leading
   MF54330      PERFM-LIC FILTERING BY STATEMENT TEXT ON INAV 'SHOW STATEMEN
   MF54298      LIC-DB-PERFM Remove unnecessary Preload of QDS objects
   MF54293      LIC-DB-INCORROUT XML NULL on NULL
   MF54293      LIC-DB-MSGMCH3203 Common Table expression reference in subqu
   MF54009      LIC-DB-PERFM Change Optimizer Average Active jobs calculatio
   MF53809      LIC-DB Internal maintenance
   MF53742      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 QUERY OVER A F
   MF53718      LIC-DB-PERFM Change Optimizer Average Active jobs calculatio
   MF53591      OSP-DB Internal Maintenance for Database Monitor
   MF53479      LIC-DB-PERFM Add PSEUDO_OPEN_CHECK_HOST_VARS QAQQINI option
   MF53479      LIC-DB-OTHER Translated Keys not showing up as translated on
   MF53479      LIC-DB-MSGSQL0901 Fetching numeric with precision 63
   MF53445      OSP-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 MSGMCH3203 F/ASSE
   MF53227      OSP-DB-OTHER-LOOP AFTER UPGRADING TO R710, A QUERY WITH NEST
   MF53338      OSP-OTHER-PERFM QUERY PERFORMANCE WITH PARTITIONED TABLES
   MF53338      LIC-PERFM CAST(CHAR as TIMESTAMP) index not being used
   MF53163      LIC-DB-OTHER-MSGCPF5035 UPDATE WITH WHERE CLAUSE FAILS WITH
   MF53099      OSP-DB-OTHER-INCORROUT A FIELDPROC MAY SHOW CACHED RESULTS I
   MF53060      OSP-OTHER-PERFM PERFORMANCE DIFFERENCE BETWEEN LEFT AND SUBS
   MF52507      OSP-DB-OTHER-UNPRED SQL ROQ SIZES TOO LARGE AND BEING CACHED
   MF52507      LIC-DB-OTHER-PERFM SQE NOT MATCHING CONCAT DERIVED KEY INDEX
   MF52459      LIC-DB Connect By infrastructure
   MF52414      LIC-DB-PERFM Performance on query of MULTI-DS LFs
   MF52121      LIC-DB INDEX ADVISOR SUGGESTS AN INDEX OVER A 'NOTUSED' COLU
   MF51928      OSP-DB Select/Omit logical files with NULL capable fields
   MF51928      LIC DB - 0600 BADD LIC logs from removeIter
   MF51767      OSP-DB Select/Omit logical files with NULL capable fields
   MF51620      LIC-DB Database optimizer heap leak fix
   MF51436      OSP-DB-OTHER Enable in memory files for indexes
   MF51402      LIC-DB-PERFM SQL queries not honoring pre-load plans
   MF51402      LIC-DB-PERFM SQE optimization performance
   MF51402      OSP-DB-OTHER-LOOP CREATE FUNCTION LOOPS
   MF51402      LIC-DB-PERFM MQT not matching when DECFLOAT
   MF51402      OSP-DB-OTHER-PERFM SQE ONR COSTING TO LOW
   MF51183      OSP-DB Creation of SQL deflated table
   MF51089      LIC-DB-OTHER Internal Maintenance
   MF51043      LIC-DB-INCORROUT Updatable ORDER BY columns
   MF50983      LIC-DB-Other Add support for validating LF mappings
   MF50865      LIC-DB-OTHER Internal maintenance
   MF50596      LIC-DB-OTHER Internal Maintenance
   MF50493      OSP-DB-PERFM Not using MQT when MQT matches query selection
   MF50493      LIC-DB-MSG3203 Assert from generateOperations__25DbopAccessP
   MF50464      LIC-DB-OTHER Plan Cache Dump not showing the correct pool in
   MF50311      LIC-DB-PERFM SQL Field Procedure Index only access
   MF50070      LIC-DB-MSGMCH3402 BADD Vlog DbVisualExplainStream + 000A34
   MF49962      OSP-DB SQL0802 F/QSQRUN2 T/QSQRUN2 HEX of Left Outer Join co
   MF49962      LIC-DB SQL Support Select/Omit indexes with FieldProcs
   MF49925      LIC-DB-PERFM Improve EVI with INCLUDE costing in low memory
   MF49799      OSP-DB Performance enhancement for SQL MERGE statement
   MF49638      LIC-DB-INCORROUT SQL field procedure with cached DecFloat pa
   MF49553      LIC-DB-OTHER-PERFM QUERY WITH MANY VALUES IN AN IN PREDICATE
   MF49553      OSP-DB-OTHER-UNPRED MCH3203 FROM ASSERT TO QQQOOODBOP
   MF49553      LIC-DB-Other Improved Heap usage
   MF49402      OSP-DB-MSGMCH3601 F/T:DbopOperationMisc/QQQOOODBOP
   MF49392      LIC-DB-MSGMCH3203 SQL Array and XML Agg
   MF49216      INCORROUT XML encoding option wrong results
   MF49157      LIC-DB Array fixes
   MF48987      OSP-DB-OTHER-PERFM SQL STATEMENTS PERFORM WORSE AT R610 OVER
   MF48987      LIC-DB-MSGMCH3203 0200/1722 MODULE HmDerivedHeap when LOBs
   MF48911      LIC-DB-PERFM Allow MQTs and EVIs with INCLUDE to coexist
   MF48904      LIC-PERFM SQL Field Procedures
   MF48792      LIC-DB DBMonitor 3012 record Global Variable
   MF48792      LIC-DB-MSGMCH3203 SQL Arrays
   MF48493      LIC-DB-MSGMCH3203 SQL Arrays
   MF48493      lic-db-unpred System crash
   MF48458      LIC-DB MSGMCH3203 X/1720 F/ASSERT X/000004 T/QQQOOODBOP MODU
   MF48423      LIC-DB VLOG contains many VLOGs with major code 0600, minor
   MF48356      LIC-DB MSGMCH3203 Queries with Arrays fail
   MF48165      LIC-DB-MSGMCH3203 Function check when running Grouping set q
   MF48117      OSP DB OTHER Incorrect output multiple XMLAgg order bys
   MF48029      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-RC1720-MSGMCH3203 SQL UPD
   MF47921      LIC-DB-MSGMCH3203 VLOG occurs when running a Grouping Sets q

Summary Information

System..............................i
Models..............................
Release.............................V7R1M0
Licensed Program...............5770999
APAR Fixed..........................View details for APAR MA45434
Superseded by:......................View fix details for PTF MF67719
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C6320710


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

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1","Product":{"code":"SG15V","label":"PTF Cover Letters - IBM i General"},"Component":"5770999","Edition":""},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1","Product":{"code":"SG16D","label":"PTF Cover Letters - IBM i 7.1"},"Component":"5770999","Edition":""}]

Document Information

Modified date:
10 December 2020