SI40273 - OSP-DB SQL routine attributes not always set after ALTER

PTF ( Program Temporary Fixes ) Cover letter


Order this fix

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
Cum Level...........................................   C1102610

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, 2011, 2012, 2013 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:

V6R1M0

Operating system(s):

OS/400

Reference #:

SI40273

Modified date:

2013-07-16

Translate my page

Machine Translation

Content navigation