IBM Support

SI72424 - OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGMCH3402 MSGMCH3402 F/QSQ

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGMCH3402 MSGMCH3402 F/QSQ


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770SS1  710  SI50761   00/00    0000
PRE  5770SS1  710  SI43415   00/00    0000
CO   5770SS1  710  SI59621   00/00    0000
CO   5770SS1  710  SI53721   00/00    0000
CO   5770SS1  710  SI48827   00/00    0000
CO   5770SS1  710  SI48195   00/00    0000
CO   5770SS1  710  SI48197   00/00    0000
CO   5770SS1  710  SI46303   00/00    0000
CO   5770SS1  710  SI46308   00/00    0000
CO   5770SS1  710  SI46298   00/00    0000
CO   5770SS1  710  SI46018   00/00    0000
CO   5770SS1  710  SI45230   00/00    0000
CO   5770SS1  710  SI44825   00/00    0000
CO   5770SS1  710  SI43957   00/00    0000
CO   5770SS1  710  SI41357   00/00    0000
CO   5770SS1  710  SI40611   00/00    0000
CO   5770SS1  710  SI39900   00/00    0000
CO   5770SS1  710  SI39903   00/00    0000
CO   5770SS1  710  SI39127   00/00    0000
DIST 5770SS1  710  SI66250   00/00    0000
DIST 5770SS1  710  SI66540   00/00    0000
DIST 5770SS1  710  SI64198   00/00    0000
DIST 5770SS1  710  SI60498   00/00    0000
DIST 5770SS1  710  SI59126   00/00    0000
DIST 5770SS1  710  SI53341   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

-----------------------------------------------
msgMCH3402 F/QSQRUN3 T/QSQRUN3

CORRECTION FOR APAR SE70038 :
-----------------------------
An embedded INSERT with sub SELECT statement intermittently
fails with a MCH3402 while handling a rebuilt QDT/AP for the
statement. We are using a temporary copy of the QDT/AP but
mistakenly deleted the temporary copy.  The handling of the
temporary copy of the QDT/AP has been corrected.

CIRCUMVENTION FOR APAR SE70038 :
--------------------------------
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) OPTION(*IMMED)
STRTCPSVR SERVER(*DDM)

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

ENDTCPSVR SERVER(*DIRSRV) OPTION(*IMMED)
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
--------------  ------------------------------------------------------------
   SI66249      OSP-DB-OTHER-F/QZDASRV-T/QZDASRV-MSGMCH1210 EXTRANEOUS COMMO
   SI67612      OSP-DB-OTHER-INCORROUT DESCRIPTOR INDEX NOT VALID
   SI67445      OSP-DB-QSQSFCLS-MSGMCH1210 and looping after error on Select
   SI67216      F/#DBDDS-MSGMCH3406 MCH3406 F/#DBDDS T/QDBDLTFI TP/DLTMEM ON
   SI66541      OSP-DB-OTHER-UNPRED MERGER STATEMENT WITH AN UPDATE OPERATIO
   SI66467      OSP-MSGMCH3601-PAR-940XBASE RPG SQL APPLICATION RETURNS MCH3
   SI66074      F/QSQRUN1-MSGSQL0904-RC160-MOD/QSQDESC F/QSQRUN1-MSGSQL0904-
   SI66071      OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0509 WHEN STORED PROC
   SI66065      F/#CFOCHKR-MSGMCH3603 MSGMCH3603 MCH3603 F/#CFOCHKR X/000C2C
   SI65996      OSP-DB-OTHER-T/QQQSRVE1-MSGMSGMCH3601 STORED PROCEDURE CALLS
   SI65988      OSP-F/QSQRUN1-T/QSQRUN1-RC167-MSGSQL0904 SQL0904 WITH TYPE 7
   SI65988      F/QSQRUN1-MSGSQL0904-RC160-MOD/QSQDESC F/QSQRUN1-MSGSQL0904-
   SI65627      OSP-DB-OTHER-F/QSQRUN1X/19980-T/T/SAME-MSGMCH3601 BANKING AP
   SI65557      OSP-F/QSQROUTS-T/QSQROUTS-MSGSQL0518 REUSE OF SELECT FROM IN
   SI65557      F/QSQRUN2-MSGSQL0326 SQL RPG PROGRAM FAILS WITH SQL0326. SEL
   SI65121      F/QQQSRVE1-MSGMCH1210-MOD/QQQOOOSETS F/QQQSRVE1-MSGMCH1210-M
   SI64911      OSP-DB-MSGSQL0206 with GVAR in remote drda job
   SI64720      OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0913 CODE ADDED TO AI
   SI64719      OSP-DB-OTHER INSERTS OF BLOB FIELDS TO IBM I DATABASE FROM A
   SI64636      OSP-MSGSQL0138-D/TQSQRUN3-PAR WHEN CALLING A STORED PROCEDUR
   SI64518      OSP-DB-OTHER-INCORROUT INTERMITTENT PROBLEM INCORROUT OUTPUT
   SI64518      OSP-DB-OTHER-INCORROUT STORED PROCEDURE WITH IDENTITY_VAL_LO
   SI64518      OSP-MSGCPD4306-D/TQSQOPEN-PAR DECLARE CURSOR STATEMENT IN EM
   SI64498      OSP SEVERAL QSQSVCDMP DUMPS FROM QZDASOINIT JOBS.
   SI64498      OSP-OTHER-UNPRED CURSOR IS BEING HARD CLOSED DUE TO INTERNAL
   SI64221      OSP-DB-MSGMCH0601-F/QSQSTATS CREATE TABLE AS statement WITH
   SI64199      OSP-UNPRED ENDDBMON OF DBMON WITH PARM HOSTVAR(*CONDENSED) L
   SI64191      OSP-DB-OTHER-F/QSQRUN1-T/QSQRUN1-MSGSQL0904 SQL JOB FAILS WI
   SI63991      OSP-DB-OTHER-PERFM OSP-DB-OTHER-PERFM
   SI63974      OSP-DB-OTHER-T/QSQSBAS2-MSGMCH1210 MODULE QSQSFCRT
   SI63784      OSP-DB-OTHER-PERFM POOR ESTIMATE FOR UDTFS USED BY OBJECT_ST
   SI63638      OSP-DB-QQQOOOSETS-MSGMCH5003 using CURRENT DECFLOAT ROUNDING
   SI63466      OSP-DB-OTHER-T/QSQSBAS2-MSGMCH5804 SQL0901 LOCK SQL PACKAGE
   SI63380      OSP-DB-OTHER-UNPRED EMBEDDED SQL STATEMENTS IN RPGLE PROGRAM
   SI63380      OSP-DB-OTHER-F/QSQLOPEN-MSGMCH3601 WHEN ANOTHER PROGRAM WAS
   SI63287      OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-MSGMCH3601 MCH3601 MCH1210
   SI63213      OSP-DB-OTHER-UNPRED INFORMATIONAL QSQSVCDMP SPOOL FILES ARE
   SI63069      OSP-DB Internal Maintenance
   SI62897      OSP-DB-MSGCPF3272 long running cli job
   SI62802      OSP-INCORROUT AFTER INSERT EXTERNAL TRIGGER FIRED BY AN INSE
   SI62645      OSP-DB-OTHER-INCORROUT DBMON WORK WITH SQL STATEMENT AND VAR
   SI62272      OSP-DB-OTHER-THREADS-PERFM SPACE LOCATION LOCKS ARE NOT BEIN
   SI62162      F/QRWSQRY-MSGCPD3E06 F/QRWSQRY-MSGCPD3E06
   SI61906      OSP-DB-OTHER-UNPRED ADD QAQQINI OPTION SQL_STMT_COMPRESS_REU
   SI61197      OSP-DB-OTHER-INCORROUT FRENCH CHARATER ' ' ('C0'X) IS DISPLA
   SI61180      OSP-DB-OTHER-F/EX3E06COMMITRESOURCELIMITEXCEEDED-T/QDBGETMQO
   SI61055      OSP-DB reuse remote server job for 3 part SQL
   SI60880      OSP-DB-QSQOPEN-MSGMCH3601 on EXECUTE IMMEDIATE with DRDA
   SI60687      OSP-DB-MSGMCH0601 insert with remote subselect
   SI60614      OSP GET DIAGNOSTICS SQL STATEMENT DOES NOT RETURN CORRECT SQ
   SI60502      OSP-DB-OTHER-F/QSQRUN3/QSQINS-MSGSQL0913X/31981 UPDATE FAILS
   SI60392      OSP-DB-PERFM Slow performance when using SQL packages in mul
   SI59965      OSP-DB-OTHER-F/QSQCONN-T/QSQCONN-MSGSQL0950 MSGSQL0950 AND M
   SI59918      OSP-DB Return DB2_ROW_LENGTH on OPEN
   SI59630      OSP-DB-OTHER-F/QQQSRVE1-T/QQQSRVE1-MSGMCH1210 MCH1210 F/QQQS
   SI59627      OSP-DB-OTHER-T/QQQIMPLEX/16106-MSGCPF4287 INSERT USING 3-PAR
   SI59620      OSP-DB-OTHER ADD PACKAGE INFORMATION TO SYSLIMITS CATALOG
   SI59592      OSP-DB-OTHER-MSGSQL0913 SERVICABILITY ENHANCEMENT
   SI59127      OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-RC2-MSGSQL0101 SQL RPG OBJE
   SI59092      OSP-DB-MSGMCH3601-F/QSQDESC SET STATEMENT FAILURE
   SI58977      OSP-DB-OTHER-MSGSQL0913 SERVICABILITY ENHANCEMENT
   SI58973      OSP-DB-OTHER-F/QSQROUTS-T/QSQROUTS-MSGSQL0518 SECOND STORED
   SI58964      OSP-DB Wrong DB2_NUMBER_ROWS WITH OFFSET
   SI58924      OSP-DB-OTHER-F/QSQSBAS2X/2815-T/SAME-MSGMCH1210 CPYF RSULTS
   SI58787      OSP-DB-OTHER-F/QSQRUN3-MSGSQL0517
   SI58648      OSP-DB-OTHER-MSGCPF3220 TRYING TO DELETE A TEMP TABLE AFTER
   SI58349      OSP-DB-OTHER-SAP400-F/#CFOCHKR-T/QSQRUN1-MSGMCH3402 MSGMCH58
   SI58337      OSP-DB-OTHER-THREADS-MSGMCH0601 MCH0601
   SI58224      OSP-DB-OTHER-INCORROUT QSQSVCDMP DOESN'T GO TO THE QEZDEBUG
   SI58127      OSP-DB Internal Maintenance
   SI57918      OSP-DB-OTHER-MSGSQL0335 NOT ISSUED AS WARNING
   SI57875      OSP-OTHER-INCORROUT UNICODE TRANSLATION INTERMITTENTLY FAILS
   SI57604      OSP-DB-OTHER-T/QSQRUN1-MSGMCH3601 ON SECOND PREPARE OF A MER
   SI57331      OSP-OTHER-INCORROUT UNICODE TRANSLATION INTERMITTENTLY FAILS
   SI57260      OSP-DB-OTHER-UNPRED ADD QAQQINI OPTION SQL_STMT_COMPRESS_REU
   SI57218      OSP-DB-OTHER-INCORROUT HETEROGENEOUS DRDA CONNECTION NOT GET
   SI57218      OSP-DB-OTHER-THREADS-F/QSQRUN1-T/QSQRUN1-MSGSQL0904 SQL0904
   SI57161      OSP-DB-OTHER-F/QSQRUND-T/QSQRUN3-MSGSQL0901 A MSGSQL0901 F/Q
   SI57083      OSP-DB-OTHER-UNPRED STORAGE LEAK USING STRDBMON HOSTVAR(*CON
   SI56979      OSP-DB-OTHER-T/QSQDDL1-MSGMCH1210 MODULE QSQACTNM ON AN INSE
   SI56944      OSP-DB-OTHER-F/QQQISVSU-T/QSQRUN3-MSGCPD4372 A MSGCPD4372 MA
   SI56833      OSP-DB-OTHER-UNPRED SERVICEABILITY ENHANCEMENT
   SI56357      OSP-HOSTSERVERS-OTHER-INCORROUT RANDOM DATA TYPRE MISMATCH
   SI56336      OSP-DB-OTHER-INCORROUT INCORRECT DATA IN CLOB FIELD.
   SI56234      OSP-MSGCPF4268 FAST DELETE INCORRECT WHEN DELETING RECORDS V
   SI56184      OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0407 INSERT STATEMENT
   SI56011      OSP-DB-OTHER-UNPRED MSGSQL0104 FOR VALID SQL STATEMENT AFTER
   SI55989      OSP-MSGCPF4268 DIFFERENT BEHAVIORS FOR BATCH VS INTERACTIVE
   SI55525      OSP-DB QSQPRCED() creates package using a larger capacity *S
   SI55440      OSP-DB SQL Statement Operation blank in SQL Plan Cache
   SI55419      OSP-DB-OTHER-T/QSQRUN3-MSGCPD4301 AFTER ALTER TABLE
   SI55308      OSP-DB-OTHER-T/QSQSBAS2-MSGMCH3603 MODULE/QSQHDCLSm PROCEDUR
   SI55280      OSP-DB Internal Maintenance
   SI55268      OSP-DB-OTHER-T/QSQSBAS-MSGMCH1210 MODULE QSQVATTR PROCEDURE
   SI55249      OSP-DB-OTHER-F/QQQVFMT-T/QSQRUN3-MSGCPD4302 ON A QUERY FROM
   SI55159      OSP-DB Internal Maintenance
   SI55112      OSP-DB-OTHER-UNPRED QSQSVCDMP SPOOLED FILE CREATED
   SI55070      OSP-DB incorrect sqlcode returned on INSERT
   SI54942      OSP-DB-MSGSQL0502 after query with 3 part name
   SI54865      OSP-DB-OTHER-UNPRED UPDATING A TABLE WITH BOTH A NULLABLE FI
   SI54621      OSP-DB APPLICATIONS GETTING MSGMCH0601 T/QSQRUN2 MOD/QSQFETC
   SI54581      OSP-DB-OTHER-T/QQQOOODBOP-MSGMCH3601
   SI54566      OSP-DB Inserting Date using global var fails
   SI54313      OSP-DB-OTHER-T/QQQOOODBOP-MSGMCH3601
   SI54172      OSP-DB MSGMCH3603 F/#CFOCHKR T/QDBCLOSE IS ISSUED WHEN JOB R
   SI54132      OSP-DB DISPLAY LONG FIELD NAMES FOR SOME SQ MESSAGES
   SI54095      OSP-DB-MSGSQL0407-F/QSQINS SQL INSERT OR UPDATE MISSING MSG
   SI54026      OSP-DB Support HOSTVAR parameter on STRDBMON command - Phase
   SI53848      OSP-DB-OTHER-UNPRED PROGRAM WITH EMBEDDED SQL CONTINUALLY GR
   SI53720      OSP-DB-OTHER-F/STRINGHIGHUSE4K-T/QSQROUTX-MSGMCH0601 MCH3601
   SI53592      OSP-DB-OTHER-UNPRED SERVICEABILITY CHANGE
   SI53580      OSP-DB-OTHER-F/QQQVFMT-T/QSQRUN3-MSGCPD4301 ON RUNNING A PRO
   SI53438      OSP-DB-OTHER-T/QSQALCDS-RC542-MSGSQL0904
   SI53340      OSP-MSGSQL0312 STORED PROCEDURE RUNNING INSERT W/SUBSELECT W
   SI52979      OSP-DB-OTHER-F/QSQSBAS2-T/QSQSBAS-MSGSQL0901 MSGSQL0901 F/QS
   SI52835      OSP-DB-OTHER COMPRESS OF PACKAGE NOT OCCURRING
   SI52793      OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGMCH0601 MSGMCH0601 F/QSQ
   SI52767      SP/QSQRUN3-MSGSQL0511-MOD/QSQOPEN-OPCS/CLEANUP SQL SELECT UN
   SI52692      OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0443 JOB INTERMITTENT
   SI52321      OSP-DB DRDA AS detail in the SQL Plan Cache is incomplete
   SI52242      OSP-DB-OTHER-F/QDBIOERRQO-T/QDBIOERRQO-MSGCPF503E UDF RUNNIN
   SI52242      OSP-DB-SQL Support optionally setting indicator on truncatio
   SI51775      OSP-DB Internal Maintenance
   SI51680      OSP-DB-OTHER-F/QDMROUTE-T/QSQTRGIO-MSGCPF2207
   SI51654      F/QSQROUTS-MSGSQL0404 MSGSQL0404 F/QSQROUTST/QSQROUTS
   SI51404      OSP-DB-OTHER-F/QSQROUTS-T/QSQROUTS-RC'0100E'-MSGSQL0464 SQL0
   SI51389      OSP-DB MCH1210 F/T: QSQSTATS/QSQSTATS
   SI51060      OSP-DB-OTHER-INCORROUT SQL CALL LEVEL INTERFACE GRAPHIC PARA
   SI51046      OSP-DB Internal Maintenance
   SI50922      OSP-DB-SQL Dynamic Compound Statement Support
   SI50745      OSP-DB-OTHER-T/QSQQDTNV-MSGMCH0601 ON DELETE WITH NO WHERE C
   SI50665      OSP-DB-MSGSQL0803-F/QSQINS INCORRECT NULL TOKEN VALUE FOR ME
   SI50591      OSP-DB SCROLLABLE CURSORS WITH FETCH N ROWS IN DRDA APPLICAT
   SI50562      OSP-DB-OTHER-F/QSQRUN4-T/QSQRUN4-MSGSQL0446 AFTER UPGRADING
   SI50523      OSP-DB-OTHER-INCORROUT THE WRONG CURSOR RE-USED BY A DYNAMIC
   SI50467      OSP-DB-QSQPROCR-MSGSQL9015 when CRTDUPOBJ of a program acros
   SI50465      OSP-DB-OTHER-F/STRINGHIGHUSE4K-T/QSQRUN2/QSQFETCH-MSGMCH0601
   SI50434      OSP-DB-QSQDESC-INCORROUT Dynamic function code not set for C
   SI50310      OSP-DB-OTHER-RC3022-MSGSQL0901 PREPARING A MERGE STATEMENT
   SI50296      OSP-DB-OTHER-INCORROUT WHEN USING ALIAS, WRONG FILE IS CLEAR
   SI50240      OSP-DB-OTHER-T/QQQQUERY-MSGMCH1210
   SI50214      OSP-DB BLOCK SQL FETCH FROM A RESULT SET RETURNED FROM A STO
   SI50212      OSP-DB CNN LOOPING POSSIBLE WHEN ALIASED RDB USED IN 3PART D
   SI50135      OSP-DB-OTHER-F/QSQRUN3/QSQOPEN-T/QSQRUN3/QSQOPEN-MSGMCH0601
   SI50027      OSP-DB-OTHER-F/QQQVFMT-T/QSQRUN3-MSGCPD4301 A MSGSQL0901 (MS
   SI49834      OSP-DB-QSQCALLEXP-MSGSQL0901 when using defaults on procedur
   SI49807      OSP-DB-OTHER-INCORROUT on UPDATE when using extended indicat
   SI49770      OSP-DB-OTHER-T/QSQRUN3-MSGMCH0601 MODULE QSQSFIRT
   SI49770      OSP-DB-MSGMCH4429 Using nested trigger programs expecting MS
   SI49717      OSP-DB-OTHER-T/QSQRUN1/11075-MSGSQL0101 SQL STMT FAILS WITH
   SI49575      OSP-DB-OTHER-F/SETSYSPTRFROMPTR-T/QSQOPEN-MSGMCH3601 MSGMCH3
   SI49575      OSP-DB-OTHER-T/QSQRUN2X/19141-MSGSQL0420 SQL STMT: SELECT MA
   SI49498      OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-MSGSQL0204 WHEN A FILE USED
   SI49445      OSP-DB-INCORROUT Database monitor delete statements
   SI49282      OSP-DB-OTHER-F/QQQVFMT-T/QSQRUN3-MSGCPD4301 MSGCPD4301 MAY O
   SI49266      OSP-DB-OTHER-PERFM BAD PERFORMANCE DUE TO SQL LONG NAME RESO
   SI49102      OSP-DB-OTHER-INCORROUT INCORRECT RECORD LENGTH REPORTED BY D
   SI49026      OSP-DB-OTHER-UNPRED SERVICEABILITY CHANGE
   SI49008      OSP-DB-OTHER-F/QQQVSEL-T/QSQRUN3-MSGCPD4324
   SI48972      OSP-DB-MSGSQL0514 SELECT against hetero server
   SI48906      OSP-DB-QSQOPEN-MSGMCH3601 with long running program
   SI48826      OSP-DB INTERNAL MAINTENANCE
   SI48748      OSP-DB-MSGMCH3402 T/QDBDLTFI During SELECT FROM INSERT
   SI48685      OSP-DB-MSGSQL0313 insert with remote subselect
   SI48565      OSP-DB-OTHER-LOOP ADD CODE TO PREVENT LOOP IN QSQOPEN
   SI48565      OSP-DB-OTHER-UNPRED SERVICEABILITY ENHANCEMENT
   SI48524      OSP-DB INSERT OF VARGRAPHIC DATA RESULT IN SQL0404
   SI48393      OSP-DB-OTHER-INCORROUT OPTIMIZER CHOOSES WRONG LIBRARY WHEN
   SI48307      OSP-DB INTERNAL MAINTENANCE
   SI48258      OSP-DB-OTHER-PERFM ORPHANED SPACE LOCATION LOCKS
   SI48234      OSP-DB 3 part named objects not resolved from LIBL
   SI48203      OSP-DB-MSGSQL0408 Inserting floating point literal into UDT
   SI48192      OSP-DB-OTHER-RC480-MSGSQL0904
   SI48153      OSP-DB INTERNAL MAINTENANCE
   SI47887      OSP-DB-OTHER-PERFM MILLIONS OF SPACE LOCATION LOCKS LEFT IN
   SI47763      OSP-DB-OTHER-MSGSQL0913-F/QSQRUN3 MODULE QSQOPEN PROCEDURE B
   SI47742      OSP-DB support CREATE TABLE AS with a remote query
   SI47730      OSP-DB INTERMITTENT MSGSQL0392 CAUSING 0 ROWS RETURNED FOR A
   SI47729      OSP-DB-OTHER-PERFM FULL OPENS WHEN SQL STATMENT HAS ALREADY
   SI47726      OSP-DB-OTHER-INCORROUT A SQL UPDATE MAY TRUNCATE A VALUE INS
   SI47677      OSP-DB-OTHER-T/QSQRUN3-MSGMCH3603 MODULE QSQOPEN PROCEDURE F
   SI47666      OSP-DB-MSGSQL0804 Statement uses XML and is prepared and als
   SI47647      OSP-DB SFI returning incorrect results
   SI47588      OSP-DB-OTHER-F/QSQRUN4-T/QSQRUN4-MSGSQL0440 MSGSQL0440
   SI47540      OSP-DB-OTHER-INCORROUT WRONG DATA IN MQT OF A VIEW OVER A PA
   SI47370      OSP-DB-OTHER-UNPRED SERVICEABILITY
   SI47320      OSP-DB-OTHER-F/QQQSRVE1-T/QQQOOOSETS-MSGMCH1210 ODBC FAILS S
   SI47320      OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGMCH3601 MSGMCH3601 F/QSQ
   SI47276      OSP-DB-OTHER-MSGSQL0904RC167-F/QSQRUN1 MODULE QSQPREP
   SI47257      OSP-DB CLOB field is truncated on INSERT
   SI47203      OSP-DB-OTHER-F/QSQADITM-T/QSQSETTXT-MSGSQL0901 MULTIPLE SQL0
   SI47203      OSP-DB-OTHER-INCORROUT SQLERRD2 IS NOT GETTING RESET WHEN 0
   SI47008      OSP-DB-MSGMCH0601-T/QSQFETCH long running job
   SI46911      OSP-DB-OTHER-INCORROUT A SQL QUERY MAY RESULT IN INCORRECT R
   SI46866      OSP-DB CHECK NAMING MODE FOR CACHED QUALIFIED SQL STMTS AT P
   SI46741      OSP-DB-OTHER-F/QQQVSEL-T/QSQOPEN-MSGCPD4324
   SI46741      OSP-DB-OTHER-T/QSQRUN3-MSGSQL0545 INSERTING INTO PARTITION T
   SI46714      OSP-DB-OTHER-MSGSQL0913 WHEN CURSORS ARE REUSED ACROSS ACTIV
   SI46714      OSP-DB-OTHER-F/QDBSIGEX-T/QSQRUN3-RC20-MSGCPF5035 WHEN UPDAT
   SI46649      OSP-DB MSGMCH3601 T/QSQPREP running MERGE repeatedly over DR
   SI46613      OSP-DB-MSGSQL7001 select using 3 part alias
   SI46580      OSP-DB-OTHER-T/QSQSFCRT-MSGCPF5183
   SI46446      OSP-DB-MSGMCH1210-QZDASQL error from QSQRUN1 when using 3-pa
   SI46422      OSP-DB-OTHER-F/#MNRNRL-T/QSQSBAS2-MSGMCH3401 A MSGMCH3401 MA
   SI46302      OSP-DB Support XMLTABLE function
   SI46299      OSP-DB ADD QQI1 FAST DELETE REASON CODE to DBMON 1000 record
   SI46225      OSP-DB SURFACE SQLCODE AND SQLSTATE IN DBMON FETCH RECORDS
   SI46210      OSP-DB-OTHER-F/QSQROUTE-T/QSQROUTE-MSGSQL0100 WHEN GETTING D
   SI46151      OSP-DB-MSGSQ20398 insert with subselect using xml
   SI46129      OSP-DB-QSQCLSCR-MSGMCH3601 when using 3 part naming
   SI46072      OSP-DB-OTHER-F/SQL0404 SECOND PREPARED STATEMENT FAILS
   SI46057      OSP-DB GET DIAGNOSTICS DB2_NUMBER_ROWS is zero for reused SQ
   SI46033      OSP-DB-MSGSQL0313 insert with subselect
   SI46012      OSP-DB-OTHER-INCORROUT WHEN USING SQL_DEFLATE_TABLE QAQQINI
   SI45997      OSP-DB-MSGSQL0313 insert with subselect
   SI45993      OSP-DB-MSGSQL0305 from repeated SELECT FROM INSERT
   SI45962      OSP-DB Support Insert with Remote Subselect
   SI45960      OSP-DB-OTHER-RCAD-MSGSQL7917
   SI45891      OSP-DB V7R1 DRDA CONNECTION TO A V5R3 SYSTEM. SELECT FAILS M
   SI45824      OSP-DB-OTHER-MSGSQL0470 MSGSQL0470 OCCURS WHEN EXEC A PARAME
   SI45790      OSP-DB-OTHER-RCAD-MSGSQL7917
   SI45790      OSP-DB-OTHER-LOOP IN MODULE QSQRCFHT after MSGCPF503E RC9
   SI45624      OSP-DB-MSGSQL0501 with 3 part name to DB2 for Z
   SI45523      OSP-DB-OTHER-MSGSQL0913-MSGSQL0502 SERVICEABILITY ENHANCEMEN
   SI45467      OSP-DB-MSGSQL0511 with for update of clause
   SI45349      OSP-MSGSQL0502 CURSOR ISSUES WHEN CHANGING LIBRARY LIST MULT
   SI45231      OSP-DB EXTEND QRECOVERY/QSQ901S FOR INTERNAL USE
   SI45172      OSP-DB-MSGMCH3601 TO QQQQUERY
   SI45172      OSP-DB-OTHER-F/QSQROUTX-T/QSQROUTX-MSGSQL0332 USE OF SQL_ATT
   SI45172      OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0503 UPDATE STATEMENT
   SI45172      OSP-DB-MSGCPD4374-T/QSQRUN3 MODULE QSQOPEN RC 7
   SI45107      OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-MSGMCH0601 MSGMCH0601 OCCUR
   SI45106      OSP-DB-OTHER-PERFM ODPs not reused when using overrides
   SI45106      OSP-DB-OTHER-F/QSQRUN1-T/QSQRUN1-MSGMCH0601 MCH0601 AND SQL0
   SI45078      OSP-DB-QQQVFILE MSGCPF4269 after table recreated
   SI45044      OSP-DB PROGRAM IS NOT PICKING UP NEW FILE AFTER LIB LIST IS
   SI45017      OSP-DB MSGSQL0501 F/QSQRUN4 T/QSQRUN4 MODULE QSQCLS PROCEDUR
   SI44919      OSP-DB-OTHER-T/QSQRUN3-MSGMCH3601  MODULE QSQOPEN PROCEDURE
   SI44919      OSP-DB-OTHER-F/QSQRUN2-MSGCPF5149 MODULE QSQFETCH
   SI44919      OSP-DB-OTHER-MSGSQL0502 WHEN ODP/CURSOR IS REUSED IN A DIFFE
   SI44919      OSP-DB-OTHER-F/QSQXCUTE-T/QSQXCUTE-MSGMCH3601 MSGMCH3601 F/Q
   SI44884      OSP-DB-OTHER-F/QSQRUN4-MSGMCH0601 A MSGMCH0601 F/QSQRUN4 FMO
   SI44824      OSP-DB-INCORROUT QRECOVERY/QSQ901S SQL statement text
   SI44793      OSP-DB-MSGSQL0904 type 8 with 3 part named statements
   SI44716      OSP-DB table incorrectly searched on local sytem insted of r
   SI44668      OSP-DB table incorrectly searched on local sytem insted of r
   SI44527      OSP-DB-OTHER-T/QSQJOBTM-MSGCPF5715
   SI44436      OSP-DB-OTHER-UNPRED STORAGE LEAK USING SELECT FROM INSERT
   SI44343      OSP-DB-OTHER-F/QSQFETCH-RC5521-MSGSQL0901
   SI44215      OSP-DB-INCORROUT-MSGSQL0204 DELETE using an ALIAS
   SI44190      OSP-DB-QSQPREP-MSGMCH3402 when using a restored package
   SI44190      OSP-DB-OTHER-INCORROUT INCORROUT, SQL RUNS AGAINST WRONG FIL
   SI44082      OSP-DB-MSGMCH0601-T/QSQSBAS MODULE QSQCLSCR PROCEDURE SQCLOS
   SI44070      OSP-DB-OTHER-F/QSQRUN1-T/QSQRUN1-MSGSQL0519 RUNNING A PROGRA
   SI44010      OSP-DB OPEN/FETCH QUERY DATA PARTIAL ROW FIXES
   SI43955      OSP-DB-OTHER VARIOUS FIXES FOR SELECT FROM INSERT
   SI43849      OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-RC3577-MSGSQL0901 SQL STATE
   SI43802      OSP-DB-OTHER VARIOUS FIXES FOR SELECT FROM INSERT
   SI43802      OSP-DB-OTHER-T/QSQSBAS2-MSGCPF5813 MODULE QSQSFCRT
   SI43718      OSP-MSGSQL0913 MERGE INTO STATEMENT FAILS WITH SQL0913
   SI43696      OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-MSGSQL0304 PREPARES DONE IN
   SI43682      OSP-DB-OTHER-INCORROUT SQL FROM FILE NOT GETTING DATA FROM C
   SI43598      OSP-DB-QSQPREP-MSGSQL0904 Resource limit exceeded using DRDA
   SI43592      OSP-OTHER-INCORROUT FETCH FROM A CURSOR RETURNS DATA THE FIR
   SI43427      OSP-DB-OTHER-INCORROUT ADD CONSTRAINT NAME INFORMATION TO TH
   SI43401      OSP-DB-OTHER-F/QQQSRVE1-T/QQQSRVE1-MSGMCH1210 AFTER UPGRADE
   SI43351      OSP-DB-OTHER-MSGSQL0913 SERVICEABILITY CHANGE
   SI43351      OSP-DB-OTHER-T/QRWSQRY-MSGMCH3601
   SI43351      OSP-DB JOB LOCKS PART OF AN ACCESS PLAN AND OTHER JOBS GET M
   SI43290      OSP-DB-QSQOPEN File opens occur when setaspgrp is used
   SI43130      OSP-DB-MSGSQL0204 when using an alias for 3 part name
   SI43112      OSP-DB-PERFM Pseudo open failed
   SI42982      OSP-DB Connect By support
   SI42831      OSP-DB-QSQCMPDS High CPU during long running job
   SI42814      OSP-DB-OTHER-INCORROUT ACCESSING FILE AFTER IT IS REDEFINED
   SI42814      OSP-DB-OTHER-F/RMSLLOCKSPACELOC-T/QSQRUN1-MSGMCH5804 MSGMCH5
   SI42814      OSP-DB ADD QSQBIGPSA data area support
   SI42675      OSP-DB Incorrect column from CLOB in UPDATE WHERE CURRENT OF
   SI42460      OSP-DB-OTHER-INCORROUT MISMATCH BETWEEN NUMBER OF FIELDS AND
   SI42460      OSP-DB-QSQOPEN-MSGSQL0901 ALTER TABLE fails involving a long
   SI42460      OSP-DB-MSGSQL0150 during ALTER MQT or REFRESH TABLE
   SI42460      OSP-DB-MSGSQL0104 Diagnostic Message During Prepares
   SI42460      OSP-DB-QSQPREP-MSGSQL0904 Resource Limit Exceeded error on l
   SI42460      OSP-DB-QSQLOPEN-MSGMCH1210 on OPEN in SQL program
   SI42340      OSP-DB-MSGCPF4268 SQL SET global variable to SELECT from INS
   SI42276      OSP-DB-OTHER-WAIT LOCKING ISSUE TRYING TO GET A LENR LOCK ON
   SI42247      SQL exception occurred calling trigger on long running job
   SI42200      OSP-DB-OTHER-SAP400-F/QTNOPNCLS-RCX/5525-MSGCPF4327 UPGRADE
   SI42107      OSP-DB-OTHER-MSGSQL0301 USING THE DB2 FOR WINDOWS IMPORT FUN
   SI42088      OSP-DB-OTHER-F/QSQCRTT-T/QSQCRTT-MSGSQL0601 CALLING THE SAME
   SI41959      OSP-DB-OTHER-UNPRED WRONG VALUE IN QQI4 WHEN QQRID = 1000
   SI41959      OSP-DB-OTHER-T/QSQRUN3-MSGSQL0420 WITH MSGSQL0420 ISSUED, TH
   SI41892      OSP-DB-MSGSQL7054
   SI41873      OSP-DB-OTHER-F/QSQROUTE-T/QSQROUTE-MSGMCH3601 STORED PROCEDU
   SI41714      OSP-DB-OTHER-F/QSQRUN3-RC2118-MSGSQL0901
   SI41635      OSP-DB MSGSQL0501 F/QSQRUN4 MOD/QSQCLS PROC/CLEANUP STMT/479
   SI41635      OSP-DB-OTHER-F/QSQRUN3-MSGSQL7917 MODULE QSQRUN3
   SI41635      OSP-DB-OTHER-PERFM INSERTING INTO TABLE WITH LONG NAME
   SI41635      OSP-DB-OTHER-UNPRED SERVICEABILITY ENHANCEMENT
   SI41578      OSP-DB-UNPRED Three part statement text not displaying in DB
   SI41542      OSP-DB-INCORROUT-MSGSQL5011 SQL did not fail when it should
   SI41435      OSP-DB-OTHER-F/QQQVSEL-T/QSQRUN1-RC7-MSGCPD4329 SELECT FROM
   SI41432      OSP-DB-OTHER-MSGSQL0304 SQL0304 ENCOUNTERED WITH USING DRDA.
   SI41431      OSP-DB-UNPRED Universal driver for JDBC fails in static desc
   SI41417      OSP-DB-INCORROUT VISUAL EXPLAIN OF MERGE FAILS
   SI41417      OSP-DB-MSGMCH3402 F/QSQPREP SET GLOBAL VARIABLE EQUAL SELECT
   SI41385      OSP-DB-UNPRED DRDA prepare attribute string invalid
   SI41383      OSP-DB-INCORROUT Expressions in CALL Support
   SI41354      OSP-DB Internal Maintenance
   SI41316      OSP-DB-UNPRED Failure when repreparing three-part naming sta
   SI41296      OSP-DP-QSQCLS-MSGSQL0501 for allocated cursor using DRDA
   SI41263      OSP-DB-INCORROUT Expressions in CALL support
   SI41228      OSP-DB-OTHER-F/QSQCLOSE-MSGCPF9898
   SI41230      OSP-DB-UNPRED Reprepare of DRDA cursors when open attributes
   SI41219      OSP-DB-OTHER-PERFM INSERTING INTO TABLE WITH LONG NAME
   SI41219      OSP-DB SQ EXIT PROGRAM FAILED AND ENDED QDBXRVXR2.
   SI41219      OSP-DB-OTHER-UNPRED AF AUDIT JOURNAL ENTRIES FOR OBJECT QADB
   SI41202      OSP-DB-MSGSQL0904 TYPE=7 RC=167 MERGE USING ONLY DELETE
   SI41084      OSP-DB-INCORROUT DESCRIBE OF STATIC SELECT FROM INSERT RETUR
   SI40973      OSP-DB-OTHER-F/QDMCLOSE-MSGMCH6216
   SI40940      OSP-DB-MSGSQL0901 F/QSQRUN3/QSQINS FOR JOBS RUNNING MULTIPLE
   SI40929      OSP-DB-INCORROUT Expressions in CALL Support
   SI40807      OSP-DB-QSQDSCPR DB2_RESULT_SET_ROWS not set
   SI40699      OSP-DB-UNPRED Three part alias statement rewrite
   SI40667      OSP-DB-UNPRED Three part alias statement rewrite
   SI40609      OSP-DB-UNPRED Three part alias statement rewrite
   SI40527      OSP-DB Incorrect failure info for insert
   SI40510      OSP-DB-INCORROUT Array Support
   SI40503      OSP-DB-OTHER-MSGMCH1210 running SELECT after a SELECT FROM I
   SI40499      OSP-DB-MSGMCH1210-T/QSQINS with sql application
   SI40492      OSP-DB-OTHER-MSGMCH1210 running SELECT FROM INSERT and inser
   SI40455      OSP-DB-UNPRED Describe three-part cursor failing
   SI40443      OSP-DB-MSGMCH3402-T/QSQCLOSE with java application
   SI40411      OSP-DB QM QUERY FAILS WITH MCH1210
   SI40385      OSP-DB MSGMCH3601 T/QSQPREP running MERGE repeatedly
   SI40372      OSP-DB-UNPRED SQL procedures using DRDA selecting wrong sect
   SI40370      OSP-DB-QSQDSCPR-MSGSQL0206 on DESCRIBE PROCEDURE to LUW
   SI40337      OSP-DB-INCORROUT Array Support
   SI40317      OSP-DB-OTHER-PERFM HIGHER CPU USAGE ON QSQSRVR JOBS
   SI40317      OSP-DB-OTHER-MSGSQL0511 WHEN STMT CONTAINS FOR UPDATE OF COL
   SI40317      OSP-PERFM TEMPORARY STORAGE GROWTH/LEAK
   SI40290      OSP-DB-MSGMCH3601 F/QQQQUERY PROCEDURE CHECK_RESTRICTIONS FO
   SI40285      OSP-DB-UNPRED SQL statements not picking up table to alias c
   SI40248      OSP-DB Internal Maintenance
   SI40172      OSP-DB-MSGSQL0501 on result set cursor
   SI40163      OSP-DB-MSGCPD4331 F/QQQSRVV1 QQQVFILE SELECT FROM INSERT OF
   SI40153      OSP-DB-OTHER Expressions in CALL Support
   SI40048      OSP-DB Internal Maintenance
   SI39999      OSP-DB various errros when using hetero client
   SI39998      OSP-DB-QSQPROC-MSGSQL0204 when dropping routine using specif
   SI39957      OSP-DB-QSQLCLSE-MSGMCH3601
   SI39952      OSP-DB Internal Maintenance
   SI39896      OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0502 WEB APPLICATION
   SI39889      OSP-DB DB2ROW trigger inserts unexpected rows with MERGE sta
   SI39888      OSP-DB Internal Maintenance
   SI39836      OSP-DB-OTHER-T/QTNOPEN-MSGMCH3203
   SI39836      OSP-DB-OTHER-T/QSQCLI-MSGMCH0601 MODULE SQLED
   SI39836      OSP-DB-OTHER-F/#CCEXCEP-T/QSQSBAS-MSGMCH5003 INSERT USING SE
   SI39832      OSP-DB-MSGMCH3601 F/QQQSQCMP FROM SELECT FROM INSERT STATEME
   SI39827      OSP-DB Allow system triggers use SIGNAL to communicate with
   SI39733      OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0332 SELECT FROM INSE
   SI39711      OSP-DB-UNPRED Java stored procedure result sets failing over
   SI39707      OSP-DB-MSGSQL0518 when MERGE statement run repeatedly
   SI39698      OSP-DB-OTHER-F/QSQROUTS-T/QSQROUTS-MSGSQL0518 SELECT FROM IN
   SI39665      OSP-DB-MSGMCH1210-T/QQQQUERY with inflate table
   SI39638      OSP-DB-MSGSQL0313 F/QSQRUN3 RPGLE PROGRAM USING DESCRIPTORS
   SI39563      OSP-DB-MSGSQL0112 with xml functions
   SI39552      OSP-DB-INCORROUT Array Support
   SI39445      OSP-DB-UNPRED Java stored procedure result sets failing over
   SI39424      OSP-DB-OTHER-F/QQQQUERY BUILDAP-T/QQQQUERY BUILDAP-MSGMCH060
   SI39393      OSP-DB Extended indicators used in INSERT with subselect
   SI39348      OSP-DB-OTHER-F/QSQROUTX-T/QSQROUTX-MSGSQL0313 SELECT FROM FI
   SI39270      OSP-DB wrong count of parameter markers
   SI39215      OSP-DB-OTHER-F/QSQRUN1-T/QSQRUN1-MSGMCH3601 JOB FAILS WITH M
   SI39210      OSP-DB-MSGMCH3601 F/QSQINS EX2401PTRDOESNOTEXIST INSERT FROM
   SI39206      OSP-DB-OTHER-SAP400-F/QSQRUN3-T/QSQRUN3-MSGSQL0551 SQLPKG CO
   SI39186      OSP-DB-QSQPREP-MSGSQL0904 Resource Limit Exceeded errors whe
   SI39173      OSP-DB Internal Maintenance
   SI39128      OSP-DB Internal Maintenance
   SI39114      OSP-DB-OTHER-T/QSQSBAS-MSGMCH3601 MODULE QSQHDCLS
   SI39092      OSP-DB-INCORROUT ADDITIONAL HARDCLOSES IN FROM DYNAMIC SQL S
   SI39053      OSP-DB Temp storage grows inserting LOB
   SI38982      OSP-DB Internal Maintenance
   SI38923      OSP-DB Internal Maintenance
   SI38921      OSP-DB Internal Maintenance
   SI38916      OSP-DB-QSQDSCPR-MSGMCH1210 on DESCRIBE PROCEDURE or ASSOCIAT
   SI38855      OSP-DB-MSGSQL0811 EXECUTE IMMEDIATE SET GLOBAL VARIABLE = SE
   SI38813      OSP-DB Internal Maintenance
   SI38801      OSP-DB-MSGSQL0303 replacement text wrong
   SI38758      OSP-DB MCH5804 WILL SWITCH THE OUT QUEUE TO QEZDEBUG TO DUMP
   SI38749      OSP-DB Internal Maintenance
   SI38732      OSP-DB-OTHER SQ Internal Maintenance
   SI38696      OSP-DB-MSGSQL0518 in drda job
   SI38657      OSP-DB Internal Maintenance
   SI38590      OSP-DB-MSGMCH3601 F/QSQRUN2 MODULE/QSQVALUE F_MAP QUERY USIN
   SI38570      OSP-DB-OTHER-F/QDMIFERR-T/QSQRUN3-MSGCPF5149
   SI38506      OSP-DB DESCRIBE parameter marker incorrect with INSERT in ME
   SI38506      OSP-DB-MSGSQL0952 when using three part names with MERGE
   SI38477      OSP-DB-MSGMCH3601-T/QSQPREP
   SI38468      OSP-DB Internal Maintenance
   SI38443      OSP-DB Internal Maintenance
   SI38371      OSP-DB-INCORROUT Extended Indicator Support
   SI38370      OSP-DB-INCORROUT Extended Indicator Support
   SI38350      OSP-DB-MSGSQL0901 Repeated SELECT from INSERT
   SI38295      OSP-DB-MSGMCH3601 F/QSQROUTA SET GLOBAL VARIABLE = DEFAULT I
   SI38164      OSP-DB-OTHER-UNPRED DB2_NUMBER_ROWS SQLERRD2 NOT SET FOR SEN
   SI38099      OSP-DB Internal Maintenance
   SI38070      OSP-DB-OTHER-UNPRED DB2_NUMBER_ROWS SQLERRD2 NOT SET FOR SEN
   SI38022      OSP-DB-OTHER CONCURRENT ACCESS RESOLUTION
   SI38005      OSP-DB-INCORROUT SQL UPDATE WITH GLOBAL VARIABLES AND MIXTUR
   SI37980      OSP-DB-QSQPREP-MSGSQL0101 with large query
   SI37980      OSP-DB-OTHER-THREADS-F/QSQRUN3-T/QSQRUN3-MSGSQL0180 TRIGGER
   SI37964      OSP-INCORROUT INCORRECT NUMBER OF RECORDS RETURNED WHEN RUNN
   SI37888      OSP-DB-MSGSQL0518 repeatedly running prepared MERGE
   SI37841      OSP-DB-MSGSQL0901-F/QSQOPEN Array Support
   SI37804      OSP-DB-MSGSQL0901 when UDTF referenced in SELECT FROM INSERT
   SI37756      OSP-DB-MSGMCH3601 T/QSQPREP for delayed PREPARE of MERGE sta
   SI37710      OSP-DB-OTHER-F/QSQCLOSE-T/QSQCLOSE-MSGCPF9898
   SI37689      OSP-F/QSQSTATS-T/QSQSTATS-MSGMCH1210 JOBS FAILING WITH MCH12
   SI37661      OSP-F/QSQSTATS-T/QSQSTATS-MSGMCH1210 JOBS FAILING WITH MCH12
   SI37642      OSP-DB-QSQCLOSE-MSGMCH1001 in QSQCLOSE
   SI37611      OSP-DB-PERFM ENHANCE SERVICEABILITY. TRAP WHEN SWSC DESTROYE
   SI37608      OSP-DB-INCORROUT GLOBAL VARIABLES IN DYNAMIC SET PATH AND EN
   SI37595      OSP-DB DESCRIBE parameter marker in UPDATE of MERGE incorrec
   SI37559      OSP-DB-OTHER-SAP400-UNPRED AFTER AN ALTER TABLE PRIMARY CONS
   SI37458      OSP-DB-INCORROUT REUSE OF STATEMENT CONTAINING GLOBAL VARIAB
   SI37403      OSP-DB-MSGSQL7049 when running with result sets
   SI37388      OSP-DB Internal Maintenance
   SI37378      OSP-DB Internal Maintenance
   SI37373      OSP-DB-MSGMCH3601-F/QSQFETCH Array Support
   SI37326      OSP-DB-MSGMCH5003 F/QQQOOOSETS WHEN REUSING STATEMENTS REFER
   SI37254      OSP-DB CPF4272 SQL0901 when MERGE run repeatedly
   SI37250      OSP-DB-MSGSQL0901 F/QSQPREP FOR A PREPARED STATEMENT AFTER G
   SI37220      OSP AFTER SEVERAL INSERTS BEING DONE IN A SINGLE JOB - THE J
   SI37219      OSP-DB Internal Maintenance
   SI37199      OSP-DB-MSGSQL0901-F/QSQCALLSP Array Support
   SI37170      OSP-DB XML PROCESSING
   SI37130      OSP-DB-OTHER-MSGSQL0913 LOCK ON OBJECT SQLSWSCNNN
   SI37130      OSP-DB-OTHER-F/QSQSBAS2-T/QSQSBAS2-MSGMCH0601 MSGMCH0601 SPA
   SI37130      OSP-DB-OTHER-PERFM A LOT OF TIME SPENT IN QSQCMPDS
   SI37122      OSP-DB SQL0137 running MERGE statement many times
   SI37035      OSP-DB-MSGMCH3601-F/QSQNNNNN
   SI37019      OSP-DB-MSGSQL0901-F/QSQOPEN Array Support
   SI36978      OSP-DB-MSGMCH3601-F/QRWSDSCD Extended dynamic failures
   SI36865      OSP DB GLOBAL VARIABLE PROCESSING
   SI36806      OSP-DB INTERNAL MAINTENANCE
   SI36777      OSP-DB-UNPRED DRDA errors
   SI36727      OSP-DB-OTHER-INCORROUT INSERT USING JDBC REQUESTING GENERATE
   SI36727      OSP-T/QSQRUN3-MSGMCH3203 MSGMCH3203 F/KEDCONVERT T/QSQRUN3 X
   SI36658      OSP-DB-UNPRED DRDA errors
   SI36629      OSP-DB XML processing of SQLXSR objects
   SI36614      OSP-T/QSQRUN3-MSGSQL0502 JOB FAILING WITH MSGSQL0502 T/QSQRU
   SI36614      DB issue 42286: MCH0601 f/t QSQCLI running complex queries u
   SI36572      UPDATE with expression in MERGE does not change column value
   SI36524      OSP-DB XML PROCESSING
   SI36518      OSP-DB-UNPRED Force FDOCA mode for DATE/TIME in SPRS
   SI36550      OSP DB GLOBAL VARIABLE PROCESSING

Summary Information

System..............................i
Models..............................
Release.............................V7R1M0
Licensed Program...............5770SS1
APAR Fixed..........................View details for APAR SE70038
Superseded by:......................
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................NONE


IBM 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, 2014, 2015, 2016, 2017, 2018, 2019, 2020 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.

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1","Product":{"code":"SG15V","label":"PTF Cover Letters - OS\/400 General"},"Component":"5770SS1","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1","Product":{"code":"SG16D","label":"PTF Cover Letters - IBM i 7.1 environment"},"Component":"5770SS1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
07 March 2020