PTF Cover Letter
PTF ( Program Temporary Fixes ) Cover letter
OSP-DB-OTHER-F/QSQRUN4-T/QSQRUN4-MSGMCH1210 MSGMCH1210 F/QSQ
Pre/Co-Requisite PTF / Fix List
REQ LICENSED PTF/FIX LEVEL
TYPE PROGRAM REL NUMBER MIN/MAX OPTION
---- -------- --- ------- ------- ------
PRE 5770SS1 710 SI57767 00/00 0000
PRE 5770SS1 710 SI49684 00/00 0000
PRE 5770999 710 MF49948 00/00 0000
PRE 5770SS1 710 SI38332 00/00 0000
PRE 5770SS1 710 SI45856 00/00 0000
CO 5770SS1 710 SI62811 00/00 0000
CO 5770SS1 710 SI56982 00/00 0000
CO 5770SS1 710 SI56984 00/00 0000
CO 5770SS1 710 SI56682 00/00 0000
CO 5770SS1 710 SI53276 00/00 0000
CO 5770SS1 710 SI50046 00/00 0000
CO 5770SS1 710 SI49105 00/00 0000
CO 5770SS1 710 SI49106 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 SI48018 00/00 0000
CO 5770SS1 710 SI48195 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 SI41416 00/00 0000
CO 5770SS1 710 SI39903 00/00 0000
CO 5770SS1 710 SI39069 00/00 0000
DIST 5770SS1 710 SI57813 00/00 0000
DIST 5770SS1 710 SI54179 00/00 0000
DIST 5770SS1 710 SI51159 00/00 0000
DIST 5770SS1 710 SI50683 NONE 0012
DIST 5770SS1 710 SI50467 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
-----------------------------------------------
msgMCH1210 F/QSQRUN4 T/QSQRUN4
CORRECTION FOR APAR SE66906 :
-----------------------------
The problem occurs when STRDBMON is active, and a procedure is
called that wasn't declared or created (with CREATE PROCEDURE).
The problem is fixed with this PTF.
CIRCUMVENTION FOR APAR SE66906 :
--------------------------------
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
-------------- ------------------------------------------------------------
SI63646 OSP-DB INTERNAL MAINTENANCE
SI63009 OSP-DB-QSQCALLSP-MSGMCH3601 Calling stored procedure using d
SI62812 OSP-DB INTERNAL MAINTENANCE
SI62708 OSP-DB-MSGSQL0206 Setting Global Variable to Default Value A
SI61269 OSP-DB-OTHER-F/QSQRUN4MOD/QSQCALLEXPPROC/SQL_EXPINCALL- MSGM
SI60587 OSP-DB-OTHER-UNPRED EXTERNAL PROCEDURE CANNOT BE RESTORED
SI60476 OSP-DB-MSGMCH3601 External Procedure Call with Basic Default
SI60356 OSP-DB-F/QSQROUTS-MSGSQ20226 Looping on SQ20226 when running
SI60298 OSP-DB-OTHER-UNPRED EXTERNAL PROCEDURE CANNOT BE RESTORED
SI60298 OSP-DB Describe Parameter Marker incorrect for CALL with nam
SI59836 OSP-DB Embedded Create trigger uses program target release
SI58275 OSP-DB Internal Maintenance
SI58275 OSP-DB Embedded Create trigger uses program target release
SI58203 OSP-DB Embedded Create trigger uses program target release
SI58151 OSP-DB-MSGSQL0482 not returned on remote procedure
SI58037 OSP-DB Internal Maintenance
SI57968 OSP-DB-MSGMCH3601-T/QSQRUND2 sql stored procedure call
SI57902 OSP-DB-OTHER-T/QSQRUN4-MSGMCH0601 MODULE QSQCALLSP PROCEDURE
SI57832 OSP-DB-OTHER-F/QSQPROC-T/QSQPROC-MSGMCH1210 ON A CREATE PROC
SI57814 OSP-DB Internal Maintenance
SI57525 OSP-DB-JRN-INCORROUT NO AUDIT JOURNAL ENTRY FOR CREATE OR RE
SI57400 OSP-DB-OTHER-THREADS-UNPRED RDB() SHOWS BLANK FOR AN RPG PGM
SI57085 OSP-DB-OTHER-UNPRED STORAGE LEAK USING STRDBMON HOSTVAR(*CON
SI56983 OSP-DB Internal Maintenance
SI56972 F/QSQCALLSP-MSGSQL0443 AFTER CREATE TRIGGER IN GENERATE SQL
SI56755 OSP-DB CPYFRMIMPF CAN RUN SLOW IF OVRDBF IS USED.
SI56721 OSP-DB Internal Maintenance
SI56681 OSP-DB Update SYSTRIGGERS to correct REMARKS column
SI56369 OSP-DB-OTHER-INCORROUT SYSROUTINEDEP DELIMITED NAMES QUOTES
SI56362 OSP-DB-OTHER-LOOP-T/QSQCMTSP-MSGMCH0601
SI56015 OSP-DB-OTHER-F/QDBCRTFI-T/QSQCRTT-MSGCPF3204 DECLARE GLOBAL
SI55908 OSP-DB-OTHER-F/QSQRUN4-MSGMCH0601 WHEN USING A QUERY DEFINED
SI55634 OSP-DB-OTHER-F/QSQRCHK-T/QSQRCHK-MSGMCH1210 RUNSQLSTM FAILS
SI55299 OSP-DB-INCORROUT-MSGMCH3601 QSQGNDDL GENERATE_SQL procedure
SI55278 OSP-DB Internal Maintenance
SI55165 OSP-DB-OTHER-RC2-MSGSQL7049
SI55160 OSP-DB Internal Maintenance
SI55108 OSP-DB-OTHER-UNPRED QSQSVCDMP SPOOLED FILE CREATED
SI55051 OSP-DB-MSGMCH3402-F/QSQFETCH ARRAY RESULT SET CURSOR FETCH F
SI54966 OSP-DB Support HOSTVAR parameter on STRDBMON command - Phase
SI54716 OSP-DB INTERNAL MAINTENANCE
SI54625 OSP-DB INTERNAL MAINTENANCE
SI54623 OSP-DB-OTHER-T/QSQRUN4-MSGMCH1210 MODULE QSQMERGE
SI54396 OSP-DB-OTHER-UNPRED SERVICEABILITY ENHANCEMENT
SI54328 OSP-DB-MSGSQL1506 Generate SQL of a DDS file
SI54178 OSP-DB-MSGMCH3402-F/QSQSETUP SQL PGM/SRVPGM IN QTEMP QRWTSRV
SI54101 OSP-DB CREATE OR REPLACE sourced function not replacing corr
SI54031 OSP-DB Support HOSTVAR parameter on STRDBMON command - Phase
SI53919 OSP-DB-OTHER-UNPRED AUDIT JOURNAL ENTRY FROM COMMENT ON FOR
SI53909 OSP-DB ADD LOCK TABLE SUPPORT MULTIPLE MEMBER FILES
SI53863 OSP-DB INTERNAL MAINTENANCE
SI53779 OSP-DB-OTHER-F/QDBSIGEX-T/QSQPROCR-MSGCPF5009 MSGCPF5009 MSG
SI53703 OSP-DB-MSGSQL0435 sent for a SIGNAL statement with a warning
SI53695 OSP-DB DBMON 1000 QVC1C EXPLAINABLE INCORRECT SET FOR SP PRE
SI53606 OSP-DB SQL procedure parameter DEFAULT value in SYSPARMS mis
SI53278 OSP-DB SYSROUTINEDEP column PARM_SIGNATURE has the wrong dat
SI53154 OSP-DB Generate SQL for obfuscated procedure fixes
SI53159 OSP-DB-OTHER-F/QQQSRVE1-T/QSQRUN3-MSGCPD4373 A MSGCPD4373 MA
SI53044 OSP COMMENT ON FOR STORED PROCEDURE CAUSES A SYSROUTINE SYNC
SI52840 OSP-F/QSQRUN4-T/QSQRUN4-MSGMCH1210 SIGNAL STATEMENT TRIGGER
SI52814 OSP-DB-OTHER-INCORROUT GENERATE SQL TRANSLATING '/' TO '.'
SI52720 OSP-DB-MSGMCH0602-T/QSQROUTE long running job
SI52467 OSP-DB-OTHER-F/QSQRUN4-T/QSQRUN4-MSGMCH3601 A MSGMCH3601 F/Q
SI52464 OSP-DB-OTHER-T/QSQPROC-MSGSQL0913 DROPPING A SQL PROCEDURE
SI52300 OSP-DB QIBM_SQL_NO_CATALOG_UPDATE should include Rename Libr
SI52284 OSP-DB-OTHER-T/QSQRUN4X/19306-MSGSQL0204 WITH OVRDBF, MERGE
SI52276 OSP-DB-OTHER-MSGSQL0443 SERVICEABILITY ENHANCEMENT
SI52255 OSP-DB-SQL Support optionally clearing SQLSTATE on truncatio
SI52140 OSP-DB INTERNAL MAINTENANCE
SI52009 OSP-DB INTERNAL MAINTENANCE
SI51988 OSP-DB-OTHER-LOOP QSQRUN4/QSQCALLSP/MAP_WITH_CCSIDS
SI51910 OSP-DB INTERNAL MAINTENANCE
SI51802 OSP-DB-OTHER-MSGCPF5129-T/QSQRUN4 MODULE QSQMERGE
SI51679 OSP-DB-OTHER-F/QDMROUTE-T/QSQTRGIO-MSGCPF2207
SI51675 OSP-DB Generate SQL for EVI index with include columns not c
SI51446 OSP-DB-SQL Support optionally setting indicator on truncatio
SI51395 OSP-DB Internal Maintenance
SI51324 OSP-DB-OTHER-UNPRED SYSTEM SQL APPEARS IN STRDBMON WHEN INCS
SI51212 OSP-UNPRED CRTDUPOBJ AND MOVOBJ OF PROGRAM REMOVES CATALOG R
SI51158 OSP-DB-OTHER-INCORROUT AFTER MOVING FROM R540 TO R710, PROCE
SI51147 OSP-DB-OTHER-INCORROUT SQL7985 AND SQ99999 WITH NO RESULT SE
SI51080 OSP-DB Support compatible date/time strings in input arrays
SI51076 OSP-DB-OTHER-INCORROUT Deleting *SRVPGM of external function
SI51068 OSP-DB-OTHER-LOOP QSQAPIS/sqludf_create_locator
SI50993 OSP-DB-OTHER-T/QSQRUN4-MSGMCH3601 MODULE QSQCALLSP PROCEDURE
SI50934 OSP-DB-MSGCPD5D02 ON CREATE FUNCTION EMBEDDED IN A HLL PROGR
SI50924 OSP-DB-SQL Dynamic Compound Statement Support
SI50911 OSP-DB Global variable initialized to NULL when default is I
SI50733 OSP-DB QSQGNDDL() enhancement to generate SQLindexes for key
SI50618 OSP-THREADS-F/QSQRUN4-T/QSQRUN4-MSGSQL0913 WITH A REFRESH TA
SI50553 OSP-DB-OTHER-F/QSQRUN4-T/QSQRUN4-MSGSQL0446 AFTER UPGRADING
SI50454 OSP-DB-OTHER-F/QSQROUTS-T/QSQROUTS-MSGSQL0313 SQL0313 WHEN E
SI50432 OSP-DB-QSQPROCR-MSGSQL9015 when CRTDUPOBJ of a program acros
SI50418 OSP-DB-OTHER-F/EX2401PTRDOESNOTEXIST-T/QSQPROC-MSGMCH3601 QZ
SI50326 OSP-DB-MSGSQL0429 Using LOB variable within a SQL procedure
SI50306 OSP-DB-OTHER-INCORROUT TRIGGERS FIRE IN WRONG ORDER FOR MERG
SI50091 OSP-DB-OTHER-INCORROUT AFTER DROP PROCEDURE, INCORRECT INFOR
SI50084 OSP-DB-OTHER-F/QZDGDBGS-T/QSQRUN4-MSGMCH1210 MSGMCH1210 F/QZ
SI50048 OSP-DB Support for Debug of Scalar UDFs with Data Studio
SI50028 OSP-DB-QSQPROCR-MSGSQL9015 Restore of program for procedure
SI49946 OSP-DB-OTHER-MSGCPF3BCC-F/QSQPROC/BUILDNLSSSTRUCTURE When do
SI49916 OSP-DB-QSQTRGPM-MSGMCH1210 creating a duplicate trigger with
SI49916 OSP-DB-QSQPROCR-MSGSQL9015 on MOVOBJ or RNMOBJ of a library
SI49888 OSP-DB-OTHER-F/QSQPROC-T/QSQPROC-MSGSQL0901 A MSGSQL0901 MAY
SI49875 OSP-DB-OTHER-F/QSQPROCR-T/QSQPROCR-MSGMCH1210 MSGMCH1210 F/Q
SI49833 OSP-DB-QSQPROCR-MSGSQL9015 on MOVOBJ or RNMOBJ of a library
SI49818 OSP-DB-OTHER-MSGSQ20073 ON A CREATE FUNCTION USED BY AN MQT
SI49814 OSP-DB-MSGMCH3601-F/QSQRUN4 QSQCALLEXP EXPRESSIONS IN CALL F
SI49814 OSP-DB-OTHER-MSGSQL0302 CALLING JAVA STP WITH LOBS
SI49738 OSP-DB-OTHER-F/QZDGDBGS-T/QSQRUN4-MSGMCH0601 FOR GENERATE SQ
SI49725 OSP-DB-OTHER-F/QSQPROCR-T/QSRRSTPS-MSGSQL9015 RESTORING SQL
SI49704 OSP-DB-OTHER Disallow triggers with BEFORE action over QSYS2
SI49688 OSP-DB Unexpected SQL7909 for DROP external SQL function
SI49668 OSP-DB-OTHER Incorrect trigger name in catalog when trigger
SI49658 OSP-DB-OTHER-INCORROUT RSTOBJ AND RNMOB AT TIMES RESULT IN M
SI49640 OSP-F/QSQRUN3-T/QSQRUN3-RC3-MSGSQL7008 MQT FAILS TO REFRESH
SI49629 OSP-DB-OTHER-MSGMCH3601 F/QSQPROC/45634 on SQL CREATE PROCED
SI49538 OSP-DB-OTHER-MSGSQL0392 PROCESSING A DRDA RESULT SET
SI49511 OSP-DB Problems after a CREATE PROCEDURE with default parame
SI49511 OSP-DB-OTHER-Sort sequence on SQL SET OPTION not used for SQ
SI49466 OSP-DB SYSROUTINE locked by QDBSRVXR2 after PTFs are applied
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 |
Licensed Program............... | 5770SS1 |
APAR Fixed.......................... | View details for APAR SE66906 |
Superseded by:...................... | View fix details for PTF SI67442 |
Recompile........................... | N |
Library............................. | QSYS |
MRI Feature ........................ | NONE |
Cum Level........................... | 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, 2017, 2018 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.
Was this topic helpful?
Document Information
Modified date:
25 July 2017