PTF

PTF#:SI49466 - IBM i
Licensed Program:5770SS1
APAR Fixed:View details for APAR SE54924
Release:7.1
Cumulative Level:C3298710
Superseded by:View fix details for PTF SI62812


Abstract

OSP-DB SYSROUTINE locked by QDBSRVXR2 after PTFs are applied


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL
TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770999  710  MF49948   00/00    0000
PRE  5770SS1  710  SI38332   00/00    0000
PRE  5770SS1  710  SI45856   00/00    0000
CO   5770SS1  710  SI49112   00/00    0000
CO   5770SS1  710  SI49105   00/00    0000
CO   5770SS1  710  SI49106   00/00    0000
CO   5770SS1  710  SI49107   00/00    0000
CO   5770SS1  710  SI49110   00/00    0000
CO   5770SS1  710  SI49008   00/00    0000
CO   5770SS1  710  SI48885   00/00    0000
CO   5770SS1  710  SI48820   00/00    0000
CO   5770SS1  710  SI48080   00/00    0000
CO   5770SS1  710  SI48143   00/00    0000
CO   5770SS1  710  SI48144   00/00    0000
CO   5770SS1  710  SI48145   00/00    0000
CO   5770SS1  710  SI48018   00/00    0000
CO   5770SS1  710  SI42929   00/00    0000
CO   5770SS1  710  SI48191   00/00    0000
CO   5770SS1  710  SI48195   00/00    0000
CO   5770SS1  710  SI48196   00/00    0000
CO   5770SS1  710  SI48198   00/00    0000
CO   5770SS1  710  SI48197   00/00    0000
CO   5770SS1  710  SI47868   00/00    0000
CO   5770SS1  710  SI47550   00/00    0000
CO   5770SS1  710  SI47141   00/00    0000
CO   5770SS1  710  SI47117   00/00    0000
CO   5770SS1  710  SI46685   00/00    0000
CO   5770SS1  710  SI46365   00/00    0000
CO   5770SS1  710  SI44208   00/00    0000
CO   5770SS1  710  SI41416   00/00    0000
CO   5770SS1  710  SI39903   00/00    0000
CO   5770SS1  710  SI39069   00/00    0000
DIST 5770SS1  710  SI47687   NONE     0013
DIST 5770SS1  710  SI40707   00/00    0000
DIST 5770SS1  710  SI40754   00/00    0000
DIST 5770SS1  710  SI43720   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

-----------------------------------------------
A CREATE OR REPLACE PROCEDURE statement that specifies a
specific name may leave open records for file QSYS2/SYSROUTINE
after the statement completes.

CORRECTION FOR APAR SE54924 :
-----------------------------
QSQPROC has been fixed to close SYSROUTINE when processing is
complete.

CIRCUMVENTION FOR APAR SE54924 :
--------------------------------
None.


Activation Instructions


To properly enable this PTF for prestarted server jobs,
you will need to stop and restart the SQL server jobs,
the Directory Services server jobs, the DRDA TCPIP server
jobs, and the host server jobs.  Otherwise,
the prestarted server jobs may continue to use older versions
of programs and unexpected results may occur.Applying this
PTF as delayed would achieve the same results.

To stop and restart the SQL server jobs, run the following:

ENDPJ SBS(QSYSWRK) PGM(QSQSRVR) OPTION(*IMMED)
STRPJ SBS(QSYSWRK) PGM(QSQSRVR)

To stop and restart the QRWTSRVR prestart jobs, run the following:

ENDPJ SBS(QUSRWRK) PGM(QRWTSRVR) OPTION(*IMMED)
STRPJ SBS(QUSRWRK) PGM(QRWTSRVR)

To stop and restart the DRDA TCPIP server jobs, run the following:

ENDTCPSVR SERVER(*DDM)
STRTCPSVR SERVER(*DDM)

To stop and restart the Directory Services server job,
run the following:

ENDTCPSVR SERVER(*DIRSRV)
STRTCPSVR SERVER(*DIRSRV)

To stop and restart the host server jobs, the following directions
must be followed.

The database server prestart jobs (QZDAINIT, QZDASOINIT, and
QZDASSINIT) by default are shipped to run in subsystem QSERVER
(QZDAINIT) and QUSRWRK (QZDASOINIT and QZDASSINIT).  However, systems
can be customized to allow the database server prestart jobs to run
in other subsystems.

SYSTEMS WITH DEFAULT CONFIGURATION (database server prestart jobs run
ONLY in the QSERVER and QUSRWRK subsystems).
---------------------------------------------------------------------

1) To ensure that the database server prestart jobs are ended,
issue the requests:

QSYS/ENDPJ SBS(QSERVER) PGM(QSYS/QZDAINIT) OPTION(*IMMED)
and
QSYS/ENDPJ SBS(QUSRWRK) PGM(QSYS/QZDASOINIT) OPTION(*IMMED)
and
QSYS/ENDPJ SBS(QUSRWRK) PGM(QSYS/QZDASSINIT) OPTION(*IMMED)
and if a non default prestart job configuration exists
QSYS/STRPJ SBS("subsystem-name") PGM(QSYS/QZDAINIT)

If the above commands fail with CPF0922, nothing more needs
to be done (the prestarted jobs are already inactive).

2) To re-enable the function after the PTF is applied, issue the
requests:

QSYS/STRPJ SBS(QSERVER) PGM(QSYS/QZDAINIT)
and
QSYS/STRPJ SBS(QUSRWRK) PGM(QSYS/QZDASOINIT)
and
QSYS/STRPJ SBS(QUSRWRK) PGM(QSYS/QZDASSINIT)
and if a non default prestart job configuration exists
QSYS/STRPJ SBS("subsystem-name") PGM(QSYS/QZDASSINIT)

If the above commands fail with CPF0921, nothing more needs
to be done (the prestarted jobs are already active).



Special Instructions


None.

    Default Instructions

    THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.



    Supersedes

    PTF/FIX NO(S).  APAR TITLE LINE
    --------------  ------------------------------------------------------------
       SI49389      OSP-DB-OTHER-F/QSQPROC-T/QSQPROC-MSGMCH1210 OSP-DB-OTHER-F/Q
       SI49381      OSP-DB-OTHER-MSGSQL0204 QSQGNDDL API FAILING WITH MSGSQL0204
       SI49356      OSP-DB Internal Maintenance
       SI49319      OSP-DB Internal Maintenance
       SI49289      OSP-F/QSQRUN3-T/QSQRUN3-RC3-MSGSQL7008 MQT FAILS TO REFRESH
       SI49289      OSP-F/EXSNDPM-T/QSQRUN4-MSGMCH1401 MQT REFRESH FAILS WITH MS
       SI49098      OSP-DB-OTHER-UNPRED STORED PROCEDURE REGISTERED INCORRECTLY
       SI49111      OSP-DB Add option to specify system name for create table, v
       SI49104      OSP-DB-OTHER-MSGSQL0104 WHEN TRYING TO CREATE A TRIGGER USIN
       SI49055      OSP-DB Internal Maintenance
       SI49035      OSP-DB QSQGNDDL API GENERATING A 'N' INSTEAD OF UNDERSCORE.
       SI49007      OSP-DB-OTHER-UNPRED MERGE SQL STATEMENTS SHOWING UP AS USER
       SI49005      OSP-DB-OTHER-F/QSQPROCR-T/QSRRSTPS-MSGSQL9015 RESTORING SQL
       SI48961      OSP-DB-QSQQDTNV-MSGMCH0601 when dropping schema
       SI48960      MSGMCH2601 Lock enforcement rules broken when trying to acce
       SI48909      OSP-DB Internal Maintenance
       SI48896      OSP-DB Internal maintenance
       SI48847      OSP-DB INTERNAL MAINTENANCE
       SI48115      OSP-DB-OTHER-INCORROUT CREATE_WRAPPED fails in RUNSQLSTM
       SI47694      OSP-DB-OTHER-MSGSQL0206 WRAPPING GLOBAL VARIABLE
       SI46169      OSP-DB Internal Maintenance
       SI45872      OSP-DB Internal Maintenance
       SI45672      OSP-DB-MSGSQL0601 CREATE REPLACE TRIGGER WITH UNQUALIFIED TR
       SI44424      OSP-DB-INCORROUT SQL DETAILS FOR JOB DOES NOT REFRESH
       SI42928      OSP-DB SPECIFY PROGRAM NAME ON CREATE TRIGGER
       SI38924      OSP-DB-MSGMCH1210 Creating SQL trigger
       SI39240      OSP-DB CREATE OR REPLACE TRIGGER RESULTS IN WRONG STATEMENT
       SI38573      OSP-DB Incorrect Owner of Triggers Created for OmniFind Text
       SI37646      OSP-DB Internal Maintenance
       SI37169      OSP-DB INTERNAL MAINTENANCE
       SI48597      OSP-DB-OTHER-F/QSQPROC-T/QSQPROC-MSGCPF9898 AFTER APPLY OF S
       SI48570      OSP-DB-OTHER-UNPRED SERVICEABILITY ENHANCEMENT
       SI48503      OSP-DB INTERNAL MAINTENANCE
       SI48419      OSP-DB EXTERNAL_NAME in SYSROUTINE not correct
       SI48273      OSP-DB Improved database catalog management for SQL routines
       SI48273      OSP-DB INTERNAL MAINTENANCE
       SI48273      OSP-DB-QSQPROC MSGSQL0913 when dropping routine
       SI48194      OSP-DB-OTHER-RC480-MSGSQL0904
       SI48127      OSP-DB INTERNAL MAINTENANCE
       SI48104      OSP-DB Improved database catalog management for SQL routines
       SI48020      OSP-DB INTERNAL MAINTENANCE
       SI47865      OSP-DB incorrect data with new save point level
       SI47841      OSP-DB EXTERNAL_NAME in SYSROUTINE has extra trailing blank
       SI47551      OSP-DB-MSGCPF9898 SQL CREATE PROCEDURE statement in RUNSQL
       SI47324      OSP-DB Add a listing option to the RUNSQLSTM command
       SI47268      OSP-DB-OTHER-UNPRED A QUERY OF SYSFUNCS MAY HAVE AN EXTRA SP
       SI47143      OSP-DB INTERNAL MAINTENANCE
       SI47120      OSP-DB Internal Maintainence
       SI46783      OSP-DB-OTHER-UNPRED A COMPLETE SYSTEM RESTORE WITH RESTORE O
       SI46746      OSP-DB-OTHER-T/QSQRUN4-MSGMCH1001 MODULE QSQMERGE
       SI46736      OSP-DB ALLOW GLOBAL VARIABLES TO BE CHANGED WITHIN TRIGGERS
       SI46684      OSP-DB-OTHER-INCORROUT PROCEDURES WITH OUTPUT LOB LOCATORS T
       SI46607      OSP-DB INTERNAL MAINTENANCE
       SI46486      OSP-DB-OTHER-F/QSQBAS\SQGETSPACE-MSGMCH3601 OPEN OF VIEW OVE
       SI46435      OSP-DB-OTHER-MSGSQL0204 RUNNING MERGE STATEMENT SIMULTANEOUS
       SI46367      F/QSQXCUTE-MSGSQL0104-RIDS/CLEANUP SETTING AN SQL VARIABLE T
       SI46329      OSP-DB-OTHER-F/QSQROUTS-T/QSQROUTS-MSGSQL0804 SQL0804 MESSAG
       SI46196      OSP-DB-OTHER-MSGMCH5401-T/QSQRUN1 IN LONG RUNNING JOB
       SI46120      OSP-DB Internal Maintenance
       SI46120      OSP-DB INTERNAL MAINTENANCE
       SI46120      OSP-DB-MSGSQL7909 REASON CODE 1 SCHEMA NAME TRUNCATED IN MES
       SI45899      SQL-RUN-INCORROUT GENERATE SQL ON A PROCEDURES THAT CONTAINS
       SI45837      OSP-DB SQL CALL CACHE AND UNQUALIFIED PROCEDURE CALLS
       SI45805      OSP-F/QDBSIGEX-T/QSQPROCR-MSGCPF5035 MSGCPF5035 F/QDBSIGEX T
       SI45264      OSP-DB Storage Leak using procedure with expressions
       SI45190      OSP-DB-OTHER DRDA HETEROGENEOUS CALL WITH ARRAY NOT WORKING
       SI45186      OSP-DB-MSG MCH6801 QSQCALLSP calling procedure
       SI45058      OSP-DB-OTHER-UNPRED Incorrect result set returned with neste
       SI44883      OSP-DB-OTHER-F/QSQRUN4-MSGMCH0601 A MSGMCH0601 F/QSQRUN4 FMO
       SI44786      OSP-DB-OTHER-F/QRWTBAS-T/QRWTBAS-MSGMCH3601 SOME STORED PROC
       SI44544      OSP-DB-OTHER XML Support
       SI44423      OSP-DB-INCORROUT SQL DETAILS FOR JOB DOES NOT REFRESH
       SI44393      OSP-DB-MSGSQL0788 MERGE into logical file based on multiple
       SI44210      OSP-DB SLOW RENAME LIBRARY PERFORMANCE
       SI44193      OSP-DB-OTHER-MSGSQL0312 MERGE SQL statement
       SI44125      OSP-DB-OTHER-T/QRWSQRY-MSGMCH3601
       SI43805      OSP-DB Sourced UDFs based on NOT FENCED UDFs are FENCED
       SI43719      OSP-MSGSQL0913 MERGE INTO STATEMENT FAILS WITH SQL0913
       SI43465      OSP-DB-MSGSQL7909 RETURN REASON CODE 1 instead of 9
       SI43131      OSP-DB-MSGSQL0204 when using an alias for 3 part name
       SI43072      OSP-DB-OTHER-MSGSQL0751
       SI42990      OSP-DB-INCORROUT Array Support
       SI42989      OSP-DB SELECT WITH MULTIPLE JOIN FAILS MSGSQL0913 F/QSQRUN3
       SI42983      OSP-DB Connect By support
       SI42931      OSP-DB SPECIFY PROGRAM NAME ON CREATE TRIGGER
       SI42856      OSP-DB-OTHER-PERFM WHEN TRYING TO SEND A LARGE BLOB AS PARAM
       SI42785      OSP-DB-INCORROUT Expressions in CALL Support
       SI42617      OSP-DB-QSQCALLSP-MSGMCH0601 with a long running job that cal
       SI42100      OSP-DB-MSGSQL0491 when specifying EXTERNAL ACTION on SQL pro
       SI41955      OSP-DB-INCORROUT Expressions in CALL Support
       SI41916      OSP-DB-MSGMCH1224 F/#CFDATEI T/QSQRUN4-QSQCALLSP CALL PROGRA
       SI41870      OSP-DB-OTHER-F/QSQROUTE-T/QSQROUTE-MSGMCH3601 STORED PROCEDU
       SI41781      OSP-DB-OTHER-MSGSQL0519 USING BRMS CONTROL GROUP
       SI41637      OSP-DB-OTHER-UNPRED UPDGRADE PROCESS FOR V5R4 TO V6R1, RESTO
       SI41637      OSP-DB-OTHER-F/QSQPROCR-T/QSQPROCR-MSGMCH3601 MSGMCH3601 F/Q
       SI41606      OSP-DB-MSGSQL0478 f/QSQPROC Unexpected failure on CREATE OR
       SI41599      OSP-DB-MSGSQL0501 with SQL MERGE statement via QSQPRCED API
       SI41523      OSP-DB-INCORROUT Expressions in CALL Support
       SI41430      OSP-DB-QSQASLOC-MSGSQL0480 when should have received SQL0482
       SI41418      OSP-DB-INCORROUT VISUAL EXPLAIN OF MERGE FAILS
       SI41402      OSP-DB-MSGMCH5401-T/QSQLOCK on lock table statement
       SI41351      OSP-DB-INCORROUT Using file reference variable as argument t
       SI41293      OSP-DB-QSQCLS-MSGSQL0501 for allocated cursor using DRDA
       SI41264      OSP-DB-INCORROUT Expressions in CALL Support
       SI41247      OSP-DB-MSGMCH3601-T/QSQRFRSH with a deflated table
       SI41227      OSP-DB-OTHER-F/QSQCALL-T/QSQCALL-MSGSQL0204 CALL TO PROCEDUR
       SI40949      OSP-DB-INCORROUT Expressions in CALL Support
       SI40879      OSP-DB-QSQCLS-MSGSQL0501 for allocated cursor using DRDA
       SI40819      OSP-DB-MSGSQL0301 calling procedure with XML AS BINARY param
       SI40700      OSP-DB-UNPRED Three part alias statement rewrite
       SI40608      OSP-DB-INCORROUT Expressions in CALL Support
       SI40588      OSP-DB-INCORROUT Expressions In CALL Support
       SI40578      OSP-DB-INCORROUT Array Support
       SI40521      OSP-DB-MSGMCH3601 F/QSQVARSERV/CopyValue when using three-pa
       SI40454      OSP-DB-UNPRED IBM Internal Post GA Test - MSGSQ30000 Errors
       SI40369      OSP-DB-QSQASLOC-MSGSQL0206 on ASSOCIATE LOCATOR to LUW
       SI40361      OSP-DB-UNPRED Failing to propagate LOBs over three-part nami
       SI40249      QSP-DB-MSGMCH3402 f/QSQRUN4/QSQVARSERV/15121 during end job
       SI40181      OSP-DB-INCORROUT Passing XML to CHAR parameter does not pad
       SI40174      OSP-DB-MSGSQL0501 on result set cursor
       SI40161      OSP-DB-MSGMCH5003 f/QQQVALID/33170 when using XML data in OP
       SI40151      OSP-DB-OTHER Expressions in CALL Support
       SI40149      OSP-DB-INCORROUT RAISE_ERROR SQL builtin function produces t
       SI39997      OSP-DB-QSQPROC-MSGSQL0204 when dropping  routine using speci
       SI39985      OSP-DB-INCORROUT Expressions in CALL Support
       SI39897      OSP-DB-QSQASLOC-MSGSQL0204 when using specific name on ASSOC
       SI39861      OSP-DB Internal Maintenance
       SI39846      OSP-DB-MSGSQL0518 EXECUTE IMMEDIATE MERGE repeatedly
       SI39709      OSP-DB-UNPRED Java stored procedure result sets failing over
       SI39703      OSP-DB-MSGSQL0518 when MERGE statement run repeatedly
       SI39630      OSP-F/QLIMROIR-T/QSQPROCR-MSGSQL9015 EXTERNAL STORED PROCEDU
       SI39597      OSP-DB-INCORROUT Array Support
       SI39567      OSP-DB Internal Maintenance
       SI39545      OSP-DB Row locks not released after SQL MERGE
       SI39535      OSP-DB-INCORROUT Array Support
       SI39505      OSP-DB-OTHER-F/QSQROUTE-T/QSQROUTE-MSGSQL0180 DRDA CALL
       SI39486      OSP-DB-INCORROUT Expressions In CALL Support
       SI39447      OSP-DB-UNPRED Java stored procedure result sets failing over
       SI39416      OSP-DB-INCORROUT MSGSQL0440 f/QSQPROC generated when specify
       SI39416      OSP-DB-INCORROUT MSGMCH2601 f/QSQVARSERV/SQVARF_RESOLVE/5480
       SI39371      OSP-DB-MSGSQL0805 in drda job
       SI39343      OSP-DB-INCORROUT Array Support
       SI39327      OSP-DB-QSQDSCPR-MSGSQL0476 when using specific name for DESC
       SI39318      OSP-DB Performance enhancement for SQL MERGE statement
       SI39230      OSP-DB-INCORROUT CLOB GLOBAL VARIABLE MAY CONTAIN INCORRECT
       SI39187      OSP-DB-QSQPREP-MSGMCH1210 when using result sets.
       SI39177      OSP-DB-OTHER Expressions in CALL Support
       SI39164      OSP-DB Internal Maintenance
       SI39060      OSP-DB Internal Maintenance
       SI38915      OSP-DB-QSQDSCPR-MSGMCH1210 on DESCRIBE PROCEDURE or ASSOCIAT
       SI38913      OSP-DB Internal Maintenance
       SI38791      OSP-DB Internal Maintenance
       SI38783      OSP-DB-MSGSQL0180-F/QSQCALLSP Array Support
       SI38774      OSP-DB-MSGSQL0516 with merge stmt
       SI38774      OSP-DB index advisor errors
       SI38701      OSP-DB-INCORROUT Capturing DBMONITOR of Global Variables
       SI38687      OSP-DB Internal Maintenance
       SI38659      OSP-DB Internal Maintenance
       SI38606      OSP-DB-MSGMCH3601-T/QSQPROC
       SI38505      OSP-DB Internal Maintenance
       SI38457      OSP-DB Internal Maintenance
       SI38311      OSP-DB update sq objects with last change date
       SI38287      OSP-DB Internal Maintenance
       SI38119      OSP-DB incorrect describe logic
       SI38072      OSP-DB-OTHER-UNPRED DB2_NUMBER_RESULT_SETS SQLERRD2 NOT SET
       SI38030      OSP-DB Internal Maintenance
       SI37985      OSP-DB-MSGMCH3601 T/QSQPDI MERGE with constraint on target t
       SI37963      OSP-DB-OTHER XML PROCESSING
       SI37915      OSP-DB-INCORROUT XML Array Support
       SI37817      OSP-DB-MSGMCH1880 REFRESH TABLE fails with SQL0901 with cons
       SI37786      OSP-DB Internal Maintenance
       SI37749      OSP-DB-OTHER CREATE OR REPLACE PROCESSING
       SI37731      OSP-DB Internal Maintenance
       SI37675      OSP-DB Internal Maintenance
       SI37666      OSP-DB Internal Maintenance
       SI37667      OSP-DB Internal Maintenance
       SI37650      OSP-DB Internal Maintenance
       SI37628      OSP-DB-QSQALTER-MSGMCH0605, MSGSQL0901 with ALTER REPLACE
       SI37607      OSP-DB-MSGMCH3601 F/QSQCALLSP PROGRAM PARAMETERS GLOBAL VARI
       SI37603      OSP-DB-OTHER XML PROCESSING
       SI37596      OSP-DB Internal Maintenance
       SI37471      OSP-DB-OTHER-F/QSQCALL-T/QSQCALL-MSGMCH3601 PROCEDURE SET_TA
       SI37408      OSP-DB-INCORROUT Toolbox JDBC Array Support
       SI37405      OSP-DB-MSGSQL7049 when running with result sets
       SI37377      OSP-DB SYSPARMS does not contain CCSID for XML table functio
       SI37352      OSP-DB Duplicate key SQL0803 from MERGE statement
       SI37324      OSP-DB-MSGSQL0446 F/QSQCALLSP WHEN CALL PARAMETER HAS XML AS
       SI37281      OSP-DB XML PROCESSING
       SI37271      OSP-DB-INCORROUT DRDA Array Support
       SI37173      OSP-DB-OTHER-F/QSQROUTE-T/QSQROUTE-MSGSQL0311 STORED PROCEDU
       SI37155      OSP-DB SYSPARMS DATA_TYPE COLUMN DOES NOT CONTAIN ARRAY
       SI37126      OSP-DB INTERNAL MAINTENANCE
       SI37014      OSP-DB-MSGSQL0901-F/QSQCALLSP Array Support
       SI37010      OSP ROUTINE_DEFINER IN SYSPROCS IS GETTING SET HAS PROGRAM O
       SI36894      OSP-DB-INCORROUT - MSGSQL0104 ON ALTER FUNCTION IF FUNCTION
       SI36875      OSP-DB XML PROCESSING
       SI36861      OSP-DB Array Support
       SI36833      OSP-DB MCH1210 T/QQQOOOOPEN running MERGE statement
       SI36831      OSP-DB INTERNAL MAINTENANCE
       SI36742      OSP-DB XML PROCESSING
       SI36669      OSP-DB-OTHER-F/QSQPROC-T/QSQPROC-MSGMCH1210 USER-DEFINED FUN
       SI36580      OSP-DB Array Support
       SI36579      OSP-DB-OTHER-INCORROUT MSGSQ20073 ON CREATE FUNCTION IF PREV
       SI36578      OSP-DB Row count not set for NOT ATOMIC MERGE
       SI36527      OSP-DB XML PROCESSING
       SI36520      OSP-DB-UNPRED Force FDOCA mode for DATE/TIME in SPRS
       SI48295      QSQGNDDL - Privilege are not generated for *LIBL qualifed ob
       SI48126      OSP-DB INTERNAL MAINTENANCE
       SI48022      OSP-DB INTERNAL MAINTENANCE
       SI47661      OSP-DB Qualified name option for QSQGNDDL API
       SI46015      OSP-DB Internal Maintenance
       SI45924      SQL-RUN-INCORROUT GENERATE SQL ON A PROCEDURES THAT CONTAINS
       SI44421      OSP-DB-INCORROUT QSQGNDDL() of an EVI index with INCLUDE
       SI43553      OSP-DB-OTHER-INCORROUT GENERATE SQL MISSING THE WHEN WHEN CR
       SI43532      OSP-DB-OTHER-INCORROUT QSQGNDDL API MAY RETURN THE WRONG NAM
       SI43354      OSP-DB-OTHER-F/QSQGNDDL-T/QSQGNDDL-MSGMCH3601 QSQGNDDL API T
       SI42930      OSP-DB SPECIFY PROGRAM NAME ON CREATE TRIGGER
       SI41684      OSP-OSP-DB-OTHER-T/QSQRUN4X/37681-MSGSQL0204 GENERATE SQL->G
       SI41449      OSP STORED PROCEDURE CREATED WITH EXTERNAL NAME "LIB.NAME"/S
       SI41320      OSP-DB-OTHER-INCORROUT QSQGNDDL API BUILDS CREATE INDEX WITH
       SI40706      OSP-DB-INCORROUT Query text generated for a CREATE VIEW SQL
       SI39618      OSP-DB Generate DDL does not generate CLOSQLCSR for routines
       SI39235      OSP-DB-INCORROUT GENERATE SQL SCRIPT TO CREATE VARIABLE GIVE
       SI38405      OSP-THREADS-MSGSQL0199 GENERATE SQL SCRIPT TO CREATE VIEW FA
       SI38380      OSP-OSP-DB-OTHER-INCORROUT TABLE GETS CREATED WITH INCORRECT
       SI38077      OSP-DB Internal Maintenance
       SI38000      OSP-DB Internal Maintenance
       SI37810      OSP-DB Internal Maintenance
       SI37744      OSP-DB Incremental Enhancement
       SI37638      OSP-DB Internal Maintenance
       SI37197      OSP-DB-OTHER-UNPRED NORMALIZED MISSING ON QSQGNDDL API OUTPU
       SI36959      OSP-DB XML PROCESSING
       SI36944      OSP-DB 5733-OMF Support for QSQGNDDL api
       SI36686      OSP-DB XML PROCESSING
       SI36590      OSP-DB XML processing of SQLXSR objects

    Summary Information

    System..............................................i
    Models..............................................
    Release............................................V7R1M0
    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.