PTF Cover Letter
PTF ( Program Temporary Fixes ) Cover letter
OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-RC6-MSGSQL0952 RUNNING SQL
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 MF63560 00/00 0000
CO 5770999 710 MF63232 00/00 0000
CO 5770999 710 MF61748 00/00 0000
CO 5770999 710 MF61277 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
-----------------------------------------------
Fix a propagate error from 7.3 to 7.1, missing brackets
CORRECTION FOR APAR MA46506 :
-----------------------------
Fix a prop error. Could cause a problem with OLAP request.
CIRCUMVENTION FOR APAR MA46506 :
--------------------------------
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
-------------- ------------------------------------------------------------
MF63843 LIC-DB-OTHER-PERFM SYNCHRONIZE MTI ACCESS IN AN TRACING OR E
MF63627 LIC-DB-OTHER Database temporary storage usage increases
MF63559 OSP-UNPRED QUERY ESTIMATED RUNTIME WITH XMLELEMENT FIELD SEL
MF63502 OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-RC6-MSGSQL0952 RUNNING SQL
MF56646 OSP-UNPRED TEMP STORAGE GROWTH AT R540
MF63231 LIC-DB-OTHER-PERFM COMPLEX QUERY IS BEING RE-OPTIMIZED UNEXP
MF63051 LIC-DB-OTHER-INCORROUT SQLRPGLE USING XML FAILS WITH SQLSTAT
MF62894 OSP-OTHER-PERFM WORKLOAD CAPPING IN ENVIRONMENTS THAT USE DB
MF62630 LIC-DB Internal Maintenance
MF62499 OSP-DB-OTHER-T/QQQOOODBOPX/4720-MSGMCH3203 A LEFT OUTER JOIN
MF62176 LIC-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 RUNNING A CREA
MF62024 LIC-DB-OTHER-T/QQQOOODBOP-MSGMCH3601 MSGMCH3601 T/QQQOOODBOP
MF61845 F/OPTIMIZER-UDFINCORROUTAFTERCLEARINGPLANCACHE UDF INCORRECT
MF61749 OSP-DB-OTHER OUTPUT QRO HASH OF QUERY INITIATING MTI IN TRAC
MF61656 LIC-DB-OTHER-INCORROUT Left outer join query returns wrong r
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 MA46506 |
Superseded by:...................... | View fix details for PTF MF67719 |
Recompile........................... | N |
Library............................. | QSYS |
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, 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.
Was this topic helpful?
Document Information
Modified date:
10 December 2020