PTF

PTF#:SI40273 - i5/OS
Licensed Program:5761SS1
APAR Fixed:View details for APAR SE43905
View details for APAR SE44385
Release:6.1
Cumulative Level:C1102610
Superseded by:View fix details for PTF SI50120


Abstract

OSP-DB SQL routine attributes not always set after ALTER


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL
TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5761SS1  610  SI37452   00/00    0000
PRE  5761SS1  610  SI34558   00/00    0000
PRE  5761SS1  610  SI34557   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 ALTER FUNCTION or ALTER PROCEDURE, sometimes routine
attributes such as CLOSQLCSR are not correctly maintained.

CORRECTION FOR APAR SE43905 :
-----------------------------
The original attributes such as CLOSQLCSR from the routine will
now be saved after an alter of the original routine.

CIRCUMVENTION FOR APAR SE43905 :
--------------------------------
None.


DESCRIPTION OF PROBLEM FIXED FOR APAR SE44385 :
-----------------------------------------------
QSYS2 files deleted after installing PTF's. The following files
are deleted from system: SQLPRIKEYS SQLFORKEYS REF_CST2 REF_CST1
CHECK_CSTS TABLE_CSTS TABLE_CSTS SYSCST SYSCSTCOL SYSCHKCST
SYSCSTDEP SYSREFCST Job nnnnnn/QSYS/QDBSRVXR2 shows: msgCPF1124
Job 130465/QSYS/QDBSRVXR2 started msgCPC2191 Object SQLPRIKEYS
in SYSIBM type *FILE deleted F/QLIDLOBJ T/QSQXRLF2 X/0602 X/0012
msgCPC2191 Object SQLFORKEYS in SYSIBM type *FILE deleted
msgCPC2191 Object REF_CST2 in SYSIBM type *FILE deleted
msgCPC2191 Object REF_CST1 in SYSIBM type *FILE deleted
msgCPC2191 Object CHECK_CSTS in SYSIBM type *FILE deleted
msgCPC2191 Object TABLE_CSTS in SYSIBM type *FILE deleted
msgCPC2191 Object TABLE_CSTS in QSYS2 type *FILE deleted
msgCPC2191 Object SYSCST in QSYS2 type *FILE deleted msgCPC2191
Object SYSCSTCOL in QSYS2 type *FILE deleted msgCPC2191 Object
SYSCHKCST in QSYS2 type *FILE deleted msgCPC2191 Object
SYSCSTDEP in QSYS2 type *FILE deleted msgCPC2191 Object
SYSREFCST in QSYS2 type *FILE deleted F/QLIDLOBJ T/QSQXRLF2
X/0602 X/003E msgCPF3202 File SYSRTNDEP in library QSYS2 in use
F/QDBGRTFI T/QSQCCATV X/1503 X/0E8F msgCPF22BE Function not done
for user profile *PUBLIC F/QSYRVAUT T/QSQCCATV X/1503 X/0E8F
msgCPF2227 One or more errors occurred during processing of
command F/QSYRVAUT T/QSQCCATV X/0F0E X/0E8F msgCPF9999 Function
check for QSQCCATV at instruction X'0E8F' msgCPF2499 Message
identifier ?B - not valid F/QMHSNDPM T/QSQCCATV X/0D65 X/1034
msgCPA0701 CPF9999 received by QSQXRLF2 at . (C D I R) D
msgSQL7909 Routine SQLGETAUTH created, but cannot be
saved/restored msgSQL7909 Routine SQLGETVIEW created, but cannot
be saved/restored ... ...More routine created messages..
msgSQL0204 SYSCST in QSYS2 type *FILE not found. msgSQL0204
SQLPRIMARYKEYS in SYSIBM type *FILE not found. msgSQL0204
SQLPRIMARYKEYS in SYSIBM type *FILE not found. msgSQL0204 Object
SQLPRIKEYS in library SYSIBM type *FILE not found msgSQL0443
Trigger program or external routine detected an error ...
...Normal file change operations, etc...

CORRECTION FOR APAR SE44385 :
-----------------------------
Exit program processing for SQL catalog management has been
modified to detect when objects are 'in use' to avoid exit
program processing failures do to lock contention.

CIRCUMVENTION FOR APAR SE44385 :
--------------------------------
None.


Activation Instructions


None.


Special Instructions


None.

    Default Instructions

    THIS IS A DELAYED PTF TO BE APPLIED AT IPL TIME.



    Supersedes

    PTF/FIX NO(S).  APAR TITLE LINE
    --------------  ------------------------------------------------------------
       SI37521      IPL-LOOP AFTER IPLING TO APPLY THE JAVA AND HTTP GROUPS, THE
       SI37455      WDSC-RSE-EDT-INCORROUT SQL0104 SHOWN ON A VALID SQL STATEMEN
       SI37455      OSP-DB Syntax error when comma decimal point used
       SI37455      OSP-DB-MSGMCH1210 QSQRLEX when very long string
       SI34452      OSP-DB-PERFM VARY ON OF AN IASP TAKES LONGER THAN NECESSARY
       SI33554      OSP-DB-INCORROUT IGC literal in SQL statement is not being t
       SI31450      OSP-DB-OTHER-F/CBLABRANCH-T/QSQRLEX-MSGMCH1210 SQL INSERT ST
       SI31140      OSP-DB MQT with new function should not go TGTRLS(*PRV)
       SI30807      OSP-DB-MSGMCH3401QSQRXLTR when DLTLIB in IASP
       SI29773      OSP-DB Wrong data type for literal following BX literal
       SI29244      OSP-DB-OTHER-INCORROUT VIEW HAS INCORRECT FORMAT LEVEL ID
       SI29523      OSP-DB-MSGSQL0084 in isql when prompting unsupported stateme
       SI29523      SQL-MSGMCH1210 IN QSQHSTLX WHEN QSQCHKS IS CALLED

    Summary Information

    System..............................................i
    Models..............................................
    Release............................................V6R1M0
    Recompile........................................N
    Library................................................QSYS
    MRI Feature......................................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 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.