SI18707 - OSP-DB-MSGCPD438C RC3 when using intersect with UDFs

PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-MSGCPD438C RC3 when using intersect with UDFs


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5722999  530  MF33394   00/00    0000
PRE  5722999  530  MF33231   00/00    0000
CO   5722SS1  530  SI18674   00/00    0000
CO   5722SS1  530  SI18675   00/00    0000
CO   5722SS1  530  SI18667   00/00    0000
CO   5722SS1  530  SI18183   00/00    0000
CO   5722SS1  530  SI18184   00/00    0000
CO   5722SS1  530  SI16115   00/00    0000
CO   5722SS1  530  SI16050   00/00    0000
CO   5722SS1  530  SI15955   00/00    0000
DIST 5722SS1  530  SI16084   00/00    0000
DIST 5722SS1  530  SI16927   00/00    0000
DIST 5722999  530  MF34502   00/00    0000
DIST 5722999  530  MF34066   00/00    0000
DIST 5722SS1  530  SI13380   00/00    0000
DIST 5722SS1  530  SI13388   00/00    0000
DIST 5722SS1  530  SI14106   00/00    0000
DIST 5722SS1  530  SI13930   00/00    0000
DIST 5722999  530  MF33601   00/00    0000
DIST 5722999  530  MF33763   00/00    0000
DIST 5722999  530  MF33617   00/00    0000
DIST 5722999  530  MF33618   00/00    0000
DIST 5722999  530  MF33637   00/00    0000
DIST 5722999  530  MF33743   00/00    0000
DIST 5722999  530  MF33764   00/00    0000
DIST 5722999  530  MF32574   00/00    0000
DIST 5722SS1  530  SE17013   00/00    0000 (SEE MRI PTF/FIX LIST BELOW)
DIST 5722SS1  530  SE17014   00/00    0000 (SEE MRI PTF/FIX LIST BELOW)

MRI PTF/FIX LIST
----------------
   APAR SE17013 AFFECTS THESE LANGUAGES.  IF YOU HAVE ANY OF THESE
   LANGUAGES INSTALLED, INSTALL THE DISTRIBUTION REQUISITE MRI PTF THAT
   CORRESPONDS TO THE LANGUAGE(S) INSTALLED ON YOUR SYSTEM.
   -----------------------------------------------------------------
   :  FEATURE                                   LICENSED  PTF/FIX  :
   :  CODE     LANGUAGE                         PROGRAM   NUMBER   :
   :  -------  -------------------------------  --------  -------  :
   :  2924     ENGLISH UPPER/LOWER CASE SBCS    5722SS1   SI15319  :
   :  2902     ESTONIAN                         5722SS1   SI15731  :
   :  2905     VIETNAMESE                       5722SS1   SI15734  :
   :  2906     LAO                              5722SS1   SI15735  :
   :  2909     BELGIAN ENGLISH                  5722SS1   SI15737  :
   :  2911     SLOVENIAN                        5722SS1   SI15793  :
   :  2912     CROATIAN                         5722SS1   SI15789  :
   :  2913     MACEDONIAN                       5722SS1   SI15738  :
   :  2923     DUTCH                            5722SS1   SI15804  :
   :  2928     FRENCH                           5722SS1   SI15803  :
   :  2929     GERMAN                           5722SS1   SI15788  :
   :  2933     NORWEGIAN - BOKMAL               5722SS1   SI15805  :
   :  2937     SWEDISH                          5722SS1   SI15873  :
   :  2938     ENGLISH UPPER CASE DBCS          5722SS1   SI15740  :
   :  2939     SWISS GERMAN                     5722SS1   SI15794  :
   :  2940     SWISS FRENCH                     5722SS1   SI15810  :
   :  2957     GREEK                            5722SS1   SI15871  :
   :  2961     HEBREW                           5722SS1   SI15872  :
   :  2963     BELGIUM DUTCH                    5722SS1   SI15806  :
   :  2966     BELGIUM FRENCH                   5722SS1   SI15807  :
   :  2974     BULGARIAN                        5722SS1   SI15742  :
   :  2976     HUNGARIAN                        5722SS1   SI15790  :
   :  2978     POLISH LANGUAGE                  5722SS1   SI15869  :
   :  2979     RUSSIAN                          5722SS1   SI15792  :
   :  2980     BRAZILIAN PORTUGUESE             5722SS1   SI15864  :
   :  2981     CANADIAN FRENCH                  5722SS1   SI15809  :
   :  2984     ENGLISH UPPER/LOWER CASE DBCS    5722SS1   SI15744  :
   :  2986     KOREAN                           5722SS1   SI15868  :
   :  2989     SIMPLIFIED CHINESE               5722SS1   SI15866  :
   :  2992     ROMANIAN                         5722SS1   SI15791  :
   :  2994     SLOVAKIAN                        5722SS1   SI15870  :
   :  2998     FARSI                            5722SS1   SI15747  :
   -----------------------------------------------------------------
   APAR SE17014 AFFECTS THESE LANGUAGES.  IF YOU HAVE ANY OF THESE
   LANGUAGES INSTALLED, INSTALL THE DISTRIBUTION REQUISITE MRI PTF THAT
   CORRESPONDS TO THE LANGUAGE(S) INSTALLED ON YOUR SYSTEM.
   -----------------------------------------------------------------
   :  FEATURE                                   LICENSED  PTF/FIX  :
   :  CODE     LANGUAGE                         PROGRAM   NUMBER   :
   :  -------  -------------------------------  --------  -------  :
   :  2903     LITHUANIAN                       5722SS1   SI15732  :
   :  2904     LATVIAN                          5722SS1   SI15733  :
   :  2914     SERBIAN                          5722SS1   SI15739  :
   :  2931     SPANISH                          5722SS1   SI15749  :
   :  2950     ENGLISH UPPER CASE               5722SS1   SI15741  :
   :  2975     CZECH                            5722SS1   SI15743  :
   :  2995     ALBANIAN                         5722SS1   SI15746  :
   -----------------------------------------------------------------




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

DESCRIPTION OF PROBLEM FIXED FOR APAR SE20804 :
-----------------------------------------------
   The below query returns an error:
   SELECT CHARUDF(CHAR10)
    FROM   QQEIP01
    INTERSECT
    SELECT CHARUDF(CHAR10)
    FROM   QQEIP02

   Function not supported. Reason code 3.
   DB2 Multisystem query error.

CORRECTION FOR APAR SE20804 :
-----------------------------
   A problem occurred when using a set operator and UDFs.  This
   problem has been corrected.

CIRCUMVENTION FOR APAR SE20804 :
--------------------------------
   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
--------------  ------------------------------------------------------------
   SI18668      OSP-DB Database monitor seems like it is running when it is
   SI18577      OSP-DB Recompile QQQDTQRO
   SI18185      SQL-RUN Add reason code for dispatcher
   SI17560      OSP-DB Lock not retained on query of SQL view
   SI17164      OSP-DB Enable Optimizer awareness of Materialized Query
   SI17377      OSP-DB Visual Explain Maintenance
   SI17377      OSP-DB Support INI Option OPTIMIZE_STATISTIC_LIMITATION
   SI17377      OSP-DB-Visual Explain Display Attribute Problem
   SI16998      OSP-DB-SAP400-F/CBLABRANCH-MSGMCH1210-T/QDMCOPEN MSGMCH1210
   SI16199      OSP-DBOP VLOG BADD getDbstMdExpr__14DbopExprColumnCFv
   SI16113      OSP Internal maintenance for SQL
   SI16049      OSP-DB Infrastructure changes for future enhancements
   SI15954      OSP-DB STRDBMON monitor only the specified tables
   SI15818      OSP-DB Infrastructure changes for future enhancements
   SI15650      OSP SQL Visual Explain Attributes Translated
   SI15753      OSP-DBOP-LOOP when writing error trace
   SI15458      OSP-DB Infrastructure changes for future enhancements
   SI15361      OSP-DB API QDMLOPNF REPORTS PHYSICAL FILES AS TYPE LOGICAL.
   SI14872      OSP-DB-INCORROUT FETCH N ROWS IN Derived table
   SI14872      OSP-DB-MSGMCH3601-F/QDBSIGEX   Update query with mapping
   SI14791      OSP-DB-PERFM  Improve performance of COUNT function
   SI14564      OSP-DB PERFM HOST SERVER IS NOT ALLOWING BLOCKING
   SI14559      OSP-DBOP IGC OPEN HEAP LEAK
   SI14449      OSP-DB Visual Explain Maintenance
   SI14278      SQL-RUN-INCORROUT Handle Prepare Time Optimization
   SI13706      OSP-DB-MSGMCH3203
   SI13477      OSP-DB Visual Explain Maintenance
   SI12963      OSP-DB Visual Explain
   SI12749      OSP-DBOP CPI4330 reason code and filename set wrong
   SI12727      OSP USING THE QAQQINI OPTION DATABASE_MONITOR_THRESHOLD STIL
   SI12669      OSP-DB-MSGMCH3601 QQQDTQRO UDF Derived table

Summary Information

System..............................................   iSeries
Models..............................................  
Release.............................................   V5R3M0  
Recompile...........................................   N    
Library.............................................   QSYS  
MRI Feature ........................................   NONE  
Cum Level...........................................   C6045530

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

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

i family

Software version:

V5R3M0

Operating system(s):

OS/400

Reference #:

SI18707

Modified date:

2010-06-01

Translate my page

Machine Translation

Content navigation