SI55750 - OSP-DB-OTHER-F/QDBIOERRQO-T/QDBIOERRQO-RC1-MSGCPF503E ON INS

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
NONE



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

-----------------------------------------------
When we run

insert into somefile (blob) values
(QSYS2.GET_BLOB_FROM_FILE('someifsfile.xml'))

of a big xml file it fails with
MSGCPF503E F/QDBIOERRQO MOD/QDBIOERRQO PROC/SEND_MESSAGE
STMT/4120
T/same User-defined function error on member QSQPTABL.
RC1 The external program or service program returned SQLSTATE
58004.
MSGCPF503E F/QDBIOERRQO MOD/QDBIOERRQO PROC/SEND_MESSAGE
STMT/4120
T/QSQRUN3 MOD/QSQINS PROC/SQL_Insert STMT/11991
MSGSQL0443 F/QSQRUN3 MOD/QSQINS PROC/CLEANUP STMT/31561
The external name is QDBSSUDF2 in schema QSYS.

CORRECTION FOR APAR SE60920 :
-----------------------------
QSQFILEIO was fixed to avoid the problem.

CIRCUMVENTION FOR APAR SE60920 :
--------------------------------
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
--------------  ------------------------------------------------------------
   SI51093      OSP-DB Independent ASP and SRCPF support for selected SQL bu
   SI49999      OSP-DB OMNIFIND FAILS MSGCPF503E / MSGSQL0443 / MSGSQL0462 W
   SI38837      OSP-DB-OTHER XML PROCESSING

Summary Information

System i Support