SI78535 - OSP-DB SQL IS FAILING WITH MSGSQL0443 F/QSQRUN3 T/QSQRUN3

TYPE PROGRAM  RELEASE   NUMBER   MIN/MAX  OPTION
---- -------- --------- -------  -------  ------
CO   5770SS1  V7R3M0    SI70673   00/00    0000
CO   5770SS1  V7R3M0    SI67918   00/00    0000
CO   5770SS1  V7R3M0    SI65936   00/00    0000
CO   5770SS1  V7R3M0    SI65761   00/00    0000
CO   5770SS1  V7R3M0    SI65762   00/00    0000
CO   5770SS1  V7R3M0    SI65760   00/00    0000
CO   5770SS1  V7R3M0    SI60283   00/00    0000
DIST 5770SS1  V7R3M0    SI75032   00/00    0000
DIST 5770SS1  V7R3M0    SI75033   00/00    0000
DIST 5770SS1  V7R3M0    SI74526   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 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

-----------------------------------------------
SQL is failing with MSGSQL0443 F/QSQRUN3 T/QSQRUN3

CORRECTION FOR APAR SE77065 :
-----------------------------
The problem can occur with fenced UDFs when the secondary
threads are still active when data is returned to the primary
thread. The problem is fixed with this PTF.

CIRCUMVENTION FOR APAR SE77065 :
--------------------------------
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
--------------  ------------------------------------------------------------
   SI78326      OSP-DB-OTHER-F/QSQRUN2MOD/QSQFETCH-MSGSQL0443 WHEN SQL TABLE
   SI77232      OSP-DB-MSGMCH0601-F/QSQUDFDG UDF FAILURE SETTING SQL0171 MES
   SI76225      OSP-DB-QSQPREP-PPCMPSA-MSGMCH3601 with long running job
   SI76193      OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-MSGSQL0462 MSGSQL0462 F/QSQ
   SI76154      OSP-DB-OTHER-THREADS-WAIT QSQTHDTM PREP_STMT_AREA_CLEANUP
   SI75944      OSP-DB-MSGMCH3601-/FQSQCKRDB IASP STORAGE RAN OUT CAUSING LC
   SI75941      OSP-DB QSQRLSPC shows CPU spikes
   SI75750      OSP-DB-QQQOOOUPCL -MSGMCH3601 when running fenced UDFs
   SI75604      OSP-DB-OTHER-T/QSQSFCRT-MSGMCH3203-MSGMCH0601 UDT ARRAY HEAP
   SI75521      OSP-DB-QSQCLSCR error SQLCODE lost
   SI75364      OSP-DB-OTHER-F/QQQSRVE1-MSGMCH1210 MOD/QQQOOOSETS PROC/SETUP
   SI75034      OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-MSGSQL0501 AFTER PTF INSTAL
   SI74811      OSP-DB-OTHER-F/QMHSNDPM-T/QSQRUN3-MSGCPF2499 DBMON FAILS TO
   SI74523      OSP-DB-OTHER-F/QSQROUTS-T/QSQROUTS-RC480-MSGSQL0904 MSGSQL09
   SI74266      OSP-DB-MSGSQL0423 with pipelined functions
   SI74226      OSP-DB RESTORING A FILE THAT A CONTAINS A UDT TO A USER ASP
   SI74194      OSP-DB-OTHER-F/QMHSNDPM-T/QSQRUN3-MSGCPF2499 DBMON FAILS TO
   SI73896      OSP-DB-MSGSQL0423 with pipelined functions
   SI73791      OSP-F/RLSLOCKSPACE-T/QSQBAS2-MSGMCH5804 MSGMCH5804 F/RLSLOCK
   SI73773      OSP-DB-MSGSQL0480 procedure with 3 part name
   SI73549      OSP-DB-MSGSQL0512 after calling 3 part name procedure
   SI73536      OSP-DB-OTHER-F/F/QSQSBAS2MOD/QSQSFCLSPROC/SQCLOSEIRT- T/T/QS
   SI73434      OSP-DB-QSQUDFDG-MSGSQL0443 Incorrect message replacement tex
   SI73225      OSP-DB-OTHER-MSGSQL0429 LOBLOCATOR ORPHANED UDTF
   SI73019      OSP-DB-OTHER-F/F/#HMALCMIX/000934-T/QSQSBAS2X/2805-MSGMCH690
   SI72354      OSP-Internal Maintenance
   SI72316      OSP-DB-OTHER-MSGSQL0429 JDBC JTOPEN ORPHANED LOB LOCATOR
   SI72076      OSP-DB-QSQTHDTM thread is hung
   SI71292      OSP-DB-QSQPREP-MSGMCH3402 on prepare of query
   SI70674      OSP-DB Expression in call causes temp storage growth
   SI69615      OSP-DB-OTHER-MSGCPI0999 FRAGMENTATION CAUSED BY QSQBAS (CAN
   SI69397      OSP-DB-SQL0423 CLOB in pipeline function
   SI69001      OSP-DB restore special registers after UDF
   SI68677      OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-MSGSQ20226 A MSGSQ20226 MAY
   SI68595      OSP-DB-OTHER-MSGSQL0204 USING PERIOD SEPARATOR FOR OBJECT QU
   SI68536      OSP-DB Temp Storage growth with CLOB Variables and Parameter
   SI68522      OSP-DB-OTHER-PERFM HIGH CPU MAY BE NOTICED WITH SOME XML FUN
   SI68079      OSP-DB-OTHER-UNPRED QSQSVCDMP SPOOLED FILES NOT SENT TO QEZD
   SI68119      SP/QSQSBAS2-MSGMCH0601-MOD/QSQUDFDG SHOWING INDEX VIA ACS WH
   SI68087      OSP-DB-MSGSQL0423 FETCHING CLOB DATA
   SI67919      OSP-MSGSQL0901-D/TQSQCRTT-PAR SQL0901 WHEN PERFORMING AN CRE
   SI67724      OSP-DB INFRASTRUCTURE
   SI67518      OSP-DB-OTHER-F/QSQSBAS2-T/QSQSBAS2-MSGMCH3601 SELECT FROM IN
   SI67207      OSP-DB-MSGMCH1001.
   SI66893      OSP-DB Temp Storage growth with CLOBs in UDTF
   SI66580      OSP-DB Temp Storage growth with CLOBs in UDTF
   SI66457      OSP-DB-MSGMCH3203-RC1720 F/DBOPNODE-MSGMCH3203-RC1720
   SI66233      OSP-DB-QSQINS-MSGSQL0723 on trigger program using 3 part nam
   SI65937      OSP-DB-OTHER-UNPRED DUPLICATE STATEMENT NAMES IN SQLPKG
   SI65930      OSP-DB-OTHER-F/QSQSBAS-T/QSQSBAS-MSGMCH3601 SQL_GETQDT_FOR_U
   SI65763      OSP-DB INTERNAL MAINTENANCE
   SI65576      OSP-DB Internal Maintenance
   SI65361      OSP-DB Internal Maintenance
   SI65268      OSP-DB Internal Maintenance
   SI64611      OSP-DB-MSGMCH3601-T/QRWTQRY with 3 part name SQL
   SI64151      OSP-UNPRED ENDDBMON OF DBMON WITH PARM HOSTVAR(*CONDENSED) L
   SI64007      OSP-DB 3-part name replacement for heterogenous, use *SQL na
   SI63625      OSP-DB Improve Index Advisor storage management
   SI63437      OSP-DB INTERNAL MAINTENANCE
   SI63180      OSP-DB-MSGMCH3601 QZDASOINIT Job Termination Failing with MC
   SI63170      OSP-DB Internal Maintenance
   SI63062      OSP-DB-OTHER-T/QSQRUN3-MSGMCH3601 MODULE QSQOPEN PROCEDURE D
   SI62284      OSP-DB INTERNAL MAINTAINENCE
   SI62127      OSP ALTER TABLE STATEMENT NOT LOGGED BY DBMON
   SI62118      OSP-DB-OTHER-INCORROUT DBMON WORK WITH SQL STATEMENT AND VAR
   SI61620      OSP-DB-MSGMCH3402 f/QSQUDFPO t/QSQUDFPO running query with s
   SI60932      OSP-DB INTERNAL MAINTENANCE
   SI60902      OSP-DB INFRASTRUCTURE
   SI60480      OSP-DB-PERFM Slow performance when using SQL packages in mul
   SI60376      OSP - DB XML Decomp Attempt on Incomplete Schema Returns SQL
   SI60307      OSP-DB-MSGMCH3402-T/QSQCLSCR close remote cursor
   SI60284      OSP-DB Internal Maintenance
   SI59959      OSP-DB Internal Database Maintenance
   SI59825      OSP-DB-INCORROUT INLINED SQL FUNCTION
   SI59605      OSP-DB INTERNAL MAINTENANCE
   SI59558      OSP-DB Internal Maintenance
   SI59488      OSP-DB Internal Maintenance
   SI59488      OSP-DB-OTHER-MSGSQL0443 A MSGSQL0443 MAY OCCUR ON SERVER IBM
   SI59482      OSP-DB INFRASTRUCTURE
   SI59397      OSP-DB INTERNAL MAINTENANCE
   SI59394      OSP-DB REMOTE INSERT WITH AN ALIAS THAT HAS A 3 PART NAME FA
   SI59335      OSP-DB INTERNAL MAINTENANCE
   SI59220      OSP-DB Internal Maintenance
   SI59146      OSP-DB Create table LIKE with 3-part name issues misleading
   SI59072      OSP-DB INTERNAL MAINTENANCE
   SI59049      OSP-DB Internal Maintenance
   SI58994      OSP-DB-SQL Support optionally clearing SQLSTATE on truncatio
   SI58983      OSP-DB-OTHER-F/QSQRUN3-MSGSQL0517
   SI58954      OSP-DB INTERNAL MAINTENANCE
   SI58763      OSP-DB-MSGMCH3402 T/QSQPREP in QDBSxxxxxx system job
   SI58530      OSP-DB INTERNAL MAINTENANCE
   SI58530      OSP-DB-OTHER-UNPRED SERVICEABILITY ENHANCEMENTS

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

IBM i Support