SI64545 - OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0514 SAP SQL STMT NOT

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
CO   5770SS1  710  SI59620   00/00    0000
CO   5770SS1  710  SI39060   00/00    0000
CO   5770SS1  710  SI39063   00/00    0000
CO   5770SS1  710  SI39064   00/00    0000
CO   5770SS1  710  SI39061   00/00    0000
DIST 5770SS1  710  SI44238   00/00    0000
DIST 5770SS1  710  SI44239   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

-----------------------------------------------
After SQL packages have been created, a SQL0514 will be thrown
after a while. A SQL statement name is not found in the SQL
package, even we find it using PRTSQLINF. This will happen, when
SAP uses long statement names and the SQL package grow to a
certain size. A switch is done from doing a serial search to
perform a search using a hash table. The statement name will not
be found in the hash table.

CORRECTION FOR APAR SE67107 :
-----------------------------
Statement names longer than 18 characters were not hashed
correctly into the sql package, resulting in erroneous
MSGSQL0514. This has been fixed.

CIRCUMVENTION FOR APAR SE67107 :
--------------------------------
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
--------------  ------------------------------------------------------------
   SI59802      OSP-DB CHANGE QSQPRCED TO REDUCE UNIQUE TOD REQUESTS
   SI59621      OSP-DB-OTHER ADD PACKAGE INFORMATION TO SYSLIMITS CATALOG
   SI58348      OSP-DB-OTHER-SAP400-F/#CFOCHKR-T/QSQRUN1-MSGMCH3402 MSGMCH58
   SI56139      OSP-DB Extend QSQPRCED() to include some QAQQINI options
   SI55335      OSP-DB QSQPRCED() creates package using a larger capacity *S
   SI55335      OSP-DB QSQPRCED() creates package using a larger capacity *S
   SI55335      OSP-DB QSQPRCED() creates package using a larger capacity *S
   SI55329      OSP-DB-OTHER-T/QSQXPGM-MSGCPF2151 DURRING CREATE PACKAGE
   SI54030      OSP-DB Support HOSTVAR parameter on STRDBMON command - Phase
   SI51398      OSP-DB MCH1210 F/T: QSQSTATS/QSQSTATS
   SI49380      F/QSYDSAUT-MSGCPF2208 SQL PACKAGE WITH QUOTED NORMAL NAME CP
   SI48601      OSP-DB ADD client special register support to QSQPRCED()
   SI48095      OSP-DB-OTHER-F/QSQPRCED-MSGMCH3601 A MSGMCH3601 F/QSQPRCED M
   SI46579      OSP-DB-OTHER-T/QSQSFCRT-MSGCPF5183
   SI44237      OSP-DB-OTHER-MSGCPF32A5 A MSGCPF32A5 CCSID 13488 FOR FIELD *
   SI42872      OSP-DB-UNPRED Internal DRDA Maintenance
   SI42503      OSP-DB-INCORROUT ENABLE AUTOCOMMIT WITH COMMIT LEVEL *NONE I
   SI42228      OSP-DB-INCORROUT-MSGSQL0104 on create or alter of DDL
   SI40668      OSP-DB-UNPRED Three part alias statement rewrite
   SI40453      OSP-DB-OTHER-SAP400-F/QSQRUN2-T/QSQRUN2-MSGSQL0501 SAP USING
   SI38967      OSP-DB-OTHER-SAP400-MSGSQL0516 SAP FAILS WITH MSGSQL0516 DUR
   SI50655      OSP-DB-F/QSQCHGPK-MSGSQL0030 Missing host var in QSQCHGPK
   SI44129      OSP-DB-QSQPREP-MSGMCH3402 when using a restored package
   SI42783      OSP-DB-OTHER-T/QSQRUN3-MSGMCH1209
   SI39838      OSP-DB-OTHER-SAP400-MSGSQL0551 WHEN CREATING A PACKAGE
   SI38432      OSP-DB-MSGMCH3601-T/QSQCHGPK with sqludts
   SI37969      OSP-DB-OTHER-SAP400-MSGSQL0551 WHEN CREATING A PACKAGE
   SI57924      OSP-DB CPF9803 DISPLAY ADDITIONAL GARBAGE OR BLANKS FOR OBJE
   SI54870      OSP-DB-MSGCPF9803-F/QSQDLTPK FIX FIELD DATA ON MSG FOR DLTSQ
   SI49623      OSP-DB-OTHER-T/QSQDLTPK-MSGMCH3402 MSGMCH3402 T/QSQDLTPK WHE
   SI47068      OSP-DB SCPF LOOPING WITH: MCH3401 F/MNRESOLVECONTEXT T/QSQRE
   SI42093      OSP-DB-OTHER-MSGSQL0818 MSGSQL0818 FOR PACKAGES AFTER RESTOR
   SI41924      OSP-DB-OTHER-F/SETSPACEPTRFROMPTR-T/QSQDLTPK-MSGMCH3403 DLTS
   SI41924      OSP-DB-MSGMCH3601-F/QSQDLTPK-T/QSQDLTPK CPC2191 BUT PACKAGE
   SI39069      OSP-DB Internal Maintenance
   SI37965      OSP-DB-OTHER-MSGSQL0805 SQLPKG IS NOT FOUND FORCING NEW BIND
   SI36445      OSP-DB-UNPRED Suppress package timeout

Summary Information

System i Support